### Course Module 1

 Video Lesson Name Keyword Video Location The Power Pivot Versions and How They Differ PowerPivot Version DifferencesPower View32-bit / 64-bit 0:007:489:45

### Course Module 2

 Video Lesson Name Keyword Video Location A Tour of Data Sample WorkbookData Loaded WorkbookImport from AccessPreview and FilterCreation RelationshipTable RelationshipData TableLookup TableCalendar Table 0:100:101:111:403:556:206:507:108:20 Warmup & Fundamentals Pivot TableField ListMeasuresTotal Sales MeasureSUM()RelationshipData TablesLookup TablesRelationship DirectionPortabilityOrder Lines MeasureCOUNTROWS()Orders MeasureDISTINCTCOUNT()Avg Sales Amt Per Order Measure 1:001:082:052:282:506:057:207:2012:2513:2513:5014:0016:3016:3018:50 Measures vs. Calculated Columns Measure vs Calculated ColumnCost of Goods Sold MeasureSUM()Total Margin MeasurePerRowMargin Calculated ColumnOut of Sync ProblemCost of Goods Based on Per Row MeasureSUM()Random1 MeasureRand2 Calculated ColumnIsWeekend Calculated ColumnSWITCH()Measure vs Calculated Column Summary 0:002:332:403:194:355:506:456:458:018:5013:2214:1817:00 Thinking Like the Power Pivot Formula Engine Thinking Like the EngineTroubleshootingFiltersIslandsFilters Then MathFilter ContextVisualize Filter ContextDiagram ViewReference CardFundamentals Review 0:000:582:554:285:228:1510:0015:0024:3026:15

### Course Module 3

 Video Lesson Name Keyword Video Location The CALCULATE Function CALCULATE()OthelloCALCULATE()Just Bike Sales Measure% Sales From Bikes MeasureAssembly LineAdd to Filter ContextReplace Filter In Context 0:000:404:156:258:3012:3815:2518:25 CALCULATE Part Two Fever, Christopher WalkenFilter by Amount TypeSUM()CALCULATE()Total Sales MeasureCALCULATE()Total Refunds MeasureNet Sales MeasureTotal Voids MeasureFilter by Magnitude BucketCALCULATE()Zero vs. Blank% Sales from Largeish Transactions MeasureRemove Rows of All BlanksPortability 0:001:153:304:114:116:306:307:007:3510:0011:0512:4014:0015:0016:45 CALCULATE Part Three CALCULATE()CALCULATE()Filter by MultipleFormattingInitial vs. Calculate FiltersOR()Not Equal, <> CALCULATE() 0:002:052:303:159:3013:3515:3021:15

### Course Module 4

 Video Lesson Name Keyword Video Location The ALL() Function ALL()CALCULATE()All Month Sales MeasureALL()Grand Total CellNumber of Days MeasureCOUNTROWS()CALCULATE()All Month Number of Days Measure% of Total% of All Month Sales MeasureShow Values As% of All Month Days MeasureProrated to All Month Sales 0:001:101:101:354:056:256:257:387:488:308:489:5310:4011:25 ALL() With Sematically Equivalent Columns Sort by Column% of All Weekday Sales MeasureCALCULATE()ALL()Short Day Name Calculated Column 0:252:252:252:253:42 Slicer Negation Using ALL() Slicer NegationALL()CALCULATE()ALL()ALL()ALL() 0:000:001:101:103:505:50 ALL() "Cousins" All Time Sales MeasureCALCULATE()ALL()ALLEXCEPT()Alltime DayofWeek Sales MeasuresField on both Row and Slicer% of Visual TotalCALCULATE()ALLSELECTED()AllSelected product sales Measure% of ALLSELECTED Product Sales Measure 3:003:003:004:306:308:009:4012:0012:0012:0013:15

