> > > 20768

Developing SQL Data Models (20768)

Course Description Schedule Course Outline
 

Course Overview

This three-day instructor-led course will teach you how to implement multidimensional databases and create tabular semantic data models for analysis with SQL Server Analysis Services (SSAS).

Who should attend

Database professionals and BI Developers working with enterprise BI solutions.

Prerequisites

  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of Transact-SQL
  • Working knowledge of relational databases

Course Objectives

  • Describe the components, architecture, and nature of a BI solution
  • Create a multidimensional database with analysis services
  • Implement dimensions in a cube
  • Implement measures and measure groups in a cube
  • Use MDX syntax
  • Customize a cube
  • Implement a tabular database
  • Use DAX to query a tabular model
  • Use data mining for predictive analysis

Follow On Courses

Classroom Training
Modality: G

Duration 3 days

Price (excl. VAT)
  • United Kingdom: £ 1,653.-
  • SA Voucher: 3
    hardcoded default SA
Enroll now
Online Training
Modality: U

Duration 3 days

Price (excl. VAT)
  • United Kingdom: £ 1,653.-
  • SA Voucher: 3
    hardcoded default SA
Enroll now
E-Learning MOC on Demand
Modality: P
Price (excl. VAT)
  • United Kingdom: £ 449.-
  • SA Voucher: 2
    hardcoded default SA
Buy E-Learning
 

Accessing our website tells us you are happy to receive all our cookies. However you can change your cookie settings at any time. Find out more.   Got it!