Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Complete Introduction to Excel Power Pivot

Name: Complete Introduction to Excel Power Pivot
Rating: 4.7 (2733 reviews)

Learn how to use Excel Power Pivot to analyze and visualize large volumes of data,create relationships and DAX formulas

Role Play

Created byIan Littlejohn

Last updated 7/2025

English

What you'll learn

Quickly learn to use Power Pivot in Excel for powerful data analysis
Work with millions of rows of data, create relationships between tables and learn the DAX formula language
Have a COMPREHENSIVE understanding of creating data models in Excel
Create calculated fields and calculated measures using DAX in Excel
Perform SOPHISTICATED calculations such as Time Intelligence, Filtered Data and Segmentation
Create RELATIONSHIPS between tables of data
Analyze data using Pivot Tables and Pivot Charts

Course content

11 sections • 58 lectures • 3h 43m total length

Introduction to the Course1:47
Introduction to the course
About the Course1:23
Download the Course Training Files0:04

Overview of Excel Power Pivot0:41
Introduction to the Power Pivot and Data Model section
Understanding Power Pivot2:05
Activating Excel Power Pivot2:03
Loading Data into the Data Model5:47
In this lesson you will learn how to load data into Power Pivot
Browse, Filter and Sort5:36
In this lesson you will learn how to browse, filter and sort your data in the data model
Practical Activity - Load Data0:21
In this practical activity you will load data from an Excel file into Power Pivot
Welcome to the Udemy Roleplay!0:36
Discuss Excel Power Pivot project

Introduction to Analyzing Data with Pivot Tables0:31
Creating Pivot Tables7:39
Learn how to create pivot tables from data modelling
Methods of Aggregation5:34
In this lesson you will learn how to create simple measures in the Data Model and use them in Pivot Tables
Slicers and Filtering Data with Pivot Tables7:14
In this lesson you will learn to use Slicers to filter data in the Pivot Table
Two Pivot Table and Chart5:45
In this lesson you will create a Pivot Chart and Table and use a Slicer to filter both
Practical Activity - Create Pivot Tables0:17
In this practical activity you will learn create Pivot Tables and Pivot Charts from Power Pivot Data
Completed Practical Activity5:33
Discuss the usage of Pivot Tables with Power Pivot

Introduction to Calculated Columns1:09
In this section you will learn how to create calculated columns for your data model
Creating a Calculated Column5:17
In this lesson you will learn how to add multiplication and subtraction calculations to the data model
Year Month Day4:54
In this lesson you will learn how to add new fields for Year, Month, Week Number and Week Day
Weeknum and WeekDay2:57
Formatting Month and Week Day Names6:06
In this lesson you will learn how to create weekday and month names. In addition you will learn how to correctly sort these fields
Practical Activity - Calculated Columns0:30
In this practical activity you are going to add calculated columns to your data model
Creating a Date Table9:20
In this lesson you will create a date table that will be used for calculations and Pivot Tables
IF Function3:59
In this lesson you will how to use text and logical function in Power Pivot
SWITCH Function5:45
Discuss DAX Calculated Columns in the Data Analysis project

Introduction to Measures1:11
Introduction to the measures section
Explanation of Measures3:30
Aggregations9:27
In this lesson you will learn how to create Sum, Average, Max, Min, DistinctCount and Divide
Practical Activity - Add Measures to the Data Model0:10
In this practical activity you will create measures for the data model.
Completed Practical Activity - Measures6:28
The =Calculate Function6:22
In this lesson you will learn how to use the =Calculate formula. The =calculate formula is one of the most powerful formulas in DAX
Practical Activity - =Calculate0:16
Practical Activity =Calculate4:17
The ALL and ALLEXCEPT Functions9:50
In this lesson you will learn how to use the All and AllExcept functions
Discuss the usage of Measures in the Data Analysis project

