# Power Pivot Training

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

## Overview

Excel’s advanced business intelligence tools, Power Pivot, Power Query, and DAX, offer powerful ways to clean, model, and analyze data. In our Power Pivot course, you’ll learn how to streamline your data analysis process from start to finish. This course guides you through Excel’s full BI workflow, covering query editing, data transformations, relationship modeling, and DAX calculations. You'll gain essential skills in creating dynamic reports, optimizing performance, and using best practices for advanced Excel workbooks. Perfect for analysts and Excel power users, this course unlocks the full potential of Excel 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

## Instructors

### Brian McClain — Program Director & Senior Instructor

Brian McClain is an experienced instructor, curriculum developer, and web developer. Brian served as Director for a coding bootcamp before joining Noble Desktop in 2022, where he is now a lead instructor and course developer for both JavaScript and Python. He teaches Web Development, JavaScript, Python for Data Science, Machine Learning, and AI. Prior to Noble, he taught Python Data Science and Machine Learning as an Adjunct Professor of Computer Science at Westchester County College.

Brian is also an active industry professional in the field of generative AI app development. His website and iOS app, Artmink, provides appraisals of art and antiques from user-uploaded images.

### Mourad Kattan — Program Director & Instructor

Mourad Kattan is an instructor and Program Director of Business, Finance, & Excel at Noble Desktop, teaching classes and designing courses in Excel, finance, accounting, and financial modeling.

Before Noble Desktop, Mourad worked as a financial analyst at Credit Suisse and H/2 Capital Partners. In those positions, he used advanced analytical and financial skills to evaluate a variety of investments.

Mourad graduated from the University of Pennsylvania summa cum laude and is part of the Beta Gamma Sigma honor society.

Learn more about [Mourad Kattan's](/mourad-kattan) background and expertise.

### Adebayo Norman — Instructor

Adebayo "Ade" Norman is a Senior Software Trainer with over 14 years of experience in the classroom. He is a training professional with vast troubleshooting/help desk experience and thousands of hours of software training & delivery experience. His specialty is in the In-person/Online Hybrid training environment needed in these new & changing times.

### Garfield Stinvil — Senior Instructor

Garfield is an experienced software trainer with over 16 years of real-world professional experience. He started as a data analyst with a Wall Street real estate investment company & continued working in the professional development department at New York Road Runners Organization before working at Noble. He enjoys bringing humor to whatever he teaches and loves conveying ideas in novel ways that help others learn more efficiently.

Since starting his professional training career in 2016, he has worked with several corporate clients including Adobe, HBO, Amazon, Yelp, Mitsubishi, WeWork, Michael Kors, Christian Dior, and Hermès. 

Outside of work, his hobbies include rescuing & archiving at-risk artistic online media using his database management skills.

## Pricing

**Tuition:** $325