• 11th Floor, Gulf Executive Office, Bldg. 15, Road 380, Blk. 338 P.O.Box 10602, Manama, Bahrain

  • +973 17746746

  • info@thinksmartbh.com

Program Details

Developing SQL Data Models

Course Description

It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups.

Audience profile
  • The primary audience for this course are database professionals who need to fulfill BI Developer role to create enterprise BI solutions.

Primary responsibilities will include:

  • Implementing multidimensional databases by using SQL Server Analysis Services.
  • Creating tabular semantic data models for analysis by using SQL Server Analysis Services.


  • 70-767:Implementing a Data Warehouse using SQL.

Course Outline

  • Module 1: Introduction to Business Intelligence and Data Modeling.
  • Module 2: Creating Multidimensional Databases.
  • Module 3: Working with Cubes and Dimensions.
  • Module 4: Working with Measures and Measure Groups.
  • Module 5: Introduction to MDX.
  • Module 6: Customizing Cube Functionality.
  • Module 7: Implementing a Tabular Data Model by Using Analysis Services.
  • Module 8: Introduction to Data Analysis Expression (DAX).
  • Module 9: Performing Predictive Analysis with Data Mining.

Exam Code / Name


Course Objectives

  • Design a multidimensional business intelligence (BI) semantic model
  • Design a tabular BI semantic model
  • Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX)
  • Configure and maintain SQL Server Analysis Services (SSAS)

Linked Program

MCSE: Data Management and Analytics