Introduction to Relationships0:53
Introduction to the relationships section
Download Training Data Files0:03
Creating Relationships5:35
In this lesson you will learn how to create relationships
Relationship Calculations4:15
In this lesson you will learn how to use the =related function to lookup values from a related table
Practical Activity - Employee Master 4 Chart Dashboard0:20
In this practical activity you will load an Employee Master spreadsheet. Create a relationship and then develop a 4 chart dashboard
Four Chart Dashboard Practical Activity7:55
In this lesson we will complete the four dashboard practical activity
Discuss creating Relationships in your data model

Requirements

You will require a power pivot compatible version of Excel (2013 or newer or Office 365). Power Pivot is not currently Mac-compatible.
You should be able to work with data in Excel and do basic reporting
You will require the Excel Power Pivot licence

Description

With Excel's impressive Power Pivot, you can import millions of rows of data, create mashups from different data sources and build sophisticated data models with ease. This allows you to analyze your data and share insights with just a few clicks of your mouse. If you are eager to learn about Excel's Power Pivot quickly and easily, this is the course for you.

WHAT YOU CAN EXPECT:

Introduction and Course Content
Power Pivot and the Data Model
Power Pivot and Pivot Tables
Creating Calculated Columns - Basic calculations, using date fields and date tables
Creating Measures - Aggregation measures, the =Calculate formula, the All and AllExcept formula and Time Intelligence
Case Studies
Creating Relationships between tables and using relationship calculations
Using KPIs visualizations in the data model
Creating and using hierarchies

ABOUT THE TRAINER

I am a Udemy Instructor Partner with more than 20 years' experience in training & management consulting. I specialise in training business users to learn powerful methods and techniques to transform data into useful information and intelligence as well as learning strong data analysis methodology using Microsoft Excel, Microsoft Power BI, Looker Studio (formerly Google Data Studio), Amazon QuickSight and ChatGPT.

WHAT STUDENTS ARE SAYING:

I have been searching for a Power Pivot course for a while now and this one fits my expectations; easy to understand and at the right pace. Amazing course, above expectations!
Great introduction the power pivot. Now I have a good understanding of the foundation of the material.
Incredibly detailed and yet easy to grasp course for professionals! Highly recommended

DATA ANALYSIS COURSES ROADMAP

The tech industry is constantly evolving, there have been significant investments in the field of AI, machine learning and big data and this means there is a growing demand for data analysts. With the right skills and a proactive approach, a data analyst can reach unprecedented heights! I currently offer the following 14 courses on Udemy covering a wide variety of tools and skills that will empower you to confidently explore the dynamic realm of data analysis, gain valuable skills in data interpretation and drive intelligent, data driven decisions.

Microsoft Excel

Introduction to Analyzing Data with Excel Pivot Tables
Complete Introduction to Excel Power Pivot
Complete Introduction to Excel Power Query
Excel Interactive Dashboards and Data Analysis
Complete Introduction to Business Data Analysis
Tables and Formulas with Excel

Microsoft Power BI

Complete Introduction to Microsoft Power BI
Complete Introduction to Power BI Query Editor
Power BI Master Class-Data Models and DAX Formulas
Power BI Master Class - Dashboards and Power BI Service

Google

Complete Introduction to Google Sheets Pivot Tables
Complete Introduction to Looker Studio (formerly Google Data Studio)

Amazon QuickSight

Complete Introduction to Amazon QuickSight

ChatGPT

Introduction to Analyzing Data with ChatGPT

Who this course is for:

Excel users who want to learn how to use the Power Pivot Data Model
Excel users who want to learn how to use the DAX formula language

Complete Introduction to Excel Power Pivot

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 3min

Power Pivot and the Data Model8 lectures • 17min

Power Pivot and Pivot Tables8 lectures • 33min

Calculated Columns10 lectures • 40min

Measures in the Data Model10 lectures • 42min

Time Intelligence Measures3 lectures • 24min

Additional Measures6 lectures • 19min

Case Studies5 lectures • 13min

Relationships7 lectures • 19min

Sets and KPIs5 lectures • 14min

Requirements

Description

Who this course is for: