IIRF Online > Business > Business Analytics & Intelligence > Data Analysis Expressions (DAX) > DAX Power Pivot - 10 Easy Steps for Intermediates
DAX Power Pivot - 10 Easy Steps for Intermediates by Udemy
Build Power Pivot Data Models with Excel 2016 Power Query – take your DAX Business Intelligence to the next level
Course Highlights
- 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
Skills you will learn!
Curriculum
2 Topics
Introduction
Catalogue Your Measures
8 Topics
Objectives and a look at why Power Query is your new best friend
Get & Transform aka Power Query
Creating a Connection Only and Building Relationships
Importing New Queries
Editing Queries - EASILY!
Practice Exercise 1 - SOLUTIONS
Recap Objectives - Step 1
Step 1 - Quiz
6 Topics
Objectives and the Initial Filter Context
Aggregator Functions
"X" Functions
Practice Exercise 2 - SOLUTIONS
Recap Objectives - Step 2
Step 2 - Quiz
9 Topics
Step 3 Objectives
Step 3 - Filter Context
Filter Context & SUMX()
Sales of Yellow Products journey with CALCULATE() setup
The CALCULATE() journey explained
Practice Exercise 3A - SOLUTIONS
Practice Exercise 3B - SOLUTIONS
Recap Objectives - Step 3
Step 3 - Quiz
5 Topics
Step 4 Objectives
Context Transition - Deep Dive
Context Transition with Measures
Recap Objectives - Step 4
Step 4 - Quiz
6 Topics
Step 5 Objectives
Setting the scene for VALUES()
VALUES() as a parameter to SUMX()
Practice Exercise 5 - SOLUTIONS
Recap Objectives - Step 5
Step 5 - Quiz
9 Topics
Step 6 - Objectives
ALL() Refresher
ALL() with Table & ALL() with a Column
ALL() with Multiple Columns and ALLEXCEPT()
ALLSELECTED()
Practice Exercise 6 - SOLUTIONS Exercise 1 & 2
Practice Exercise 6 - SOLUTIONS Exercise 3 & 4
Recap Objectives - Step 6
Step 6 - Quiz
8 Topics
Step 7 - Objectives
Introduction to HASONEVALUE() Example 1
HASONEVALUE() Example 2
HASONEVALUE() & VALUE() working together
Handy Hint for Practice Exercise 7 - VALUES()
Practice Exercise 7 - SOLUTIONS
Recap Objectives - Step 7
Step 7 - Quiz
7 Topics
Step 8 - Objectives
Disconnected Tables & Harvester Measures
Formatting Slicers
Finishing what we Started in the Sales Report
Practice Exercise 8 - SOLUTIONS
Recap Objectives - Step 8
Step 8 - Quiz
12 Topics
Step 9 - Objectives
Thresholds
Completing the Customer Income Pivot with FILTER()
Practice Exercise 9A - SOLUTIONS
Introduction to Banding Pt 1
Banding Pt 2 - Creating the Conversion measures
Age Group Banding Pt 1
Age Group Banding Pt 2
Practice Exercise 9B - SOLUTIONS
Practice Exercise 9 - FastTrack Extra
Recap Objectives - Step 9
Step 9 - Quiz
8 Topics
Step 10 - Objectives
Report Overview & Budget Table Import
Importing the Budget Period Table and Creating Relationships
Report Measures including Budget Year-To-Date (DATESYTD)
Creating & Editing the KPI
Practice Exercise 10 - SOLUTIONS
Recap Objectives - Step 10
Step 10 - Quiz
4 Topics
CUBE Formulas
CUBEVALUES
Have you Catalogued?
How to Redeem a Discount Coupon
DAX Power Pivot - 10 Easy Steps for Intermediates
Related Data Analysis Expressions (DAX) Courses
Thank You!
Your review has been submitted successfully.