DAX Power Pivot – 10 Easy Steps for Intermediates

Build Power Pivot Data Models with Excel 2016 Power Query – take your DAX Business Intelligence to the next level

Created by: Gilly Dow
IT Training Consultant

What Will I Learn?

• You will learn how to create a Data Model using Get & Transform in Excel
• Learn how to use "Disconnected" tables (Parameter tables) to maximise Insights
• Expand your understanding of the basic DAX Aggregator and Iterator Functions
• Understand the Initial Filter Context, Filter Context and Context Transition
• Gain confidence building measures with multiple functions - advancing your DAX tool-kit
• Learn how to catalogue your data model functions in Excel
• A BONUS section taking you through 7 Power Query examples of "messy" data and how to transform your data quickly and efficiently saving you time and repetition

Requirements

• This course is the next course in the DAX Power Pivot - 10 Easy Steps for Beginners and/or DAX Power Pivot Time Intelligence - 10 Easy Steps series and uses Excel 2016
• Your Excel environment will have access to Power Pivot
• IMPORTANT: You need a version of Excel that is compatible with Power Pivot (Excel 2013/2016/2019 Standalone, Office 365, Enterprise E3/E5, Office Professional 2016, etc.)
• This course is designed for PC users (Power Pivot is currently unavailable with Excel for Mac)

Target audience

• I have designed this course for those students who want to take the next step in their DAX Power Pivot journey
• You will know how to create Measures and have an understanding of building Data Model Relationships
• Your understanding of CALCULATE(), FILTER() & ALL() will lend itself well to your continuing education in this next step