Complete Introduction to Excel Power Pivot
4.6 (218 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,016 students enrolled

Complete Introduction to Excel Power Pivot

Learn to create data models, relationships and DAX formulas and work with over a million rows in Microsoft Excel
Bestseller
4.6 (218 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,016 students enrolled
Created by Ian Littlejohn
Last updated 6/2020
English
English [Auto]
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 7 articles
  • 10 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Learn to use the EXCEL POWER PIVOT tool
  • 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
Requirements
  • You will require Excel 2016 and the Power Pivot licence
  • You should be able to work with data in Excel and do basic reporting
Description

Recent reviews:

"Great Course. Learned a lot and it helps me with advanced excel analysis."

"There is so much more to this than I knew. I never knew there was anyway to use more than 1M rows in Excel."

"Excellent! Very easy to follow, accurate and detailed"

**** Lifetime access to course materials and practice activities.  100% money back guarantee ****

This course is presented by Ian Littlejohn - who with over 65 000 students is one of the most popular instructors on Udemy. Ian provides world leading courses on Excel, Power Pivot, Power BI and Google Data Studio.

Skills in data analysis, reporting and the creation of dashboards are HIGHLY valued in today's business environment. Excel is now recognized as the most commonly used data analysis tool in the world for the development of reports, data analysis and dashboards.

In this course you will learn about the power of the Data Model & DAX formulas in Excel.  You will cover:

  1. Introduction and Course Content

  2. Creating Calculated Columns - Basic calculations, using date fields and date tables

  3. Creating Measures - Aggregation measures, the =Calculate formula, the All and AllExcept formula and Time Intelligence

  4. Creating Relationships between tables and using relationship calculations

  5. Using KPIs visualizations in the data model

  6. Creating and using hierarchies

  7. Advanced visualizations

We look forward to having you on our course as we learn and explore the incredible power of Power Pivot in Excel.

Please note that this course is the second course in a series of three courses for the Excel Master Class series.  Search for my instructor profile to purchase these other courses.

  1. Course 1 - Power Query -Consume and Transform Data

  2. Course 2 - Power Pivot - Data Modeling and DAX Formulas

  3. Course 3 - Pivot Tables and Pivot Charts

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
Course content
Expand all 51 lectures 03:39:10
+ Introduction
3 lectures 04:54

Introduction to the course

Preview 02:23
About the Course
02:27
Download the Course Training Files
00:04
+ Power Pivot and the Data Model
12 lectures 56:30

Introduction to the Power Pivot and Data Model section

Preview 01:24

In this lesson you will learn how to load data into Power Pivot

Preview 06:05

In this lesson you will learn how to browse, filter and sort your data in the data model

Browse, Filter and Sort
06:50

In this practical activity you will load data from an Excel file into Power Pivot

Practical Activity - Load Data
00:23

Learn how to create pivot tables from data modelling

Preview 06:29

In this lesson you will learn how to create simple measures in the Data Model and use them in Pivot Tables

Data Model Calculations
07:46

Learn how to use the Pivot Table Show Value As calculation with data from Power Pivot

Pivot Tables Show Value As Calculations
07:00

In this lesson you will learn to use Slicers to filter data in the Pivot Table

Preview 05:59

In this lesson you will create a Pivot Chart and Table and use a Slicer to filter both

Two Pivot Table and Chart
04:58

In this practical activity you will learn create Pivot Tables and Pivot Charts from Power Pivot Data

Practical Activity - Create Pivot Tables
00:37

In this lesson you will learn to create hierarchies and to use them in Pivot Tables and Pivot Charts

Creating Hierarchies in the Data Model
08:09

Conclusion to the Data Modeling section

Conclusion to the Data Modelling Section
00:50
+ Calculated Columns
9 lectures 34:36

In this section you will learn how to create calculated columns for your data model

Introduction to Calculated Columns
02:00

In this lesson you will access a .csv file and retrieve a table of data

Accessing the Region Sales Data
00:14

In this lesson you will learn how to add multiplication and subtraction calculations to the data model

Creating a Calculated Column
06:46

In this lesson you will learn how to add new fields for Year, Month, Week Number and Week Day

Date Formulas
06:47

In this lesson you will learn how to create weekday and month names.  In addition you will learn how to correctly sort these fields

Formatting Month and Week Day Names
04:58

In this practical activity you are going to add calculated columns to your data model

Practical Activity - Calculated Columns
00:30

In this lesson you will create a date table that will be used for calculations and Pivot Tables

Creating a Date Table
08:51

In this lesson you will how to use text and logical function in Power Pivot

Examples of Text and Logical Functions
04:02

Conclusion to the calculated columns section

Conclusion to Calculated Columns
00:27
+ Measures in the Data Model
11 lectures 59:31

Introduction to the measures section

Introduction to Measures
02:16

In this lesson you will learn how to create Sum, Average, Max, Min, DistinctCount and Divide

Simple Measures
10:12

In this lesson you will learn how to use the =Calculate formula.  The =calculate formula is one of the most powerful formulas in DAX

The =Calculate Formula
09:58

In this practical activity you will create measures for the data model.

Practical Activity - Add Measures to the Data Model
00:15

In this lesson you will learn how to use the All and AllExcept functions

The ALL and ALLEXCEPT Formulas
07:55

In this lesson you will how to create previous month, difference from previous month and year to date calculations

Time Intelligence Calculations Part 1
08:00

In this lesson we continue with the time intelligence lessons.

Time Intelligence Calculations Part 2
07:16

In this lesson you will learn to create customer segmentation using the Switch function

Customer Segmentation - The Switch Function
03:53

In this lesson you will learn to use the RankX function

RankX Function - Ranking Customers
04:11
Values Function - Calculating Daily Sales for the Customer
05:02

Conclusion to the Measures section

Conclusion to Measures
00:33
+ Relationships
6 lectures 26:08

Introduction to the relationships section

Introduction to Relationships
01:01

In this lesson you will learn how to create relationships

Creating Relationships
09:09

In this lesson you will learn how to use the =related function to lookup values from a related table

Related Function
06:45

In this practical activity you will load an Employee Master spreadsheet.  Create a relationship and then develop a 4 chart dashboard

Practical Activity - Employee Master 4 Chart Dashboard
00:20

In this lesson we will complete the four dashboard practical activity

Four Chart Dashboard Practical Activity
08:17

Conclusion to the relationships section

Conclusion to Relationships
00:36
+ Sets and KPIs
4 lectures 12:59

Introduction to the KPIs and Sets section

Introduction to KPIs and Sets
01:46

In this lesson you will learn to create Sets within your Power Pivot data

Creating Sets
03:49

In this lesson you will create KPIs for your data

Creating KPIs
07:02

Conclusion to the KPIs and Sets section

Conclusion to KPIs and Sets
00:22
+ Advanced Visualizations
5 lectures 22:56

Introduction to the Frequency Analysis section

Introduction to Advanced Visualizations
01:29

In this lesson you will learn how to convert Pivot Table values into formulas which provides the capability to create advanced visualizations

Overview of Advanced Visualizations
07:06

In this lesson you will learn to create a waterfall chart

The Waterfall Chart
07:28

In this lesson you will learn to create the Treemap and Sunburst visualization

TreeMap and Sunburst Visualization
06:27

Conclusion to the advanced visualizations section

Conclusion to Advanced Visualizations
00:26
+ Course Conclusion
1 lecture 01:35

Conclusion to the course

Course Conclusion
01:35