### Course Module 5

 Video Lesson Name Keyword Video Location Working With Multiple Tables - Part 1 Multiple TablesDays Sold MeasureDISTINCTCOUNT()Days Sold via Calendar MeasureCOUNTROWS()Filters Only Flow Downhill 0:003:203:205:055:057:12 Working With Multiple Tables - Part 2 Assign Measure to TableOrders per Day MeasureOrders per Calendar Day MeasureRELATED()Filter Direction 0:003:156:0010:3013:40 Working With Multiple Tables - Part 3 Multiple Table SummaryFilter DirectionFilters Come From Look up TableMath/Counting Comes From Data Table 0:000:001:403:00 Working With Multiple Tables - Part 4 Multiple TablesImport from CSVRename TableCreate RelationshipService Calls MeasureCOUNTROWS()Total Call Minutes MeasureSUM()Average Call Length MeasureTraditional ExcelHybrid MeasuresCost of Calls MeasureNet Margin Post Support MeasurePowerPivot Reflection 0:000:002:002:204:004:004:154:154:408:0010:0010:2011:4013:11 Working With Multiple Tables - Part 5 Multiple TablesConditional FormattingFilters from Lookup vs. Data TableFilters Flow to All TablesMasked Problems 0:001:303:455:456:50 Working With Multiple Tables - Part 6 Budget vs. ActualsGranularity MismatchMany to Many ProblemUnique Lookup TableCopy/Paste Table Into Power PivotDouble Hop Lookup 0:000:303:166:507:5012:10 Working With Multiple Tables - Part 7 Multiple TablesBudget vs. ActualsBudgetedSales MeasureSUM()Data Type ErrorMulti-Column Relationship% of Budget MeasureRelationship May Be Needed Error 0:000:001:001:001:154:1510:4511:30 Working With Multiple Tables - Part 8 Table Creation TechniquesTable Creation TechniquesTable Creation TechniquesTable Creation TechniquesTable Creation TechniquesSave As CSVMultiple TablesBudget vs. ActualsLack of RelationshipsHide from Client ToolsPortabilityConditional Formatting 0:250:302:004:009:0011:0011:4511:4511:4517:4019:2019:45

### Course Module 6

 Video Lesson Name Keyword Video Location Disconnected Slicers – Part 1 Disconnected Slicers% Lost on Support Chart% Lost on Support MeasureCost of Calls MeasureWhat-IfCost per Minute SlicerHarvester MeasuresSelected Call Rate Measure"Cannot Be Determined in Current Context"Cost of Calls MeasureRelationship May Be NeededSlicers As More Than Filter 0:001:452:002:105:307:108:308:409:4513:3014:5019:30 Disconnected Slicers – Part 2 Disconnnected SlicersDisconnnected Table on Rows 0:002:15 Disconnected Slicers – Part 3 Dynamic Control of Which Measure in on Chart, by SlicerChart Type SelectorIncorrect YearMonth FieldT1000Selected Measure MeasureMAX()Harvester MeasureT1000 MeasureSWITCH()Text MeasureFIRSTNONBLANK() 0:300:301:004:006:006:006:006:306:308:008:00 Disconnected Slicers – Part 4 "Sort By" SlicerSelected Sort MeasureHidden ColumnSWITCH()Selected Sort Id MeasureMIN()Selected Sort Order Multiplier MeasureMAX() 2:304:004:006:007:007:007:157:15 Disconnected Slicers – Part 5 and Intro to FILTER() Sales from Largest Transactions MeasureCALCULATE()VARIABLE ThresholdHarvester MeasureSales from Largest Transactions MeasureCALCULATE()DAX ErrorFILTER() 0:000:001:302:002:403:003:004:48 Disconnected Slicers – Part 6 Coca-Cola MetaphorStart/End Date SlicersSelected EndDate MeasureLASTDATE()Harvester MeasureSelected StartDate MeasureFIRSTDATE()Harvester MeasureMargin Sel Date Range MeasureCALCULATE()FILTER()Date Axis Control 2:505:208:158:158:158:308:308:309:209:209:2011:30 Disconnected Slicers – Part 7 Show Items With No Data on RowsCALCULATE()FILTER()Just Bike Sales MeasureJust Bike Sales Measure - Filter VersionFilter Always Subtracts 2:305:005:008:059:1511:00 Disconnected Slicers – Part 8 DATESBETWEEN()Margin DatesBetween Version MeasureDATESBETWEEN() vs. FILTER() 0:000:006:00 Disconnected Slicers – Part 9 Variable Time Window SlicerDATESBETWEEN()Margin Date Window MeasureDate Windows Table 0:002:402:404:00 Disconnected Slicers – Part 10 Disconnected Slicers Recap 0:00

