Latest Courses
Python programming Bible - From Beginner to AdvancedCheck course
Learn Pro Advanced Python ProgrammingCheck course
Javascript Certification practice using HTML5 , HTML, CSS3Check course
JavaScript for BeginnersCheck course
Data Science, Deep Learning and Machine Learning with PythonCheck course
Learning Path: Java: Natural Language Processing with JavaCheck course
Cloud Migration on AWS and Microsoft AzureCheck course
Cyber Security: Mastering Linux SecurityCheck course
Data Science:Hands-on Covid-19 Data Analysis & VisualizationCheck course
Learn Node.JS from Beginning to Mastery 2020Check course
Python programming Bible - From Beginner to AdvancedCheck course
Learn Pro Advanced Python ProgrammingCheck course
Javascript Certification practice using HTML5 , HTML, CSS3Check course
JavaScript for BeginnersCheck course
Data Science, Deep Learning and Machine Learning with PythonCheck course
- 93% DAX Power Pivot 10 Easy Steps for Advanced Users

DAX Power Pivot 10 Easy Steps for Advanced Users

$189.99 $12.99Track price

Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare
8.7/10 (Our Score)
Product is rated as #11 in category Business Intelligence

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

Gilly Dow is an MS Office Master, a Certified Microsoft Excel Expert and Training Consultant with 20 years experience working for the US Military, NHS and multiple private sector companies. Gilly have trained thousands of students from IT Security, MS Office, SAP and Clinical Healthcare applications. GD Teach has been founded especially for Udemy to reach out to a wider audience and deliver practical, step-by-step, quality training that makes a difference to you and your job satisfaction.

Specification: DAX Power Pivot 10 Easy Steps for Advanced Users

Duration 9 hours
Year 2019
Level Expert
Certificate Yes
Quizzes Yes

15 reviews for DAX Power Pivot 10 Easy Steps for Advanced Users

4.4 out of 5
11
2
0
1
1
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  2. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  3. Avatar

    Mohd Sadik

    Good for DAX learner. But very low sound of video.

    Helpful(0) Unhelpful(0)You have already voted this
  4. Avatar

    Victoria Delon

    Thank you Gill , the course is very well structured and lots of insights about DAX

    Helpful(0) Unhelpful(0)You have already voted this
  5. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  6. Avatar

    Pierre VINCENT

    By far the most comprehensive course series to become really proficient with DAX and especially with its usage inside the excel ecosystem.

    Helpful(0) Unhelpful(0)You have already voted this
  7. Avatar

    Pawel Dobrzynski

    She repeted all over two examples, very easy exaples by the way

    Helpful(0) Unhelpful(0)You have already voted this
  8. Avatar

    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 🙂

    Helpful(0) Unhelpful(0)You have already voted this
  9. Avatar

    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!

    Helpful(0) Unhelpful(0)You have already voted this
  10. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  11. Avatar

    Luis Estevanot

    EXCELENTE CURSO, MUY COMPLETO Y DOCUMENTADO.–GRACIAS–LUIS ESTEVANOT–16.12.2019

    Helpful(0) Unhelpful(0)You have already voted this
  12. Avatar

    Heikki Moisander

    so far very nice

    Helpful(0) Unhelpful(0)You have already voted this
  13. Avatar

    John Chong

    I took beginner all the way to advance and i have learnt a lot about DAX from Gilly. Highly recommend her courses!

    Helpful(0) Unhelpful(0)You have already voted this
  14. Avatar

    Darran O’Callaghan

    Easy to follow

    Helpful(0) Unhelpful(0)You have already voted this
  15. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this

    Add a review

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    DAX Power Pivot 10 Easy Steps for Advanced Users
    DAX Power Pivot 10 Easy Steps for Advanced Users

    $189.99 $12.99

    Price tracking

    Register New Account
    Reset Password
    Compare items
    • Total (0)
    Compare