Course Overview
Schedule Dates
The course Developing SQL Data Models (20768-C) is primarily intended for database professionals who need to fulfill a Business Intelligence Developer role. This course is also suitable for individuals who develop and maintain SQL Server Analysis Services (SSAS) multidimensional models and/or tabular models for their organizations.
The 20768-C course is designed for database professionals who need to fulfill a Business Intelligence Developer role. This course is intended for individuals who design and build relational database models and who are responsible for data retrieval and analysis, as well as designing and building multi-dimensional databases, and creating tabular semantic data models.
By taking this course, participants will gain the skills and knowledge required to design and implement a database solution that supports their business intelligence needs. They will learn how to create multidimensional data models, implement tabular data models, deploy SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) solutions, and implement self-service BI solutions. Participants will also learn how to optimize their BI infrastructure, and how to create dashboards and scorecards to visualize data.
Yes, participants who successfully complete the Developing SQL Data Models (20768-C) course will receive a certificate of completion from Microsoft. Additionally, this course also helps prepare participants for the Microsoft Certification Exam 70-768: Developing SQL Data Models, which is one of the exams required to earn the MCSA: SQL 2016 BI Development certification.
The Developing SQL Data Models (20768-C) course covers the following topics:
- Introduction to Business Intelligence and Data Modeling
- Creating Multidimensional Databases
- Working with Cubes and Dimensions
- Working with Measures and Measure Groups
- Introduction to MDX
- Customizing Cube Functionality
- Implementing Tabular Data Models
- Introduction to DAX
- Advanced DAX
- Implementing an Analysis Services Tabular Data Model
- Creating Data Visualizations with Power BI
In this course, participants will also learn how to create multidimensional and tabular data models, as well as how to work with measures, dimensions, and hierarchies. Participants will also learn how to customize cube functionality using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX). Finally, participants will learn how to create data visualizations using Power BI.
- Introduction to Business Intelligence and Data Modeling
- Creating Multidimensional Databases
- Working with Cubes and Dimensions
- Working with Measures and Measure Groups
- Introduction to MDX
- Customizing Cube Functionality
- Implementing Tabular Data Models
- Introduction to DAX
- Advanced DAX
- Implementing an Analysis Services Tabular Data Model
- Creating Data Visualizations with Power BI
In this course, participants will also learn how to create multidimensional and tabular data models, as well as how to work with measures, dimensions, and hierarchies. Participants will also learn how to customize cube functionality using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX). Finally, participants will learn how to create data visualizations using Power BI.