Power Pivot in Excel

Overview

Master Power Pivot in Excel to help import data, create relationships, and utilize DAX. Build dynamic dashboards to uncover actionable insights.

In this comprehensive course, you will embark on a journey to harness the power of Power Pivot in Excel. Starting with the fundamentals, you will learn to set up Power Pivot, import data from various sources, and establish relationships in a data model. As the course progresses, you will delve into the world of DAX, mastering basic calculations and measures. You will then create visualizations and dynamic dashboards that tell compelling data stories to uncover actionable insights from your data. By the end of the course, you will have mastered Power Pivot and take your skills into the real world.

Syllabus

Starting with Power Pivot

You will take your first steps in setting up Power Pivot by enabling the add-in. Then, you will import data from various source types and practice preparing your data for analysis.

Data Modeling in Power Pivot

In this chapter, you will begin exploring data modeling concepts in Power Pivot, including creating relationships and hierarchies.

DAX in Power Pivot

In this chapter, you will explore DAX (Data Analysis Expressions) in Power Pivot. You will learn to write DAX formulas to create calculated columns and measures. You will also understand the importance of row and filter context when using DAX.

Dashboards with Power Pivot

In the final chapter, you will make your Excel reports interactive with Power Pivot by adding slicers and organizing your visuals in a way that tells a data story.