DAX Power Pivot 10 Easy Steps for Advanced Users
- 9 hours on-demand video
- 1 downloadable resource
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- 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
- 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)
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.
Row & Filter Context
Multiple Data Tables
RANKX() & TOPN()
Budget vs Actuals
Budget Patterns (Single Year)
Budget Patterns (Multiple Years)
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!"
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."
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. Boy am I glad I did - it has really consolidated things for me, and was well worth the money. If you haven't taken any of Gilly's courses before I can highly recommend them - she is super enthusiastic, keen, knowledgeable, and very responsive. If you only take one DAX course as a beginner, make it this one”.
DAX Power Pivot Time Intelligence – 10 Easy Steps
“Great Course from Gilly. Her courses are a masterpiece and this subject was a tough one but she does a good job in explaining it Step By Step. Going by her own words you need practice to master it but at least I am happy the foundation is being laid with strong understanding to move forward. Thanks so much Gilly”
DAX Power Pivot – 10 Easy Steps for Intermediates
“It is obvious that Gilly has spent a lot of time with her study guide and organization of this class. This is one of the best illustrated courses I've found on Udemy. Explanations of the DAX formulas are very clear and flow logically throughout the course. The concepts discussed are easily at the Intermediate level as advertised. Truly an exceptional effort by Gilly Dow.”
Power Pivot is the perfect tool for those working in finance, statistics, project, business and market analysis or any data reporting role who have a need to create and produce Business Intelligence style Dashboard and Insight reports.
I have used Excel 2016 to demonstrate this fantastic tool but you can follow along in Excel 2010 & 2013 - I'll do my best to point out the differences. If you have any questions about the course, feel free to message me here or check out the FREE preview lectures to learn more.
Thanks for taking the time to check out my course. I can't wait to help you take the next step in developing your DAX skills.
Take the first steps to a new and rewarding future by clicking on the TAKE THIS COURSE button, located on the top right corner of the page.
- DAX Power Pivot 10 Easy Steps for Beginners students
- DAX Power Pivot Time Intelligence 10 Easy Steps students
- DAX Power Pivot 10 Easy Steps for Intermediate students
- Business Analysts and/or Intelligence Developers and Data Scientists who are confident with DAX fundamentals
You will blow away the cobwebs and build a Data Model to display Year-On-Year % growth for a small company selling Masks... could you do this without a little help?
Rules just have to be broken and with the help of Iterator functions you can "manufacture" Row Context to limit the number of calculations you may need. Remember, you're reinforcing your knowledge and understanding whilst you build up to more complicated measures and calculations...
Let's take a quick tea break and quickly recap what you have just learned. It's quite a milestone you have achieved in your DAX journey and getting the basics right will help you tackle more complex scenarios that you will face later in the course. Make sure you're on track and raring to go!
In this next video lecture I demonstrate how easy DAX enables you to rank student sales. Using the DAX RANKX() function you will learn how to manipulate the default settings to display exactly what you need to correctly display "ties" in sales amounts and avoid "gapping" in RANKX() results
Ok, that was a bit tricky! You're "logical reasoning" was tested BUT the results in our Enrolments table were very insightful. You may not need these "powers" on a day-to-day basis - however, employing logic is never too far away when and if you want to be a DAX ninja! Take a few minutes to consolidate what you've just achieved. It will embed your understanding, answer any queries that may still be lurking AND you might just pick up a couple of hints for the quiz!
What do you do when you receive a new Data table source which doesn't match the time period of your primary Data table? You need to insert an "Intermediary" table to bridge the gap. In this Step you learn how to do just that and how to display data correctly in pivot tables to accommodate choices made by the end-user. Exciting stuff and advanced techniques to set you on your way!
You are feeling empowered and ready to take on the world! Until, that is, the new Data source arrives in a different format that you're used to. However, you are a DAX "ninja " - and this won't stop you. Learn how to overcome the next hurdle in your DAX journey. Remember, you're building your skills - therefore, perhaps not all your questions may be answered - but, they will!
Creating 3 measures to obtain a result is not the most efficient solution. Now that you are familiar with the components that provide the solution use this knowledge to create an "All-In-One" approach to display the Budget Allocation measure down to the Day level. You are building your knowledge of what can be achieved given the information supplied.
The "Budget Pattern" is such a useful calculation in its own right. However, it also highlights the potential of other calculations that can be "bundled" together to reduce the number of unnecessary interim measures. Let's recap the key concepts and allow me an opportunity to answer any remaining queries you may still have...