24.1 Introduction
Learning Objectives
Utilize Power Pivot, including importing data from a variety of sources, creating a data model, linking data together, and implementing Power Pivot tables and charts.
Create hierarchies in Power Pivot.
Create 3D maps from Power Pivot data models, including heatmaps based on latitude and longitude.
Power Pivot is an add-in for Excel that allows you to import data from various sources into a single workbook. It keeps the data in a data model behind the scenes but available to be utilized in various analyses. This feature is powerful in its ability to store a large amount of data—millions of rows of data from multiple datasets.
Lesson Files
Power Pivot - XYZ Corp Sales 2021 Access Database
Power Pivot - Products List (xlsx)
Power Pivot - Employees (csv)