Gilly Dow
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 hink 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.
Instructor Details
Courses : 5
Specification: DAX Power Pivot 10 Easy Steps for Advanced Users
|
15 reviews for DAX Power Pivot 10 Easy Steps for Advanced Users
Add a review
| Price | $12.99 |
|---|---|
| Provider | |
| Duration | 9 hours |
| Year | 2019 |
| Level | Expert |
| Language | English |
| Certificate | Yes |
| Quizzes | Yes |
$12.99
Craig Johnson –
Comprehensive training on Dax, continues where the previous courses left off, lots of relevant examples to learn more about Dax, Filtering, and the data model.
Mark Delia –
This course carried on nicely from the Intermediates course. It recapped some things learned there that have flowed on to the topics covered in this one. In addition it has introduced me to some new features I hadn’t used before, but more importantly helped me understand some areas I was having trouble following like Row & Filter Context. Loved it, especially the bonus lecture on DAX Studio.
Mohd Sadik –
Good for DAX learner. But very low sound of video.
Victoria Delon –
Thank you Gill , the course is very well structured and lots of insights about DAX
Robert Mela –
The course and Gilly are providing me the knowledge and tools necessary to apply to my own Power Pivot and DAX applications. So far, so good. Well, that was certainly an eye–opener for DAX. I will go through the course again to better understand the information presented with a more knowledgeable foundation. Gilly is an outstanding teacher and I am happy to have come across her courses. Thank you Gilly and Udemy for giving me a great foundation into DAX.
Pierre VINCENT –
By far the most comprehensive course series to become really proficient with DAX and especially with its usage inside the excel ecosystem.
Pawel Dobrzynski –
She repeted all over two examples, very easy exaples by the way
Enrico Galli –
Since I’ve been studying DAX for only a few weeks/months, it’s been kind of a gamble to dive directly into the advanced course, of all Gilly’s offer. Although I definitely recommend a slower approach to DAX beginners, I have to say that I never felt left behind, and that’s due to the teacher’s attention to every critical subject and detail, which are reinforced repeatedly until they really stick to your mind. The accompanying material is top quality (a 160+ pages manual and plenty of thorough exercises), and overall I wholeheartedly recommend this course to anyone who has at least some DAX fundamentals or has taken her previous courses already. Thanks a lot and see you on the next one Gilly 🙂
Vlad Levit –
A great course, lets face real problems Here I found the solution to the problem of subtotals and grand totals Before that I had searched for it for about a month on the internet and books Thank you very much Gilly!
Paulo Nascimento –
It’s worth noting that since this is a DAX course (and the DAX language is shared by both Power Pivot and Power BI), any Power BI users/developers can benefit greatly from the information provided by Gilly. I had been struggling to find advanced Power BI courses that focus more on the calculations and less on the visualizations and this course was definitely it. Many of the more advanced concepts behind the CALCULATE and FILTER functions that were kind of fuzzy based on trial–and–error experimenting are now much clearer.
Luis Estevanot –
EXCELENTE CURSO, MUY COMPLETO Y DOCUMENTADO.–GRACIAS–LUIS ESTEVANOT–16.12.2019
Heikki Moisander –
so far very nice
John Chong –
I took beginner all the way to advance and i have learnt a lot about DAX from Gilly. Highly recommend her courses!
Darran O’Callaghan –
Easy to follow
Erik Tiselius –
Great course! Gilly makes it very easy to follow and is explaining the different concepts in a great way. I highly recommend it those who want to excel in Power Pivot and Power Query. Although there are some room of improvements which makes my rating go from 5 to 4: The course is unnecessarily long mainly due to below reasons: –For me the conditional formatting tips can be excluded in the Advanced course all together since I guess that the majority that takes this course are advanced Excel–users and know this stuff. – At least two of the budget sections are more or less irrelevant to most users: a budget process is never as easy as described in section 10 and 11 (if I remember correctly) so that you can divide the monthly budget by the number of days in the month to get the daily budget (or yearly budget divided by number of months) so to spend 2 sections with different ways of doing so is not really time well spent. – Repetition is key to learn but to do the ratio calculations (and % growth calculations in the time intelligence course) is not something that have to be addressed more than once. To me that doesn’t have to be repeated in an Advanced course.