Course Module 1

Video Lesson Name Keyword Video Location
The Power Pivot Versions and How They Differ PowerPivot Version Differences
Power View
32-bit / 64-bit
0:00
7:48
9:45

Course Module 5

Video Lesson Name Keyword Video Location
Working With Multiple Tables - Part 1 Multiple Tables
Days Sold Measure
DISTINCTCOUNT()
Days Sold via Calendar Measure
COUNTROWS()
Filters Only Flow Downhill
0:00
3:20
3:20
5:05
5:05
7:12
Working With Multiple Tables - Part 2 Assign Measure to Table
Orders per Day Measure
Orders per Calendar Day Measure
RELATED()
Filter Direction
0:00
3:15
6:00
10:30
13:40
Working With Multiple Tables - Part 3 Multiple Table Summary
Filter Direction
Filters Come From Look up Table
Math/Counting Comes From Data Table
0:00
0:00
1:40
3:00
Working With Multiple Tables - Part 4 Multiple Tables
Import from CSV
Rename Table
Create Relationship
Service Calls Measure
COUNTROWS()
Total Call Minutes Measure
SUM()
Average Call Length Measure
Traditional Excel
Hybrid Measures
Cost of Calls Measure
Net Margin Post Support Measure
PowerPivot Reflection
0:00
0:00
2:00
2:20
4:00
4:00
4:15
4:15
4:40
8:00
10:00
10:20
11:40
13:11
Working With Multiple Tables - Part 5 Multiple Tables
Conditional Formatting
Filters from Lookup vs. Data Table
Filters Flow to All Tables
Masked Problems
0:00
1:30
3:45
5:45
6:50
Working With Multiple Tables - Part 6 Budget vs. Actuals
Granularity Mismatch
Many to Many Problem
Unique Lookup Table
Copy/Paste Table Into Power Pivot
Double Hop Lookup
0:00
0:30
3:16
6:50
7:50
12:10
Working With Multiple Tables - Part 7 Multiple Tables
Budget vs. Actuals
BudgetedSales Measure
SUM()
Data Type Error
Multi-Column Relationship
% of Budget Measure
Relationship May Be Needed Error
0:00
0:00
1:00
1:00
1:15
4:15
10:45
11:30
Working With Multiple Tables - Part 8 Table Creation Techniques
Table Creation Techniques
Table Creation Techniques
Table Creation Techniques
Table Creation Techniques
Save As CSV
Multiple Tables
Budget vs. Actuals
Lack of Relationships
Hide from Client Tools
Portability
Conditional Formatting
0:25
0:30
2:00
4:00
9:00
11:00
11:45
11:45
11:45
17:40
19:20
19:45

Course Module 6

Video Lesson Name Keyword Video Location
Disconnected Slicers – Part 1 Disconnected Slicers
% Lost on Support Chart
% Lost on Support Measure
Cost of Calls Measure
What-If
Cost per Minute Slicer
Harvester Measures
Selected Call Rate Measure
"Cannot Be Determined in Current Context"
Cost of Calls Measure
Relationship May Be Needed
Slicers As More Than Filter
0:00
1:45
2:00
2:10
5:30
7:10
8:30
8:40
9:45
13:30
14:50
19:30
Disconnected Slicers – Part 2 Disconnnected Slicers
Disconnnected Table on Rows
0:00
2:15
Disconnected Slicers – Part 3 Dynamic Control of Which Measure in on Chart, by Slicer
Chart Type Selector
Incorrect YearMonth Field
T1000
Selected Measure Measure
MAX()
Harvester Measure
T1000 Measure
SWITCH()
Text Measure
FIRSTNONBLANK()
0:30
0:30
1:00
4:00
6:00
6:00
6:00
6:30
6:30
8:00
8:00
Disconnected Slicers – Part 4 "Sort By" Slicer
Selected Sort Measure
Hidden Column
SWITCH()
Selected Sort Id Measure
MIN()
Selected Sort Order Multiplier Measure
MAX()
2:30
4:00
4:00
6:00
7:00
7:00
7:15
7:15
Disconnected Slicers – Part 5 and Intro to FILTER() Sales from Largest Transactions Measure
CALCULATE()
VARIABLE Threshold
Harvester Measure
Sales from Largest Transactions Measure
CALCULATE()
DAX Error
FILTER()
0:00
0:00
1:30
2:00
2:40
3:00
3:00
4:48
Disconnected Slicers – Part 6  Coca-Cola Metaphor
Start/End Date Slicers
Selected EndDate Measure
LASTDATE()
Harvester Measure
Selected StartDate Measure
FIRSTDATE()
Harvester Measure
Margin Sel Date Range Measure
CALCULATE()
FILTER()
Date Axis Control
2:50
5:20
8:15
8:15
8:15
8:30
8:30
8:30
9:20
9:20
9:20
11:30
Disconnected Slicers – Part 7 Show Items With No Data on Rows
CALCULATE()
FILTER()
Just Bike Sales Measure
Just Bike Sales Measure - Filter Version
Filter Always Subtracts
2:30
5:00
5:00
8:05
9:15
11:00
Disconnected Slicers – Part 8 DATESBETWEEN()
Margin DatesBetween Version Measure
DATESBETWEEN() vs. FILTER()
0:00
0:00
6:00
Disconnected Slicers – Part 9 Variable Time Window Slicer
DATESBETWEEN()
Margin Date Window Measure
Date Windows Table
0:00
2:40
2:40
4:00
Disconnected Slicers – Part 10 Disconnected Slicers Recap
0:00

Course Module 8

Video Lesson Name Keyword Video Location
Filter Purpose vs. Table Purpose – Part 1 Filter Purpose vs. Table Purpose
All Calendar Rows Measure
ALL()
COUNTROWS()
FILTER()
DATESYTD()
0:00
4:45
4:45
4:45
9:45
17:00
Filter Purpose vs. Table Purpose – Part 2 Filter Purpose vs. Table Purpose
0:00
Intro to the VALUES Function VALUES()
COUNTROWS()
Customer Count Measure
DISTINCTCOUNT()
Households Measure
Households Above 1k Measure
VALUES()
COUNTROWS()
FILTER()
Sales to High Value Households Measure
Virtual Table Creation
0:00
1:45
1:45
2:00
2:00
7:30
7:30
7:30
7:30
13:45
15:45
VALUES Continued: IF, HASONEVALUE, Row Context Melting Ants
IF()
VALUES()
Effective Margin Measure
Missing Aggregation Function
Row Context
HASONEVALUE()
2:00
3:00
3:00
3:00
5:00
7:45
11:45
Putting the IF Stuff in Perspective, Introducing Filter Purpose of VALUES Just Bike Sales Measure
CALCULATE()
Sales From Largest Transactions Measure
If Sales Greater Than 500k Measure
All Product Sales Measure
CALCULATE()
Now With Values Measure
VALUES()
VALUES()
1:00
1:00
3:15
4:00
6:30
6:30
7:00
8:30
17:00
Recap of Table vs. Filter Purpose, VALUES Function, and Where We're Headed Filter Purpose vs. Table Purpose
Naked Column
VALUES()
3:00
4:30
6:30

Course Module 9

Video Lesson Name Keyword Video Location
Intro to Why We Need Custom Calendars Custom Calendars
0:00
Connecting a Custom Calendar, Using With Existing Basic Measures Connecting Custom Calendars
0:00
Navigation With a Custom Calendar Year Month
445 Prior Month Sales Measure
445 Prior Qtr Sales Measure
445 Prior Year Sales Measure
0:00
2:00
6:00
6:15
LTD, YTD and 3-Month MA Custom Calandar
445 Sales LTD Measure
445 Sales YTD Measure
VALUES()
445 3 month MA Measure
0:00
1:00
2:30
2:30
5:30

Course Module 10

Video Lesson Name Keyword Video Location
Advanced Calc Column Intro: Row Context and Scalars Calculated Columns
Row Context
Scalar
0:00
3:00
5:00
Behavior of Agg Functions & CALCULATE in Calc Columns Agg Functions
0:00
Intro to EARLIER – When It’s Commonly Used & How It Resembles “CURRENTROW” EARLIER()
FirstMonthInYear
0:00
2:15
EARLIER – In Depth” EARLIER()
Row Context
FILTER()
Days Where DayNumOf Week Equals Days Num of Month Measure
0:00
0:00
3:30
4:45
EARLIER – The Pattern and The Homework; Recap of Calc Column Concepts "Recipe for EARLIER()
0:00
Custom Calendar With Overrun, Helper Columns Prior Year Sales
Calendar Over-Run
445 Sales YTD Measure
MostRecentMonthID
MaxEffectiveMonthID
445 Sales PriorYear Measure
0:00
4:00
9:45
17:30
18:30
19:00
More Overrun Trimming, Sales/Day, Importance of Granular Custom Cal. Table 445 Sales YTD Measure
ISBLANK()
IF()
445 Days in Period Measure
445 Sales Per Day Measure
0:00
1:00
1:00
5:00
6:30
Building a Custom Calendar That Extends Down to Day Level Hybrid Calendar
0:00
Using “Hybrid” Custom Cal. Requires Sm. Mods to Orig. 445 Measure Patterns Hybrid Prior Month Sales 1 Measure
Hybrid Prior Month Sales 2 Measure
VALUES()
2:30
8:00
8:00

Course Module 11

Video Lesson Name Keyword Video Location
Date Granular Custom Calendars: Guidelines and Fixes Custom Calendar Guidelines
0:00
More Fixes, “Level Sensitivity” Importance & Cont’d. Helper Cols Importance Hybrid Prior Month Sales 3 Measure
Level of Pivot Measure
3:30
7:30
Moving Averages, YTD, Prior Year, and the Helper Columns Driving Them Magical Measurey Tour
Hybrid Sales Per Day Prior Month Measure
Hybrid Prior Year Sales Per Day Measure
Hybrid Sales Per Day 3 Month MA Measure
Hybrid Sales YTD Measure
Tour of Advanced Calculated Columns
0:00
1:00
1:15
2:00
3:30
4:00

Course Module 12

Video Lesson Name Keyword Video Location
Introduction, 1,000 Miles of Data, and Science Fiction Science Fiction and Huge Data Volumes
0:00
Tour of Tech History: Databases Are Like Record Players. Power Pivot Is Not How Databases Work
How Veripak Works
Rules of "File Club"
0:00
11:15
23:45
The First 4 Rules of File Club Removing Columns
Move Columns Into Lookup Tables
Unpivot Many Columns Into Many Rows
0:00
4:00
8:00
File Club Rules Continued Trim Precision
Avoid Calculated Columns
0:00
3:30
Putting the Rules Into Perspective, & Large Text Columns Perspective on File Size Rules
Avoid Large Text Columns
0:00
3:00
Compression, File Size, and Speed – the Link Revealed Impact of Compression on Performance
Impact of Row Iterators on Performance
0:00
0:00
FILTER() and Other Row Iterators Impact of Filtering Large Tables
3:30
The Sneaky Impact of Slicers, plus Bonus Tips Cross Slicer Filtering
0:00

Course Module 13

Video Lesson Name Keyword Video Location
Converting a Pivot to Formulas for Report Shaping & Intro to CUBEVALUE CUBEVALUE()
Hyperlink
CUBEVALUE()
0:00
8:00
10:00
Adding a Slicer to CUBEVALUE & Building a Pure “Scorecard-Shaped” Report CUBEMEMBER()
Textual Construction of Cube Formulas
Most Popular Color Measure
0:00
9:30
12:00
Intro to CUBEMEMBER & Some of Its Uses; EX: Detailed “Card” Reports Burst Into Regions
Capture Slicer Text
Cube Formulas Weaknesses
TOPN()
FIRSTNONBLANK()
Measure That Returns Text
0:00
2:00
4:45
12:00
12:00
12:00
“Bursting” With CUBEMEMBER & Three Limitations of Cube Formulas CUBESET()
CUBESETCOUNT()
3:15
5:30
CUBESET, CUBESETCOUNT, and CUBERANKEDMEMBER Expand .[ALL]
MAXX()
Force Cross Slicer Filtering
CUBERANKEDMEMBER()
mdx .Children Operator
0:00
1:30
4:00
6:15
14:00
Workarounds: “All” Returned From Slicer, Mini-Pivot for Cross Filter Max Single Date Sales Measure
Sales If Always Max Week Measure
1:30
8:30

