US $19.97

Unleashing Excel Power Pivot & DAX

——   Created by Abdelrahman Abdou

Join the ELITE EXCEL POWER USERS by Learning DAX and Power Pivot in Excel

Share this course:

NEW
Course
58
Lessons
7h 18m
Lesson time
all
Skill levels

More about this course

In this course, the student will learn Business Intelligence using Power Pivot in Excel and perform complex calculations using the DAX formula language. This course is excellent for beginners who want to learn Power Pivot & DAX from scratch.

This course offers tremendous value as a beginner's course. The student will get out of this course with a thorough understanding of Power Pivot & DAX and also using Power Query along the way.

This course will take the student step by step through the journey of learning Data Modeling, Power Pivot, & DAX.

We will also be using Power Query as a tool to Extract, Load & Transform (ETL) our data.

  • First, we will start by learning how to enable Power Pivot in Excel
  • Then, we will load the data into our Data Model using Power Query and create relationships between our tables
  • We will also explore the different types of relationships and understand the difference between them
  • Afterward, we will explore Measures and Calculated Columns and understand the difference between them
  • We will also learn the difference between Implicit Measures & Explicit Measures
  • Moreover, we will learn about the Filter Context & the Row Context and understand the difference between them
  • Furthermore, we will learn about the RELATED() and RELATEDTABLE() functions and understand the difference between them
  • Also, we will be installing DAX Studio and having multiple examples on how to use it to troubleshoot and verify the results of your DAX formulas
  • Afterwards, we will learn about Iterator functions in DAX such as SUMX(), AVERAGEX() & FILTER(), and we will be explaining the difference between the X and Non-X functions ( e.g. SUM() vs SUMX())
  • We will also be dedicating multiple videos to the FILTER() function and explaining how to use it solve different problems and get the desired results
  • Then, we will be exploring super important Table Functions such as ALL(), ALLSELECTED(), VALUES() and DISTINCT() and we will explain the difference between VALUES() & DISTINCT() functions
  • Moreover, we will be exploring Variables in DAX and explaining how to use them to make your formulas easier to read and troubleshoot and faster to execute
  • And of course, we will be explaining the CALCULATE() function which is the most important function in DAX, and we will be explaining how to use it to change the filter contexts of your calculations to get the results that you want
  • In addition to CALCULATE(), we will be explaining the CALCULATETABLE() function and showing a great example of calculating the number of new customers acquired each day in our store. We will also be explaining the difference between CALCULATE() & CALCULATETABLE()
  • Afterward, we will dive into Time Intelligence Calculations in DAX, where we will build a Calendar Table from scratch using Power Query
  • After building the Calendar Table, we will explore how to perform Time Intelligence Calculations such as YTD, Previous Periods, Moving Running Total, Moving Average & Weekly Time Intelligence Calculations
  • You will also be getting all the needed Example files to follow along and you will be having exercises along with answers throughout the course in order to get hands-on practice!

I'm confident that you will be getting outstanding value from this course, so make sure to enroll in the course to join the ELITE EXCEL POWER USERS!!

Abdelrahman

The course project

Please tackle the exercises provided on the course.

58 Lessons

4 mins
Introduction Presentation
2 mins
DAX Functions guides
free preview
5 mins
Enabling PowerPivot in Excel
free preview
3 mins
Loading the Data using PowerPivot
12 mins
1.3.2 Loading the Data using Power Query
9 mins
1.4.1 Relationships in the Data Model Fact vs Dimension Tables
12 mins
1.4.2 Relationship Types
9 mins
1.5.1 Measures and Calculated Columns Part 1
11 mins
1.5.2 Measures and Calculated Columns Part 2
5 mins
Implicit vs Explicit Measures
14 mins
What is the Filter Context
11 mins
The Row Context in DAX
7 mins
Building the Data Model and Relationships
4 mins
Creating Sales and Total Product Cost Measures
2 mins
More Measures - Homework
View more lessons +

About the instructor

It you!

Abdelrahman Abdou is a Microsoft Certified Trainer (MCT) with over 8 years of Experience in Data Analytics, Reporting, and Business Intelligence in the largest Telecom …

Read more
This course is included in Arbington Premium
$15/month gets you access to every course. Start your 14 day trial today. ☝️

Class benefits

  • Certificate of Completion
  • 30 day satisfaction guarantee
  • 24/7 streaming access
  • Project included
  • Direct teacher access
  • 7h 18m of on-demand video
  • 1 downloadable file
  • Have a coupon?
  • Checkout