Data Analysis with Excel's Power Pivot

Name: Data Analysis with Excel's Power Pivot
Rating: 4.2 (18 reviews)

Learn how to use Power Pivot along with Excel 2016 to analyze data from a variety of sources.

Created bySONIC Performance Support - E-Learning Experts

Last updated 5/2019

English

What you'll learn

Get started with Power Pivot.
Visualize Power Pivot data.
Work with advanced functionality in Power Pivot.
Gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.

Course content

6 sections • 16 lectures • 57m total length

Enable and Navigate Power Pivot - Introduction0:23
In Excel, you don't have access to Power Pivot unless you enable it.
Enable and Navigate Power Pivot4:26
Power Pivot is an add-in built by Microsoft that you can use to create sophisticated relationships among various data sources and perform powerful data analysis. (Power Pivot, Excel Add-Ins, The Power Pivot Tab, The Power Pivot Window, Navigating the PowerPivot Window)
Manage Data Relationships - Introduction3:06
Before you can analyze and report on your data, you must first get the data into Power Pivot to work with it.
Manage Data Relationships6:42
For reporting to be accurate and function well, you must prepare the data for analysis by setting up relationships among tables and creating hierarchies. (The Excel 2016 Data Model, Data Sources, The Table Import Wizard, Diagram View, Relationships, Hierarchies)

Create a Power Pivot Report - Introduction0:16
Learn how to create a Power Pivot report and a Chart using the data in the Data Model.
Create a Power Pivot Report5:07
Viewing rows and rows of data in disparate tables is exhausting, and it is nearly impossible to make any sense out of it. Data becomes meaningful only when you create a report, because you are able to organize and manipulatethe data in ways that you can better analyze. (PivotTables, The PivotTable Fields Task Pane, PivotCharts, Power Pivot Report Options, The Create Report Dialog Box, Quick Explore, Slicers, The Report Connections Dialog Box)
Create Calculations in Power Pivot - Introduction0:28
With Power Pivot, you can create new columns and fields by performing calculations.
Create Calculations in Power Pivot4:43
Once you have created a Power Pivot report, there may be additional information that you want to analyze, but that you don't have already in the Data Model. With Power Pivot, you can create new columns and fields byperforming calculations with much more flexibilty than in Excel. (Calculated Columns, Calculated Fields, Explicit Calculated Fields, The AutoSum Feature)

Create a Key Performance Indicator - Introduction0:44
Excel provides a way to measure performance in your data with key performance indicators.
Create a Key Performance Indicator5:26
In Power Pivot, key performance indicators (KPIs) are visual measures of performance - a great solution if you need to measure the performance of data against a target. (Key Performance Indicators (KPIs), The KPI Dialog Box, The Manage KPIs Dialog Box)

Work with Dates and Time in Power Pivot - Part 13:05
Data Analysis Expressions (DAX), DAX Syntax, Time Intelligence, (Data Analysis Expressions (DAX), DAX Syntax, Time Intelligence)
Work with Dates and Time in Power Pivot - Part 24:19
Data Analysis Expressions (DAX), DAX Syntax, Time Intelligence, (Data Analysis Expressions (DAX), DAX Syntax, Time Intelligence)
Work with Dates and Time in Power Pivot - Part 34:40
Data Analysis Expressions (DAX), DAX Syntax, Time Intelligence, (Data Analysis Expressions (DAX), DAX Syntax, Time Intelligence)
Work with Dates and Time in Power Pivot - Part 44:31
Data Analysis Expressions (DAX), DAX Syntax, Time Intelligence, (Data Analysis Expressions (DAX), DAX Syntax, Time Intelligence)
Create a Comparison Table with Power Pivot8:43
Month over Month (MOM) or Year over year (YOY) is a common method of evaluating two or more measured events to compare the results at one time period with those of a comparable time period. Learn how to create these valuable comparisons.

Requirements

To ensure your success in this course, you should have experience working with Excel 2016 and PivotTables.

Description

Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amountsof data quickly.

Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.

Upon successful completion of this course, you will be able to use Power Pivot along with Excel 2016 to analyze data from a variety of sources.

You will:

Get started with Power Pivot.
Visualize Power Pivot data.
Work with advanced functionality in Power Pivot.

Who this course is for:

People taking this course are experienced Excel users who are seeking to advance their data-analysis capabilities by using Power Pivot.

Data Analysis with Excel's Power Pivot

What you'll learn

Explore related topics

Course content

Getting Started with Power Pivot4 lectures • 15min

Visualizing Power Pivot Data4 lectures • 11min

Working with Advanced Functionality in Power Pivot2 lectures • 6min

Work with Dates and Time in Power Pivot5 lectures • 25min

Quiz0

Course Follow-Up1 lecture • 1min

Requirements

Description

Who this course is for: