MS 20768: Developing SQL Data Models

Important notice - this course has been retired

This course is retired.

Please look at new courses launched by Microsoft on this matter:

DA-100: Analyzing Data with Power BI

 

 

 

 

 

 

Audience:

The primary audience for this course are database professionals who need to fulfil 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

Prerequisites:

Before attending this course, students must have:

  • Experience of querying data using Transact-SQL

Course goals:

After completing this course, students will be able to:

  • 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

Read complete course description:
https://www.microsoft.com/en-us/learning/course.aspx?cid=20768

Certification:

This course maps directly to exam 70-768.