Are you ready to supercharge your Excel skills and enter the world of Business Intelligence?

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? 



Enter Excel PowerPivot: The Game-Changer

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. 


Why Choose Our Course? Unleash the Power of Your Data🚀

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.


Your learning journey on this course

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.

What Our Learners Say

Hear from Our Satisfied Students Transforming Their Careers


30-day 100% Money-Back Guarantee

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 curriculum

    1. Course Introduction

      FREE PREVIEW

    2. Download Course Files

    1. Enabling PowerPivot in Excel

    2. Loading the data using PowerPivot

    3. Loading the data using Power Query

    1. Fact vs Dimension Tables

    2. Relationship Types

    1. Measures and Calculated columns - Part 1

    2. Measures and Calculated Columns - Part 2

    3. Implicit vs Explicit Measures

      FREE PREVIEW

    1. The Filter Context in DAX

    2. The Row Context in DAX

    1. Building the Model and Relationships

    2. Creating Sales & Total Product Cost Measures

    3. Homework/ Exercises

    4. Homework/Exercises solutions

About this course

  • $119.99
  • 58 lessons
  • 7.5 hours of video content

Instructor(s)

Abdelrahman Abdou

Data Analytics Trainer & Consultant

Abdelrahman Abdou is an Excel & Power BI expert, a Microsoft Certified Trainer (MCT) and data analytics consultant with over 10 years experience in Data Analytics, Business Intelligence and Reporting. In his spare time, Abdelrahman Loves to go to the gym, watch football and play PC games.

Course Prerequisites

To take this course, you should have the following:

  1. A windows PC with Internet connection
  2. Excel 2010 or higher (Excel 2016 or higher  or Excel 365 preferred)
  3. You should be an intermediate user of Excel
  4. You should know Excel functions such as IF, VLOOKUP and TEXT
  5. You should be an intermediate user of Pivot tables.


This course isn't suitable for users who haven't used Excel before.

Become an Elite Excel Power User Today!

Join our course today and embark on a transformative learning journey. By the end, you'll be fluent in Power Pivot, DAX, Power Query, and many more Excel super-tools. From understanding filter context to mastering CALCULATETABLE(), our comprehensive course is designed to make you an elite Excel power user. Don't miss out on this opportunity. Sign up today and take your Excel skills to the next level. Remember, knowledge is power. And with Excel, the power is in your hands. Sign up now!
Enroll Now

Enroll today to join the Elite Excel users who use PowerPivot!

Enroll today