DAX Power Pivot 10 Easy Steps for Advanced Users
Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: aac, 44100 Hz
Language: English | VTT | Size: 5.62 GB | Duration: 13 section | 85 lectures | (9h 11m)
What you'll learn
Work with Multiple Data Tables
Build complex calculations with Variables
Gain Insights with RANKX() & TOPN()
Work with Differing Granularities
Use Budget Patterns
Budget vs Actuals
Requirements
Power Pivot must be enabled and visible as a Ribbon Tab
You know how to create a Data Model
You recognise the term Initial Filter Context
You understand CALCULATE()
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)
Description
Are you ready to take your DAX skills to the next level? My new DAX Power Pivot - 10 Easy Steps for Advanced Users follows on from the my previous "10 Easy Steps" series to enable you to increase the complexity of your data models and progress to creating and understanding more complex calculations.
I have created this course specifically for those students who have taken my Beginners and Intermediates courses where you have learned the fundamentals necessary to transition into more advanced concepts enabling you to build bigger data models and create more complex calculations.
By helping you to understand evaluation context will help you "think" like DAX. When you have this understanding you'll be in a better position to troubleshoot when things don't go according to plan.
Course Contents
Warm Up
Variables
Row & Filter Context
Static Segmentation
Multiple Data Tables
RANKX() & TOPN()
Different Granularities
Budget vs Actuals
Budget Patterns (Single Year)
Budget Patterns (Multiple Years)
Budgets (Monthly)
I provide examples that we work through together. Then it's over to you with practice exercises to help you embed and consolidate your skills. You receive all the group work and exercise files and a fully supporting, diagram rich user guide pdf. I always provide video solutions - so, you're never on your own.
Still not sure? Here's what others have had to say about my "10 Easy Steps" series of courses:
DAX Power Pivot - 10 Easy Step for Advanced Users
"Once again, a masterpiece from Gilly to guide through the journey of advanced DAX. Step by Step diving deeper into DAX logic without loosing the line thanks to the outstanding effort of a well structured course which come along with a clear guideline, recaps and exercises to be able to adapt to own projects soon. Thanks so much Gilly!"
Doris.
DAX Power Pivot - 10 Easy Step for Advanced Users
"Another excellent course by Gilly. Covers a range of topics clearly and thoughtfully with challenging and interesting practice exercises."
Gary F.
DAX Power Pivot - 10 Easy Steps for Beginners
"I thought that I was intermediate on this topic, so didn't bother buying the beginner course. However, getting stuck part way through the intermediate course, I decided to complete the beginner course.
