Developing SQL Data Models

This course is intended for business intelligence (BI) developers who focus on creating BI solutions that require implementing multidimensional data models, implementing and maintaining OLAP cubes, and implementing tabular data models.

Exam 70-768 Developing SQL Data Models

This course is intended for business intelligence (BI) developers who focus on creating BI solutions that require implementing multidimensional data models, implementing and maintaining OLAP cubes, and implementing tabular data models.

Course Content

 

Design a multidimensional business intelligence (BI) semantic model (25–30%)

  • Create a multidimensional database by using Microsoft SQL Server Analysis Services (SSAS)
  • Design and implement dimensions in a cube
  • Implement measures and measure groups in a cube

Design a tabular BI semantic model (20–25%)

  • Design and publish a tabular data model
  • Configure, manage, and secure a tabular model
  • Develop a tabular model to access data in near real time

Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX) (15–20%)

  • Create basic MDX queries
  • Implement custom MDX solutions
  • Create formulas by using the DAX language

Configure and maintain SQL Server Analysis Services (SSAS) (30–35%)

  • Plan and deploy SSAS
  • Monitor and optimize performance
  • Configure and manage processing

Create Key Performance Indicators (KPIs) and translations

JOIN AN UPCOMING CLASS FOR THIS COURSE