### Course Module 7

 Video Lesson Name Keyword Video Location Time Intelligence – Part 1 Calendar TableCalendar TableRequirementsMark as Data Table 0:003:003:006:50 Time Intelligence – Part 2 Year to DateYTD Sales MeasureCALCULATE()DATESYTD()DATESYTD()Sort by ColumnYTD Grand Total Cell 0:000:000:450:454:009:0013:00 Time Intelligence – Part 3 Calendar Table SourcesCreate Calendar Table in ExcelTrimmed Calendar TableSave As CSV 0:006:3012:3014:00 Time Intelligence – Part 4 CALCULATE()DATESYTD()FISCALYTD Sales MeasureQTD Sales MeasureDATESQTD()eCALCULATE()LTD Sales MeasureCALCULATE()DATESBETWEEN()LASTDATE() 0:000:000:453:304:004:0010:3010:3010:3010:30 Time Intelligence – Part 5 PortabilityPrior Year SalesLast Year Sales MeasureCALCULATE()DATEADD()% Growth vs. LY MeasureDATEADD() 0:004:354:354:354:356:508:15 Time Intelligence – Part 6 Moving Average3 Month Moving Sum MeasureDATESINPERIOD()DATESINPERIOD() vs. DATEADD()3 Month Moving Average MeasureCorrect Moving Average DenominatorDATESINPERIOD() 0:002:452:456:0010:4511:4513:30 Time Intelligence – Part 7 Inventory FunctionsCLOSINGBALANCE()OPENINGBALANCE()CALCULATE()ENDOFQUARTER() 0:006:008:1510:1510:15 Time Intelligence – Part 8 FIRSTNONBLANK()LASTNONBLANK()Last Sold Date MeasureFirst Sales Date MeasureYEARFRAC()LASTNONBLANK()FIRSTNONBLANK(),LASTNONBREAK()FIRSTNONBLANK(),LASTNONBREAK() 0:000:001:454:456:508:1512:4515:00

### Course Module 8

 Video Lesson Name Keyword Video Location Filter Purpose vs. Table Purpose – Part 1 Filter Purpose vs. Table PurposeAll Calendar Rows MeasureALL()COUNTROWS()FILTER()DATESYTD() 0:004:454:454:459:4517:00 Filter Purpose vs. Table Purpose – Part 2 Filter Purpose vs. Table Purpose 0:00 Intro to the VALUES Function VALUES()COUNTROWS()Customer Count MeasureDISTINCTCOUNT()Households MeasureHouseholds Above 1k MeasureVALUES()COUNTROWS()FILTER()Sales to High Value Households MeasureVirtual Table Creation 0:001:451:452:002:007:307:307:307:3013:4515:45 VALUES Continued: IF, HASONEVALUE, Row Context Melting AntsIF()VALUES()Effective Margin MeasureMissing Aggregation FunctionRow ContextHASONEVALUE() 2:003:003:003:005:007:4511:45 Putting the IF Stuff in Perspective, Introducing Filter Purpose of VALUES Just Bike Sales MeasureCALCULATE()Sales From Largest Transactions MeasureIf Sales Greater Than 500k MeasureAll Product Sales MeasureCALCULATE()Now With Values MeasureVALUES()VALUES() 1:001:003:154:006:306:307:008:3017:00 Recap of Table vs. Filter Purpose, VALUES Function, and Where We're Headed Filter Purpose vs. Table PurposeNaked ColumnVALUES() 3:004:306: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 Month445 Prior Month Sales Measure445 Prior Qtr Sales Measure445 Prior Year Sales Measure 0:002:006:006:15 LTD, YTD and 3-Month MA Custom Calandar445 Sales LTD Measure445 Sales YTD MeasureVALUES()445 3 month MA Measure 0:001:002:302:305:30

### Course Module 10

 Video Lesson Name Keyword Video Location Advanced Calc Column Intro: Row Context and Scalars Calculated ColumnsRow ContextScalar 0:003:005: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:002:15 EARLIER – In Depth” EARLIER()Row ContextFILTER()Days Where DayNumOf Week Equals Days Num of Month Measure 0:000:003:304: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 SalesCalendar Over-Run445 Sales YTD MeasureMostRecentMonthIDMaxEffectiveMonthID445 Sales PriorYear Measure 0:004:009:4517:3018:3019:00 More Overrun Trimming, Sales/Day, Importance of Granular Custom Cal. Table 445 Sales YTD MeasureISBLANK()IF()445 Days in Period Measure445 Sales Per Day Measure 0:001:001:005:006: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 MeasureHybrid Prior Month Sales 2 MeasureVALUES() 2:308:008: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 MeasureLevel of Pivot Measure 3:307:30 Moving Averages, YTD, Prior Year, and the Helper Columns Driving Them Magical Measurey TourHybrid Sales Per Day Prior Month MeasureHybrid Prior Year Sales Per Day MeasureHybrid Sales Per Day 3 Month MA MeasureHybrid Sales YTD MeasureTour of Advanced Calculated Columns 0:001:001:152:003:304: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 WorkHow Veripak WorksRules of "File Club" 0:0011:1523:45 The First 4 Rules of File Club Removing ColumnsMove Columns Into Lookup TablesUnpivot Many Columns Into Many Rows 0:004:008:00 File Club Rules Continued Trim PrecisionAvoid Calculated Columns 0:003:30 Putting the Rules Into Perspective, & Large Text Columns Perspective on File Size RulesAvoid Large Text Columns 0:003:00 Compression, File Size, and Speed – the Link Revealed Impact of Compression on PerformanceImpact of Row Iterators on Performance 0:000: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()HyperlinkCUBEVALUE() 0:008:0010:00 Adding a Slicer to CUBEVALUE & Building a Pure “Scorecard-Shaped” Report CUBEMEMBER()Textual Construction of Cube FormulasMost Popular Color Measure 0:009:3012:00 Intro to CUBEMEMBER & Some of Its Uses; EX: Detailed “Card” Reports Burst Into RegionsCapture Slicer TextCube Formulas WeaknessesTOPN()FIRSTNONBLANK()Measure That Returns Text 0:002:004:4512:0012:0012:00 “Bursting” With CUBEMEMBER & Three Limitations of Cube Formulas CUBESET()CUBESETCOUNT() 3:155:30 CUBESET, CUBESETCOUNT, and CUBERANKEDMEMBER Expand .[ALL]MAXX()Force Cross Slicer FilteringCUBERANKEDMEMBER()mdx .Children Operator 0:001:304:006:1514:00 Workarounds: “All” Returned From Slicer, Mini-Pivot for Cross Filter Max Single Date Sales MeasureSales If Always Max Week Measure 1:308:30

