DAX Power Pivot - 10 Easy Steps for Intermediates

Build Power Pivot Data Models with Excel 2016 Power Query – take your DAX Business Intelligence to the next level

4.64 (1232 reviews)

Udemy

platform

English

language

Microsoft

What you will learn

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

A BONUS section taking you through 7 Power Query examples of "messy" data and how to transform your data quickly and efficiently saving you time and repetition

Loading charts...

Comidoc Review

Our Verdict

With its focus on hands-on examples and practice exercises, this course is ideal for those eager to learn intermediate DAX concepts. However, watch out for potential confusion with naming conventions and sudden changes in models, as they may hinder the learning experience slightly. Nevertheless, the instructor's expertise and clear explanations will undoubtedly leave you feeling more confident with DAX Power Pivot.

What We Liked

Comprehensive course covering intermediate level DAX concepts with emphasis on Data Models, Power Query, Disconnected tables and Filter Context.
Instructor's deep understanding of the subject allows for clear explanations and 'between the lines' comments that help build in-depth knowledge.
Well-constructed hands-on examples, practice exercises, and additional resources ensure mastery of material.
Course structure is easy to follow with detailed user guide, slides, and downloadable workbooks.

Potential Drawbacks

Similar names for fields and measures in Sales Report and Fruit Sales Models may cause some confusion.
Sudden switch of Data Models in Practice Ex3 might not give clear notice to trainees.
The Values function is introduced earlier than needed, requiring more explanation on syntax for better understanding.
Though instructor clarifies concepts well, the pace might be too fast for beginners.