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
4.68 (1909 reviews)
6,405
students
6.5 hours
content
Mar 2019
last update
$74.99
regular price
What you will 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
Related Topics
980248
udemy ID
10/10/2016
course created date
4/4/2020
course indexed date
Bot
course submited by