Introducing Power Pivot
Learning Outcomes
Get More Info
data, Tech & ai skills in
What’s Included
Overview and Installation
Overview and Installation
Power Pivot is only available in certain Excel versions. Learn how to get Power Pivot in this lesson.
Loading Data to the Excel Data Model Part 1
Loading Data to the Excel Data Model Part 1
There are several ways of adding data from an Excel sheet to the data model. We will look at copying and pasting and linked tables.
Loading Data to the Excel Data Model Part 2
Loading Data to the Excel Data Model Part 2
Generally, Power Pivot data is imported from an external file. We will see this using the Table Import Wizard.
Q&A - Loading Data to Power Pivot
Q&A - Loading Data to Power Pivot
This lesson covers information around accessing and connecting data to Power Pivot.
Data View and Diagram View
Data View and Diagram View
Power Pivot lets you see your data model using two views: Data View and Diagram View. We will see both in this lesson.
Relationships
Relationships
Relationships turn a set of unconnected tables into an integrated data model. We will see how to create them in this lesson.
Q&A - Relationships and Viewing Tables
Q&A - Relationships and Viewing Tables
This lesson reviews information around creating relationships as well as some key differences between Data View and Diagram View.
Calculated Columns
Calculated Columns
Calculated columns allow you to add data to the tables in your data model. We will see how to create them in this lesson.
Measures
Measures
Measures are dynamic calculations that can be added to your data model. We will create measures in Power Pivot in this lesson.
Q&A - Calculated Columns and Measures
Q&A - Calculated Columns and Measures
This lesson reviews information around calculated columns and measures.
Creating a PivotTable from Power Pivot Data
Creating a PivotTable from Power Pivot Data
Using the data model, we can create PivotTables that use data from multiple tables. We will see how to do this in this lesson.
Creating a PivotChart from Power Pivot Data
Creating a PivotChart from Power Pivot Data
Power Pivot makes it easy to create PivotCharts using data from multiple tables. We will create a PivotChart in this lesson.
Certifications
A Learner Experience Designed to Deliver Transformation
How Leading Teams Use Kubicle to Upskill & Excel
