Excel PowerPivot — Data Analysis & DAX for Beginners
Self-paced video training — 5 modules, 30 lessons. Work through it at your own pace — every lesson is real recorded training, not slide-reading.
▶INSIDE THE COURSE · 30 LESSONSABOUT THIS COURSE
In this beginner course, students will learn how to use Excel's PowerPivot for data analysis, focusing on fundamental concepts and techniques. The curriculum covers data structures, relationships, and the Excel Data Model, and introduces DAX for creating calculated columns and measures. Through practical exercises, learners will develop skills to create custom hierarchies and key performance indicators, enhancing their ability to analyze and visualize data effectively.
CURRICULUM
5 modules, in order.
01Introduction5 LESSONS
this lesson introduces the course and its objectives.
meet your instructor, philip trick, and learn about his background.
review the basic excel skills that are essential for this course.
learn the importance of relationships in data analysis.
discover tips on how to maximize your learning experience in this course.
02PowerPivot Basics5 LESSONS
understand what powerpivot is and its benefits for data analysis.
explore different data structures used in powerpivot.
learn the fundamental concepts of relationships in powerpivot.
discover how powerpivot detects relationships in data.
learn how to effectively use relationships in powerpivot.
03The Excel Data Model13 LESSONS
get introduced to the powerpivot window and ribbon features.
learn how to utilize the base commands in powerpivot.
understand the differences between calculated columns and measures.
get an introduction to data analysis expressions (dax).
learn how to add calculated columns in powerpivot.
explore how to use dax conditional functions.
discover how to add calculated measures in powerpivot.
understand the concept of context in dax.
learn how to manage context effectively in dax.
discover how to use variables in dax for better calculations.
learn how to use the datediff function in dax.
explore various math functions available in dax.
04Supporting Features and Advanced Concepts6 LESSONS
learn about creating custom hierarchies in powerpivot.
discover how to create and use key performance indicators (kpis) in powerpivot.
learn about advanced calculations using measures in PowerPivot.
engage in a hands-on exercise to practice PowerPivot skills.
review the solution for the PowerPivot exercise to understand the concepts better.
discover how to locate the answers for the quiz.
05Conclusion1 LESSONS
wrap up the course and explore the next steps for further learning.
CURATED BY
Selected from experienced educators' training libraries and kept whole — modules, worked examples and walkthroughs exactly as taught.
GOOD TO KNOW
Lessons stream in the browser and remember where you stopped.
Watch on two devices at once — phone, tablet or desktop.
Download buttons are disabled; delivery is encrypted and authenticated per request.
$59 · ONE PAYMENT
Own every lesson, for life.
One payment unlocks all 30 lessons instantly — start with lesson one the moment you check out.