# Power Pivot Training

Canonical URL: <https://www.creativelive.com/classes/power-pivot-training>

## Overview

Excel’s advanced business intelligence tools, including Power Pivot, Power Query, and DAX, provide powerful ways to clean, model, and analyze data. In this Power Pivot course, you will learn how to streamline your data analysis workflow from beginning to end.

The course covers Excel’s full business intelligence process, including query editing, data transformation, relationship modeling, and DAX calculations. You will also develop essential skills for building dynamic reports, improving workbook performance, and following best practices for advanced Excel analysis.

Ideal for analysts and advanced Excel users, this course helps you unlock Excel’s full potential for professional-level 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