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.

Introduction to Power Pivot

What's the pivot?

Getting started in Power Pivot

Turn it on

Preparing data with Power Query

Manage data in Power Pivot

Starting with Power Pivot

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

Data modeling

Face the facts with dimensions

Data modeling in Power Pivot

Connection builds a relationship

Hierarchies

Mark your calendars

Data Modeling 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.

Introduction to DAX

Keep it in context

DAX in Power Pivot

It's math, not magic

We're related

Aggregate measures

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.

Data stories with dashboards

Story time

Dashboards in Power Pivot

Visualizing data with PivotTables

Key performance indicators

Visualizing data with PivotCharts

Slice and dice

Congratulations!

Dashboards with Power Pivot

Exercises and Datasets

Excel Formula Translations

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.

<h2>Starting with Power Pivot in Excel</h2>
Getting started on this insightful journey through Excel Power Pivot, transforming your data analysis skills. Begin by learning how to enable the Power Pivot add-in and import data from various sources. You will be guided through the initial steps of preparing your data for analysis, setting the stage for more advanced techniques.<br><br>
<h2>Exploring Data Modeling Concepts</h2>
Dive into the fundamental aspects of Power Pivot with data modeling. Learn to create relationships and hierarchies within your data, enabling a more structured and interconnected data model.<br><br>
<h2>Unveiling the Power of DAX in Excel</h2>
Unlock the potential of Data Analysis Expressions (DAX). Master the basics of DAX calculations, creating measures and calculated columns to perform advanced data manipulations, allowing you to level up your analytical capabilities.<br><br>
<h2>Crafting Interactive Reports</h2>
Utilize Power Pivot's strengths to help introduce interactivity and storytelling in your reports. Learn to add slicers and organize your visuals to create compelling data narratives. You will be able to create informative and engaging reports even within Excel.<br><br>
This course promises a hands-on approach to mastering Power Pivot in Excel, empowering you to become a proficient data analyst capable of easily extracting actionable insights.

Data Preparation in Excel

Introduction to Power Query in Excel

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

Power Pivot in Excel

Data Analysis with Excel Power Tools

Story time

Power Pivot in Excel

Hands-on interactive exercise