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!
Please note, you get extra 25% off with your Unlimited On-Demand Learning membership! If you are a member, please contact training@pragmaticworks.com to complete registration.
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
- Access to Vertipaq Analyzer (an Excel Power Pivot Workbook)
Course Outline:
- Module 01 – Understanding and Defining Relationships
- Module 02 – DAX Fundamentals
- Module 03 – Creating Calculated Columns
- Module 04 – Navigation Functions
- Module 05 – Conditional and Logical Functions
- Module 06 – Creating Calculated Measures
- Module 07 – Understanding the Calculate Function
- Module 08 – Built-in Time Intelligence
- Module 09 – Interactive Functions
- Module 10 – Table Functions
- Module 11 – Working with Variables
- Module 12 – Understanding Evaluation Context (Filter and Row Context)
- Module 13 – Nested Row Context
- Module 14 – Advanced Time Intelligence and Custom Calendars
- Module 15 – Semi-Additive Measures
- Module 16 – Error handling
- Module 17 – Managing Dynamic Security with DAX
- Module 18 – Dealing with Multiple Relationships Between Tables
- Module 19 – Advanced Design Patterns with DAX
- Module 20 – Performance Tuning
- Module 21 – DAX as a Query Language
The information you shared was useful. Thank you for taking the time to organize it.
ReplyDeleteThank you for your valuable feedback
Delete