Skip to main content
Power Pivot and Power Query Essentials

Introducing Power Pivot

If you house your data in tables, you may find limits in your ability to analyze it comprehensively. Excel can help. Power Pivot creates a structured data model in Excel similar to a database, turning it into a self-service business intelligence platform. In this course, you’ll explore how it can add value to your analysis.

Intermediate        15 Lessons        120 Minutes        CPD Credits
TRY FOR FREEEXPLORE OUR LIBRARY

About This Course

There is only so much insight you can retrieve from a basic table of a data. In this course, you’ll learn how to perform powerful data analysis and create sophisticated data models using Power Pivot.

Across 15 lessons, you’ll explore the important features of the Excel data model, and show you how to create Pivot Tables and Pivot Charts using one.

By the end of the course, you’ll know how to boost your analysis, expand your range of insights, and save time in the process.

GET STARTED

Learning Outcomes

  • Load data to the Power Pivot data model
  • Explore the data model using the Power Pivot interface
  • Create relationships between tables in Power Pivot
  • Create calculated columns and measures
  • Create Pivot Tables and Pivot Charts from Power Pivot data
  • Update the data in the data model

Lessons

1. Overview and Installation
2. Loading Data to the Excel Data Model Part 1
3. Loading Data to the Excel Data Model Part 2
4. Q&A - Loading Data to Power Pivot
5. Data View and Diagram View
6. Relationships

Read More

7. Q&A - Relationships and Viewing Tables
8. Calculated Columns
9. Measures
10. Q&A - Calculated Columns and Measures
11. Creating a PivotTable from Power Pivot Data
12. Creating a PivotChart from Power Pivot Data
13. Adding Slicers to PivotTables and PivotCharts
14. Updating the Data Model
15. Q&A - PivotTables, PivotCharts, and Refreshing Data
Learning Certificates

Showcase Your Skills

Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.

When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.

What Our Students Say

We don’t aim to satisfy, we aim to delight

Become A Data Citizen

Ready yourself for the rapidly changing world