Microsoft Power BI DAX and Data Modeling
IPA-M102

Basic data models are simple to construct using Power BI Desktop. However, Data Analysis Expressions are required if you wish to report across time periods—for example, to display year-over-year growth or to compare sales or other data by month or quarter (DAX). DAX is a programming language for creating Power BI calculations that extend your data model.
Learn how to use DAX aggregate functions and add calculated columns, build measurements, and use DAX logical and filter functions and recommended practices for data model construction and optimization.
Whether you're using Power BI Desktop, Power Pivot in Excel, or Analysis Services, learning Data Analysis Expressions (DAX) is essential to creating effective data models.
Training Duration: 5 Days
OVERVIEW
This workshop is a complete course about the DAX language. DAX is the native language of Power BI, Power Pivot for Excel, and SSAS Tabular models in Microsoft SQL Server Analysis Services.
This Power BI training for DAX is aimed at users of Power BI, Power Pivot for Excel, and at Analysis Services developers that want to learn and master the DAX language. This course covers the latest version of DAX 2019.
This workshop is a complete course about building the most optimal data models for your Power BI reports. It introduces the audience to the basic techniques of shaping data models in Power BI. It offers many real-world examples that will help you look at your reports in a different way – pretty much like experienced data modelers do.
OBJECTIVES
After completing this course, students will be able to:
Understand all the features of the DAX language
Write formulas for common and advanced scenarios
Learn the vast techniques of shaping and building a correct data model to be used in Power BI.
Understand the common challenges and mistakes that people have in creating a data model.
Learn the most optimum way of building a sustainable data model for Power BI reports
PREREQUISITES
Attendees need to have a basic knowledge of the data modeling in Power Pivot for Excel, or Power BI Desktop, or Analysis Services Tabular modeling.
AUDIENCE
The intended audience would be for those who have taken the Microsoft Power BI course and would love to continue to explore formulas and calculations in Microsoft Power BI.
COURSE MODULES