top of page

Microsoft Power BI DAX and Data Modeling

IPA-M102

Microsoft Power BI DAX and Data Modeling

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