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