Microsoft Power BI - Go Beyond Pivot Tables with Power Pivot

Overview

Take the next step with Power Pivot!

This is the sixth course in the Microsoft Power BI series. This course focuses on using the Power Pivot features to enhance data analysis. Four features of Power Pivot will be reviewed:

• Data model
• Calculations
• Hierarchies
• KPIs

A majority of the course will be spent on building a data model and using calculations. You will learn how to add data to your data model either directly into PowerPivot or from Get & Transform/Power Query.

This self-study online course is part of the Microsoft Power BI: Power BI Series.

Highlights

Key Topics

• Data modeling
• Basic DAX and calculations
• Calculated columns and measures
• Data models and pivot tables
• Hierarchies

Prerequisites

Attended the Use Power Query to Transform Your Data course or equivalent

Objectives

Learning Outcomes

• Create a data model using Power Pivot
• Differentiate between calculated columns and measures
• Use Power Pivot for data analysis