We are happy to advise you!
1­-855­-778­-7246    Contact

Developing SQL Data Models (20768)


Course Content

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.


  • 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

Outline: Developing SQL Data Models (20768)

Module 1: Introduction to Business Intelligence and Data Modeling

  • Introduction to Business Intelligence
  • The Microsoft business intelligence platform

Module 2: Creating Multidimensional Databases

  • Introduction to multidimensional analysis
  • Creating data sources and data source views
  • Creating a cube
  • Overview of cube security

Module 3: Working with Cubes and Dimensions

  • Configuring dimensions
  • Define attribute hierarchies
  • Sorting and grouping attributes

Module 4: Working with Measures and Measure Groups

Module 5: Introduction to MDX

  • MDX fundamentals
  • Adding calculations to a cube
  • Using MDX to query a cube

Module 6: Customizing Cube Functionality

  • Key performance indicators
  • Actions
  • Perspectives
  • Translations

Module 7: Implementing a Tabular Data Model by Using Analysis Services

  • Introduction to tabular data models
  • Creating a tabular data model
  • Using an analysis services tabular model in an enterprise BI solution

Module 8: Introduction to Data Analysis Expression (DAX)

  • DAX fundamentals
  • Using DAX to create calculated columns and measures in a tabular data model

Module 9: Performing Predictive Analysis with Data Mining

  • Overview of data mining
  • Using the data mining add-in for Excel
  • Creating a custom data mining solution
  • Validating a data mining model
  • Connecting to and consuming a data mining model


  • Exploring a Data Warehouse
  • Creating a multidimensional database
  • Working with Cubes and Dimensions
  • Configuring Measures and Measure Groups
  • Using MDX
  • Customizing a Cube
  • Working with an Analysis services tabular data model
  • Creating Calculated Columns and Measures by using DAX
  • Perform Predictive Analysis with Data Mining
Online Training

Duration 3 days

  • CAD 2,895
  • SA Voucher: 3
Classroom Training

Duration 3 days

  • Canada: CAD 2,895
  • SA Voucher: 3
Click on town name or "Online Training" to book Schedule
This is an Instructor-Led Classroom course
Instructor-led Online Training:   This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
This is a FLEX course, which is delivered both virtually and in the classroom.
  *   This class is delivered by a partner.
United States

Currently there are no training dates scheduled for this course.  For enquiries please write to info@fastlaneca.com.