Power Pivot Excel 365 - From Zero to Hero
4.1 (38 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.
2,250 students enrolled

Power Pivot Excel 365 - From Zero to Hero

The only course you need to learn PowerPivot with DAX introduction
4.1 (38 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.
2,250 students enrolled
Created by Paula Guilfoyle
Last updated 5/2020
English
English [Auto-generated]
Current price: $104.99 Original price: $149.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 30 articles
  • 5 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • 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
  • How to navigate PowerPivot
  • How to import data to a PowerPivot data model
  • How to set up relationships and overcome relationship problems
  • How to create pivot tables and charts
  • How to use basic DAX calculations
  • How to use Time Intelligent DAX functions
Requirements
  • Students should be familiar with Excel's Standard Pivot Tables
  • This course is recorded in Excel 365
Description

Power Pivot is an Excel add-in, available in Excel 2010 and certain versions of Excel 2013 and later. You can use Power Pivot, with its own DAX functions to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily.  Power Pivot is the gateway to business intelligence and data all within Excel.

This course has been designed to take the novice Powerpivot user to a level where they are comfortable working with Power Pivot Models, using Pivot tables and charts along with carrying out DAX calculations and using DAX time intelligence functions.

This course consists of 5 modules, each with learning activities, and workbooks to download.  To make sure you get the most out of this course, the learning material is made up of both videos and articles to reinforce what is covered.


Module 1

Get your head around the basics of Powerpivot, learn how to link a table and work with that table and find out how you can get data into powerpivot to work with it. If you are new to Power Pivot this module will show you around, so you become more familiar with the user interface and become more confident adding data to a power pivot model.

· What is Power Pivot?

· How do I create a linked table from Excel to Power Pivot?

· What other ways can I get data into Power Pivot?

· How do I find my way around Power Pivot?

· How do I work with tables in Power Pivot?

·

Module 2

Powerpivot allows you perform calculations across different tables of data. In order to do this, you must link the tables together by means of relationships. Relationships can be difficult to understand at first and they are a big change to working in Excel. In this module you will learn

· What are relationships?

· How do I create a relationship in Powerpivot?

· How do I overcome a many to many relationships?

- How to set up a bridging table

Module 3

The pivot table is by far one of the most useful ways to analyse and visualize your data in Excel. Powerpivot allows you quickly insert a pivot table or chart from multiple tables to analyse or slice and dice like never before. In this module you will learn

· How do I insert a pivot table from Power Pivot?

· How do I work with a pivot table?

· How do I insert a pivot chart from Power Pivot?

· How do I work with and format a pivot chart?

· How do I insert and work with slicers and timelines?


Module 4

Powerpivot allows basic to complex data modelling and calculations to be carried out across multiple tables of data. It does this via its powerful calculation engine using Data Analysis eXpressions. Understanding the basics of DAX is a necessity for the use of Powerpivot. In this module you will learn

· What is DAX

· What are calculated Columns?

· What are Measures?

· What are the X Expressions?

· How do I work with related tables?


Module 5

How often do you see comparisons in accounts and reports such as Same period last year and running totals over time? DAX is equipped with a suite of time intelligence functions that are not found in excel. These functions will allow you quickly analyse your data over different time period. By the end of this module you will learn

· What are time intelligent functions?

· What is the purpose of a date and calendar table and how do I set one up?

· How to I use Total Month Todate and related Functions?

· How do I use Same period last year and related functions?

· How do I use Opening closing balances?

Who this course is for:
  • Excel users looking to upskill in PowerPivot
Course content
Expand all 64 lectures 03:11:02
+ Power Pivot Orientation
16 lectures 50:53
Before you forget
00:12
Demonstration - Overcoming limitations of Standard Pivot tables-
17:30
What is Power Pivot?
01:09
How do I create a linked table from Excel to Power Pivot?
01:04
How do I find my way around Power Pivot?
01:08
Power Pivot Orientation
04:40
What other ways can I get data into Power Pivot?
01:34
Connecting to other data sources
04:12
How to connect to a CSV or TEXT file from Powerpivot
02:22
How do I change data types and formatting of Power Pivot tables?
00:58
How can I work with tables in power pivot?
01:47
carry out this activity to practice what you learned in module 1
Module 1 activity
1 question
+ Relationships
8 lectures 22:33
Module 2 Introduction
00:38
What are relationships?
01:31
What are fact and dimension tables?
01:22
How do I create a relationship in Power Pivot?
01:20
Setting up relationships in PowerPivot
05:56
How do I overcome a many to many relationships?
01:05
Solving the many to many relationship problem
09:06
How to create a unique list in Excel that can be used as a bridging table
01:34
complete this activity to practice what we covered in module 2
Module 2 Activity
2 questions
carry out this activity to practice what you learned in module 2
Module 2 Activity 2
1 question

take this quiz and test your knowledge on module 2

Module 2 quiz
5 questions
+ Creating PowerPivot tables and Charts
13 lectures 36:00
Module 3 Introduction
00:43
Refresher on Pivot Tables 1
04:05
Refresher on Pivot tables 2
02:34
How do I insert a pivot table from Powerpivot?
01:12
Inserting Pivot tables from Power Pivot
06:39
How do I work with a Pivot table?
01:12
Working with Pivot tables from power pivot
04:53
How do I insert a pivot chart from Power Pivot?
00:56
Inserting Pivot Charts from Power Pivot
04:01
How do I work with and format a pivot chart?
01:10
Chart Elements
03:31
How do I insert and work with Slicers and timelines
01:12
Slicers and Timelines
03:51
+ Introduction to DAX for PowerPivot Users
12 lectures 43:25
Module 4 introduction
00:46
What is DAX?
00:53
What data types are found in DAX and what is DAX syntax like?
01:17
What are calculated Columns & Measures?
01:40
Adding DAX calculations
05:04
Adding measures from Excel
02:36
How do I use SUM and SUMX?
01:13
SUM and SUMX in DAX
09:59
How do I use COUNT and COUNTX?
01:15
COUNT and COUNTX - understanding measures and columns
10:59
How do I work with related tables?
01:29
RELATED and RELATEDTABLE
06:11
carry out this activity to practice what you have learned in this module
Module 4 Activity 1
1 question
carry out this activity to practice what you have learned in module 4
Module 4 Activity 2
2 questions

take this quick quiz

Module 4 quiz
7 questions
+ Time Intelligence Expressions
15 lectures 33:03
Module 5 Introduction
00:54
What is time Intelligent functions?
01:10
What is the purpose of a date and calendar table and how do I set one up?
01:16
How to set up a date table
05:33
How do I use TOTALMTD, TOTALQTD and TOTALYTD Expressions ?
01:14
TOTALYTD and similar functions
05:19
How can I compare to previous period?
01:11
SAMEPERIODLASTYEAR
03:42
How do I calculate moving/rolling totals?
00:52
DATESINPERIOD
03:10
Time Intelligence Activity
00:29
Time Intelligence Solutions
00:15

take this quiz and test your knowledge

Time Intelligence Quiz
4 questions
Adding KPI's
06:11
Course Conclusion
01:25
BONUS TIME
00:20