### Course Module 14

 Video Lesson Name Keyword Video Location Gateway to X Factor: MAXX and SUMX COUNTX()Products Sold MeasureSUMX()Sales Per Day 6:306:309:3011:00 The Four Families of X Functions, and Intro to COUNTX and STDEVX RANKX()Customer Sales Rank MeasureCustomer Rank Reverse Order MeasureSTDDEVX()Sales Per Day STDDEV Measure 0:000:303:4510:4514:30 The Power (and Mystery) of RANKX Customer Rank Dense Ties MeasureModel Sales Rank vs. Competition Measure 4:309:00

### Course Module 15

 Video Lesson Name Keyword Video Location “Freshness Date,” First Initial Slicer, Named Sets, & Dummy Tables Last Refresh DateDummy TablePre-Slice with Single LetterNamed SetsAsymmetric Reporting 2:004:156:309:0014:15 Multiple Variations on Top N TOPN()Sales to Top 100 Customers MeasureSales to Top N Customers MeasureSales to Top Quartile of Customers MeasureS% of Sales to Top Quartile MeasureSales to Nth Best Customer MeasureAverage Transaction Size for N Best Customers MeasureSales to Top N Customers Who Also Have Too Many Cars MeasureDynamic TopN DisplayDynamic TopN With Cube Functions 0:000:452:303:454:155:007:458:3014:0017:15 Seasonality and Related Background Trend Correction SeasonalityLOOKUPVALUE() 0:005:30 “Same Store Sales” Simple Same Store SalesUnable to Connect to Vertipak errorTransactions Above 0 Now and Last Yr MeasureCurrent Sales - Stores Active Today and Last Yr MeasureComplex Same Store Sales 0:002:063:266:157:33 New vs. Existing Customers and Visitors Tracking Activity from Old vs. NewActive Customers MeasureActive Customers LTD MeasureNew Customers This Month MeasureCustomer First Order Date EverNew Customers Via First Order Date Measure 0:000:301:153:157:008:00 Conditional Format Via Slicer -- Handling Percentile Scenarios Slicer Controlled Conditional FormattingMaster SlicersMultiple Date ColumnsWeighted Average 0:000:000:006:00 Scenarios - 1 Slicer Drives Multiple Params and Weighted Avg. Using SUMX Inactive RelationshipsUSERELATIONSHIP()Value of Goods Shippped MeasureBest Selling Date Measure 3:005:005:007:30 Gateway to Many to Many – Fixing Your “Relationship Problems" Many to Many ProblemUSERELATIONSHIP()Active vs. InactiveFollow InactivesFinding Top Selling DateFinding The "Best" 0:000:003:004:336:4211:51 Tackling True Many to Many Many to Many ProblemMany to Many Bridge TableUnits Sold m2m Measure 0:0016:0019:00

### Course Module 16

 Video Lesson Name Keyword Video Location Why Use Macros With Power Pivot, What Are They, and a Dazzling Example MacrosConditional Formatting Macro 0:006:45 The Developer Tab. Recording and Running Macros. “Wrapper” Macros Developer TabMacro RecorderNoGrandTotals MacroModifySelectedPivot MacroAssign Macro To ButtonNoGrandTotalsAnywhere Macro 0:001:003:459:0015:1521:15 “Table of Contents” Macro, Macros w/ Inputs & “Remove all Measures” Macro TOCLinks MacroSetHyperlink MacroRemoveAllMeasuresFromPivot Macro 1:004:005: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 MacrosAddAllSlicersToAllVisiblePivots MacroIterateWOrkbooksInFolder MacroHide Gridlines and Headers Macro 2:453:009:459:45