Academy Training: Power BI Data Modelling: DAX and Power Query (VIRTUAL)
This online training is designed for data modeler, who have the data prepared to be modelled for analysis. Usually, people who attend this virtual training needs to attend module 2 beforehand to learn about the step before the modelling. In this training, you will learn detailed modelling practices of Power BI, and DAX unleashed.
In the first day of this virtual course, you will learn all things about Power Query. You will learn Power Query from basic level with Getting data from different data sources. You will learn about different types of transformations available in Query Editor. Table transformations such as Pivot and Unpivot will be discussed, as well as specific column transformations such as date column transformations. You will also learn about M (Power Query Formula Language) in deep. Unique features such as error handling, generators, structured columns, custom functions and many other advanced level features of Power BI data transformations will be explored through hands-on labs and lecture.
In the second day of training, you will learn DAX. You will learn how to design the best model in Power BI with relationships, considering formatting and data types. You will learn about DAX which is the data modelling expression language in Power BI (and SSAS Tabular, and Power Pivot). You will learn from Simple DAX calculations to complex expressions and calculations for solving real-world challenges of a BI solution.
The training continues with more focus on DAX; we will talk about the evaluation context in DAX, which defines the mindset and the way of thinking when you are writing DAX expressions. You will learn about DAX function categories such as Aggregation functions, Iterators, Filter functions, parent-child functions, time intelligence functions, functions dealing with relationships, etc. You will learn all scenarios through hands-on examples of real-world data.
At the end of this online training, you will be able to design the proper data model in Power BI, understand all relationship requirements and implement the right relationship, write complex DAX expressions for your analytics need, and put them all together to build the best model for your data analysis solution using Power BI.
1: Get Data
2: Combine Queries
3: Reducing Number of Rows; Filtering
4: Column Operations
5: Table Transformations
6: Text, Numeric, Date and Time Transformations
7: Add Column Transformations
8: Functions and Parameters; Dynamic Power Query
9: Power Query Formula Language: M
10: Working with Data Structures in M
11: Advanced M Scripting
12: Error Handling
13: Use Cases
14: Power BI Modelling 101
15: Introduction to DAX
16: Calculations in Power BI
17: Aggregation and Iterator Functions
18: Filter Functions
19: Evaluation Contexts and Conditional Sum
20: Relationship Functions
21: Time Intelligence Functions
22: Dynamic DAX: Parameters
23: Parent-Child Functions
24: Scenario Based DAX
This class is online/virtual
Australia Time 9am-5pm
Instructor: Reza Rad, Microsoft MVP
Reza Rad is Microsoft Regional Director, a speaker in the world’s best and biggest Microsoft Data Platform, BI and Power BI conferences such as Microsoft Ignite, Microsoft Business Applications Summit, Microsoft Data Insight Summit, PASS Summits, PASS Rallys, SQLBits, TechEds, and so on. He is the author of books on this topic, and he has more than 20 years’ experience in Microsoft BI technologies. Reza is the founder of RADACAD and a consultant for more than decades. He is also a Microsoft Certified Trainer for years. He is Microsoft Data Platform MVP (Most Valuable Professional) focused on BI and Data Analysis; Microsoft has awarded him MVP because of his dedication and expertise in Microsoft BI technologies from 2011 till now (more than nine years). He is the author of the Power BI book from Rookie to Rock Star.