Share Description
In this course, 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.
- Build custom DAX Expressions to drop into any pivot.
- Use Slicers and Presentation Tips to create dashboard-worthy reports.
- 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
Syllabus :
- Group Work 1 Creating the Data Model
- Group Work 2 Creating Pivot Tables & Relationships
- Group Work 3 Adding Excel Data to the Data Model
- Group Work 4 Creating a Hierarchy
- Group Work 5 Calculated Columns & Measures
- Group Work 6 Measures in Excel
- Group Work 7 RELATED() & RELATEDTABLE()
- Group Work 8 COUNT() & DISTINCTCOUNT()
- Group Work 9 CALCULATE()
- Group Work 10 CALCULATE() with ALL()
