Learn Excel PowerPivot & DAX for Beginners
Join the Elite Excel users!
Most of us use Excel, but very few can claim to be true masters. As we wade through data, trying to make sense of it all, a vast array of tools and techniques remain untapped. We keep hearing about Power Pivot, DAX, and Power Query - the tools that the pros use - but what are they exactly? How do they work? How can they help us with our data analysis tasks?
Power Pivot and DAX are Excel's superpowers, letting you manipulate, analyze, and visualize data in ways you never thought possible. In this course, we'll guide you from being an absolute beginner to an Excel power user, capable of wielding Excel's most powerful tools. You'll discover how to model data, use Power Query, learn the difference between Implicit Measures & Explicit Measures, and so much more.
By taking this course, you will not only learn about Power Pivot, DAX, and Power Query, but you'll be able to handle complex calculations, data modeling, and create stunning data visualizations. But the benefits don't stop there. This knowledge will make you an asset to any employer, adding a highly sought-after skill to your repertoire. And with hands-on practice, example files, and a wealth of practical examples, this isn't just a course - it's an investment in your career.
This comprehensive course has been carefully crafted to take you on a step-by-step journey through the dynamic world of Excel's powerful tools: Power Pivot, DAX, and Power Query. Here's a snapshot of what's included:
Data Modeling and Power Pivot: Start by learning how to enable Power Pivot in Excel, before diving into the fundamentals of data modeling. You'll learn to load data using Power Query and establish relationships between tables, understanding the key differences between relationship types.
Understanding Measures and Calculated Columns: Master the art of working with both implicit and explicit measures, and unlock the potential of calculated columns. These foundational tools will form the base of your more complex data manipulations.
DAX Deep Dive: Enter the world of DAX, where you'll explore the importance of Filter Context & Row Context and how to differentiate between them. We'll guide you through crucial functions like RELATED() and RELATEDTABLE(), and how to leverage DAX Studio to troubleshoot and verify your DAX formulas.
Iterator Functions and Variables in DAX: Get hands-on with iterator functions like SUMX(), AVERAGEX(), and FILTER(). Understand the nuances between X and Non-X functions, and delve into using variables in DAX to simplify your formulas and optimize execution times.
The Power of CALCULATE(): Arguably the most important function in DAX, CALCULATE() offers you unparalleled control over your calculations. We will also explain the differences between CALCULATE() & CALCULATETABLE(), equipping you with the skills to apply the correct function for the task at hand.
Time Intelligence Calculations: Complete your course with a foray into time intelligence calculations, building a Calendar Table from scratch using Power Query, and performing sophisticated calculations such as YTD, Previous Periods, Moving Running Total, Moving Average, and Weekly Time Intelligence Calculations.
This course offers much more than theoretical knowledge. You'll get your hands dirty with practical examples, exercises, and sample files, ensuring you come out as an Elite Excel Power User. Ready to unlock your full potential in Excel? Join us on this exciting journey.
We believe in the quality and value of our course so strongly that we offer a 30-day, risk-free guarantee. If, within the first 30 days of enrollment, you feel that the course doesn't live up to your expectations, simply drop us an email. We'll refund your investment, no questions asked. This way, you can sign up for the course today without any worries or hesitations, secure in the knowledge that your satisfaction is our top priority.
Simply send us an email to [email protected] within 30 days of buying the course, and we will refund your money.
Course Introduction
FREE PREVIEWDownload Course Files
Enabling PowerPivot in Excel
Loading the data using PowerPivot
Loading the data using Power Query
Fact vs Dimension Tables
Relationship Types
Measures and Calculated columns - Part 1
Measures and Calculated Columns - Part 2
Implicit vs Explicit Measures
FREE PREVIEWThe Filter Context in DAX
The Row Context in DAX
Building the Model and Relationships
Creating Sales & Total Product Cost Measures
Homework/ Exercises
Homework/Exercises solutions
To take this course, you should have the following:
This course isn't suitable for users who haven't used Excel before.