Course Module 14

Video Lesson Name Keyword Video Location
Gateway to X Factor: MAXX and SUMX COUNTX()
Products Sold Measure
SUMX()
Sales Per Day
6:30
6:30
9:30
11:00
The Four Families of X Functions, and Intro to COUNTX and STDEVX RANKX()
Customer Sales Rank Measure
Customer Rank Reverse Order Measure
STDDEVX()
Sales Per Day STDDEV Measure
0:00
0:30
3:45
10:45
14:30
The Power (and Mystery) of RANKX Customer Rank Dense Ties Measure
Model Sales Rank vs. Competition Measure
4:30
9:00

Course Module 15

Video Lesson Name Keyword Video Location
“Freshness Date,” First Initial Slicer, Named Sets, & Dummy Tables Last Refresh Date
Dummy Table
Pre-Slice with Single Letter
Named Sets
Asymmetric Reporting
2:00
4:15
6:30
9:00
14:15
Multiple Variations on Top N TOPN()
Sales to Top 100 Customers Measure
Sales to Top N Customers Measure
Sales to Top Quartile of Customers Measure
S% of Sales to Top Quartile Measure
Sales to Nth Best Customer Measure
Average Transaction Size for N Best Customers Measure
Sales to Top N Customers Who Also Have Too Many Cars Measure
Dynamic TopN Display
Dynamic TopN With Cube Functions
0:00
0:45
2:30
3:45
4:15
5:00
7:45
8:30
14:00
17:15
Seasonality and Related Background Trend Correction Seasonality
LOOKUPVALUE()
0:00
5:30
“Same Store Sales” Simple Same Store Sales
Unable to Connect to Vertipak error
Transactions Above 0 Now and Last Yr Measure
Current Sales - Stores Active Today and Last Yr Measure
Complex Same Store Sales
0:00
2:06
3:26
6:15
7:33
New vs. Existing Customers and Visitors Tracking Activity from Old vs. New
Active Customers Measure
Active Customers LTD Measure
New Customers This Month Measure
Customer First Order Date Ever
New Customers Via First Order Date Measure
0:00
0:30
1:15
3:15
7:00
8:00
Conditional Format Via Slicer -- Handling Percentile Scenarios Slicer Controlled Conditional Formatting
Master Slicers
Multiple Date Columns
Weighted Average
0:00
0:00
0:00
6:00
Scenarios - 1 Slicer Drives Multiple Params and Weighted Avg. Using SUMX Inactive Relationships
USERELATIONSHIP()
Value of Goods Shippped Measure
Best Selling Date Measure
3:00
5:00
5:00
7:30
Gateway to Many to Many – Fixing Your “Relationship Problems" Many to Many Problem
USERELATIONSHIP()
Active vs. Inactive
Follow Inactives
Finding Top Selling Date
Finding The "Best"
0:00
0:00
3:00
4:33
6:42
11:51
Tackling True Many to Many Many to Many Problem
Many to Many Bridge Table
Units Sold m2m Measure
0:00
16:00
19:00

Course Module 16

Video Lesson Name Keyword Video Location
Why Use Macros With Power Pivot, What Are They, and a Dazzling Example Macros
Conditional Formatting Macro
0:00
6:45
The Developer Tab. Recording and Running Macros. “Wrapper” Macros Developer Tab
Macro Recorder
NoGrandTotals Macro
ModifySelectedPivot Macro
Assign Macro To Button
NoGrandTotalsAnywhere Macro
0:00
1:00
3:45
9:00
15:15
21:15
“Table of Contents” Macro, Macros w/ Inputs & “Remove all Measures” Macro TOCLinks Macro
SetHyperlink Macro
RemoveAllMeasuresFromPivot Macro
1:00
4:00
5:00
Two Great Web Resources: MSDN and Search Engines Macro Language Reference
0:00
Diving into the CF Macro, plus Slicer Macros and Bulk Workbook Mod Macros. Slicer Macros
AddAllSlicersToAllVisiblePivots Macro
IterateWOrkbooksInFolder Macro
Hide Gridlines and Headers Macro
2:45
3:00
9:45
9:45