Excel: Power Pivot for Beginners

27mBeginner2024-12-06

Authors

Joshua Rischin

Company Director of Axium Solutions

Course details

The Power Pivot feature in Microsoft Excel for Windows allows you to import, merge, and analyze data from many sources. Many people assume Power Pivot is a complex feature reserved for advanced users. Not so! In this short course, instructor Josh Rischin debunks myths around Power Pivot, explaining what it is and the best way to use it. Josh takes you through building a basic data model by identifying your data sources and creating data relationships. He then shows how to analyze the data and present your results using PivotTables and PivotCharts.

Learning objectives
Access and navigate Power Pivot within Excel.
Create and manage data relationships in a basic data model.
Develop and utilize DAX formulas for data analysis.
Implement measures to enhance data analysis in Power Pivot.
Build and customize PivotTables using Power Pivot data.
Create effective PivotCharts to visualize Power Pivot analysis results.

Skills covered

Introduction toSpreadsheetsMicrosoft ExcelBusiness Software and ToolsMicrosoft

Concepts

0. Introduction

01 - Doing more in Excel with Power Pivot

1. Understanding Power Pivot

02 - Navigating the Excel architecture
03 - Become familiar with the Power Pivot interface

2. Building a Basic Data Model

04 - Get started by connecting with source data
05 - Create and manage data relationships
06 - Enhance your data by adding calculations
07 - Generate insights on the fly by creating measures

3. Presenting Your Data

08 - Analyze results using PivotTables
09 - Wow stakeholders with KPIs
10 - Illustrate results using PivotCharts

Conclusion

11 - Where to learn more about Power Pivot