# Power Pivot Training Course

Canonical URL: <https://www.graduateschool.edu/courses/power-pivot-training>

## Overview

Excel’s advanced business intelligence tools—Power Pivot, Power Query, and DAX—provide powerful ways to clean, model, and analyze data. In our Power Pivot course, you’ll learn how to streamline your data analysis workflow from start to finish.

This course walks you through Excel’s complete BI process, covering query editing, data transformation, relationship modeling, and DAX calculations. You’ll build key skills in creating dynamic reports, optimizing performance, and applying best practices for advanced Excel workbooks. Ideal for analysts and Excel power users, this course unlocks Excel’s full potential for professional-grade data analysis.

## What you'll learn

- Apply advanced data modeling techniques using star and snowflake schemas, normalization, and relationship management
- Differentiate between calculated columns and measures while improving DAX performance with functions like VAR and USERELATIONSHIP()
- Master core and advanced DAX functions including CALCULATE, FILTER(), ALL(), and time intelligence tools 
- Build dynamic reports with custom calendar tables, dynamic date filters, and cumulative total calculations
- Design and implement KPIs in Power Pivot, including YoY % change and advanced visual integration for real-world scenarios
- Optimize data models for performance and readability while using best practices in Power Pivot and Excel data modeling

## Curriculum

#### Advanced Data Modeling Techniques

- Managing Relationships
- Star vs. Snowflake Schema: Best Practices
- Understanding Active/Inactive Relationships
- Role-Playing Dimensions
- Difference Between Calculated Columns vs. Measures

#### Advanced DAX Functions

- Review Basic DAX: Sum, Count, Average, Distinct Count
- CALCULATE
- FILTER(), ALL(), ALLEXCEPT(), VALUES(), REMOVEFILTERS()
- Time Intelligence Functions (SAMEPERIODLASTYEAR, DATESYTD)
- Dynamic Date Filtering and Custom Calendar Table

#### Advanced DAX – Part 2

- Introduction to data modeling
- Excel data model
- Database normalization
- Table relationships and cardinality
- Data model best practices

#### Power Pivot and DAX

- Using USERELATIONSHIP()
- Using VAR for better DAX performance and readability
- YoY % change

#### KPIs, Advanced Visual Integration & Real-World Scenarios

- Creating KPIs in Power Pivot
- Dynamic Product Ranking, Cumulative Totals
- Data Model Design Best Practices
- Tips for Performance Optimization
- Time Intelligence Best Practices

## Pricing

**Tuition:** $325