Power BI & DAX Mastery Guide (150+ Page eBook)

For users looking to take their Power BI skills to the next level, mastering Data Analysis Expressions (DAX) is a MUST. In this hands-on, project-based course, you'll put your DAX skills to the test and apply what you learn to some of the toughest real-world data analysis and business intelligence use cases.

FULL COURSE OUTLINE:

• Prerequisite Skills Review
• Refresh key DAX concepts such as evaluation context, filter flow, and measures.
• Course Project Introduction
• Get started with the Maven Roasters project and build a data model for analysis in Power BI Desktop.
• The DAX Engines
• Understand the DAX formula and storage engines, data types, VertiPaq encoding, and compression techniques.
• DAX Tips & Best Practices
• Learn formatting tips, how to add comments, handle errors, and use DAX variables effectively.
• Scalar Functions
• Explore commonly used DAX scalar functions for rounding, information, conversion, and logic.
• Advanced CALCULATE
• Dive into CALCULATE modifiers, context transitions, and interactions with tables.
• Table & Filter Functions
• Create calculated tables and use DAX filter functions to manipulate and generate new data.
• Calculated Table Joins
• Use functions like UNION, EXCEPT, and INTERSECT to create joins between physical and virtual tables.
• Relationship Functions
• Understand physical and virtual relationships, expanded tables, and commonly used relationship functions.
• Iterator ("X") Functions
• Study iterators, nested loops, context transitions, RANKX, and DAX calculation granularity.
• Advanced Time Intelligence
• Build custom date tables, compare time periods, and manage fiscal calendars using DAX.
• Sneak Peek: Performance Tuning
• Get introduced to DAX Studio, the Power BI Performance Analyzer, and key optimization techniques.

Join today and get to the following:

• 1-on-1 expert support
• Course Q&A forum