Virtual DAX Bootcamp
- Start: Mar 04, 2024 8:00 AM EST
- End: Mar 07, 2024 4:00 PM EST
- Cost: $1,995.00
- Instructor: Mitchell Pearson
- Event Categories:
- Available Seats: Limited seats remaining!
- Missed your change to sign up, but still want to get in on the fun? Contact us!
- Need help convincing your boss? We can help.
Event description
So you’ve been working with DAX in Power BI but either can’t quite complete the calculations needed or maybe you just want to expand your knowledge and utilize more capabilities of DAX to bring your reports to the next level – this is the course for you! In this in-depth DAX Bootcamp, all of your DAX knowledge will be enhanced to a point where you will have the tools to create any kind of calculation that is possible within the DAX language. You will also be learning about best practices, performance tuning, and much more!
Prerequisites
It is recommended that you have taken an Introduction to Power BI course first.
System Requirements
- Access to Power BI
- Access to DAX Studio
Course Outline:
- Day 1
- Module 01 – Designing a Data Model
- Day 2
- Module 02 – Basic DAX Syntax
- Module 03 – Calculated Measures
- Day 3
- Module 04 – Calculate Function and Filter Context
- Module 05 – Time Intelligence
- Module 06 – All Functions
- Module 07 – Working with Totals
- Module 08 – Role Playing Tables
- Day 4
- Module 09 – Semi-Additive Measures
- Module 10 – Context Transition
- Module 11 – Multiple Facts and Mismatched Granularities
- Module 12 – Weighted Allocation
- Module 13 – DAX Studio
Add an event to your calendar
Instructor – Mitchell Pearson
Mitchell Pearson has been with Pragmatic Works for 11 years as a Data Platform Consultant, Trainer and Team Lead. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform, Microsoft Azure and Fabric.