DAX Power Pivot – 10 Easy Steps for Beginners

Learn how to build DAX functions in PowerPivot with Excel 2016. Reinforce and embed with practice exercises/solutions

Created by: Gilly Dow
IT Training Consultant

What Will I Learn?

• Import data into the Power Pivot Data Model using Excel 2016
• Import and edit data from Microsoft Access and Microsoft Excel
• Build Relationships between Data Tables
• Create Hierarchies for end-user filtering convenience
• Shape the Data Model with Calculated Columns & Measures
• Create DAX Expressions including: SUM(), RELATED(), RELATEDTABLE(), COUNT(), DISTINCTCOUNT(), MONTH(), DATE(), CALCULATE(), ALL()
• Build custom DAX Expressions to drop into any pivot
• Create Dashboard worthy reports with Slicers and Presentation tips
• Download the step-by-step user guide with practice exercises and solutions
• Import existing Excel data and Link Excel data into the Data Model
• Create Calculated Columns and Measures in the Data Model
• Create Measures in Excel
• Create Calculated Columns with RELATED() & RELATEDTABLE() DAX Functions
• Create Measures using the COUNT() & DISTINCTCOUNT DAX Functions
• Create Measures using the CALCULATE() DAX Function to modify the Filter Context of Pivot Tables
• Create static values for Ratio creation with CALCULATE() & ALL() DAX Functions
• Create a Date Table (Calendar) in Excel and Relate to the Data Model for Time Intelligence functionality

Requirements

• Students will have an understanding of Excel Pivot Tables
• It's helpful to have a basic understanding of relational database concepts
• Please ensure you have the Power Pivot Add-in installed and the Power Pivot Menu visible in the main Excel window
• 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

• For all Excel enthusiasts who consolidate or manipulate data repetitively OR use VLOOKUP a lot!
• For all those who want to be at the forefront of the Big Data, Business Intelligence concept
• For all those who want to adapt a report in seconds when stakeholders objectives change
• Students may have an understanding of Power Pivot but want to consolidate their knowledge with practical examples and practice exercises
• For all those who want super-hero status amongst their colleagues