Power Pivot in Excel
| Course Details | ||||||||
|---|---|---|---|---|---|---|---|---|
|
||||||||
| Languages | ||||||||
|
||||||||
| Outcomes | ||||||||
|
||||||||
| Price & Terms | ||||||||
|
||||||||
| Technical | ||||||||
|
||||||||
| Specification | ||||||||
|
||||||||
Build an Excel data model with Power Pivot: link tables, write DAX measures and present results in a dashboard with slicers and PivotCharts.
Power Pivot turns Excel into a place to build data models, where several tables are joined by relationships and the calculations sit in the model itself. You switch on the add-in, load and tidy data with Power Query, connect fact and dimension tables, write DAX formulas whose results depend on row and filter context, and present the numbers in a report readers can filter themselves.
What You Will Achieve
- Enable the Power Pivot add-in and load prepared data into an Excel data model
- Link fact and dimension tables through relationships and add hierarchies to the model
- Write DAX calculated columns and measures that take row and filter context into account
- Assemble an interactive Excel report with PivotTables, PivotCharts, KPIs and slicers
Program Overview
Power Pivot Setup and Data Modeling
Gets the add-in running, brings data into the model, and connects the tables so they work as one structure.
- Turning on the Power Pivot add-in
- Importing and preparing data with Power Query
- Fact and dimension tables
- Relationships and hierarchies
DAX Formulas and Context
Introduces Data Analysis Expressions and the rules that decide what each formula returns.
- Calculated columns
- Aggregate measures
- Row and filter context
Interactive Dashboards and Data Stories
Turns the finished model into a report people can filter, with visuals arranged so the numbers tell a story.
- Visualizing data with PivotTables and PivotCharts
- Key performance indicators
- Slicers for interactivity
- Dashboard layout for a data story
Certificate Awarded (Paid)
Job Outlook
Excel data models and DAX measures are used in financial reporting, sales and operations analysis, and business intelligence work, wherever several related tables feed reports that are refreshed and filtered regularly.
Good for: Excel users who report on several related tables and want one data model with reusable DAX measures behind their PivotTables and charts.
Keep in mind: The hands-on work happens in your own installed copy of Excel, so the Power Pivot add-in has to be available on your machine.
Bottom line: A focused route through the Excel data model that ends with a dashboard built on DAX measures, KPIs and slicers.
Frequently Asked Questions
How do Power Pivot and Power Query differ?
Power Query retrieves data and applies transformations to clean and shape it before loading. Power Pivot then holds that data in a model, defines the relationships between tables and runs the calculations. The course uses Power Query early on to prepare data, then spends the rest of the time in Power Pivot.
Which version of Excel works best for the exercises?
Excel from Office 365 is the recommended choice, since it supports every feature the course uses. Older versions such as Excel 2016, 2019 and 2021 still handle most of the functions taught in this course.
How are the lessons and exercises delivered?
Short instructional videos alternate with interactive exercises. You carry out each task in Excel installed on your own computer, following the instructions given, and your answers receive immediate feedback so you can correct mistakes as you go.
User Reviews
Write your review
You must be logged in to post a review.
Reviews can only be posted by registered learners. Log in or create a free account, then you will return here to post.
There are no reviews yet.