01 Jun

Academy - Power BI Rookie to Rock Star: Power BI for Data Modeler

Academy - Power BI Rookie to Rock Star: Power BI for Data Modeler

Monday, June 1, 2020 (11:00 AM) to Thursday, June 4, 2020 (3:00 PM) (Eastern Time)

Microsoft Teams
Reza Rad

...

You're Registered!
This class will be held over 4 days on June 1st, 2nd, 3rd, and 4th from 11am - 3pm  Eastern Time

This training is designed for data modeler, who have the data prepared to be modeled for analysis. Usually, people who attend this training needs to attend module 2 beforehand to learn about the step before the modeling. In this training, you will learn detailed modeling practices of Power BI, and DAX unleashed. 

In this two days training, you will learn DAX from zero to hero. 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 modeling 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 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. 

The training includes but not limited to topics below:
3.1: Power BI Modelling 101
3.2: Introduction to DAX
3.3: Calculations in Power BI
3.4: Aggregation and Iterator Functions
3.5: Filter Functions
3.6: Evaluation Contexts and Conditional Sum
3.7: Relationship Functions
3.8: Time Intelligence Functions
3.9: Dynamic DAX: Parameters
3.10: Parent-Child Functions
3.11: Best Practices Tips and Tricks 

You can view the full course description here

Reza Rad
Reza Rad is the world well-known name in the Microsoft BI field. Reza Rad is an invited speaker in world’s best and biggest SQL Server and BI conferences such as Microsoft Data Insight Summit, PASS Summits, PASS Rallys, SQLBits, TechEds, Ignites, and so on. He is an author of books on this topic, and he has more than 15 years’ experience in the Microsoft BI technologies. 10 years of his experience focused on training and consulting to the largest BI teams in the world. He is also Microsoft Certified Trainer for years. He is Microsoft SQL Server MVP (Most Valuable Professional) focused on BI and Data Analysis, He has been awarded MVP from Microsoft because of his dedication and expertise in Microsoft BI technologies. He is author of Power BI online book; from Rookie to Rock Star; www.radacad.com/online-book-power-bi-from-rookie-to-rockstar . Reza is Author of many other Power BI books, speaker, consultant and trainer. He trained thousands of Power BI users with his custom designed course. Reza is an active blogger about Power BI; he writes multiple blog posts every week about Power BI technical subjects.