Watch :3
Power Pivot Tutorial | PP
12 videos • 3,130 views • by ِAAA Excel English
1
PP01: Introduction to Power Pivot. What is it? Why you should use? and how to activate? Incl Example
AAA Excel’s Power
Download
2
PP02: Power Pivot tutorial - Data extraction & modeling
AAA Excel’s Power
Download
3
PP03: DAX Iterator Functions, Measures vs Added Columns, Filter Context, Internal & external filters
AAA Excel’s Power
Download
4
PP04: Power Pivot Tutorial - 3 ways to create CALENDAR TABLES, Why Calendar Table in a Data Model?
AAA Excel’s Power
Download
5
PP05: Power Pivot Tutorial - MODEL DESIGN & 3 CRITICAL TIPS; Hide, Sort columns & Update Calendar
AAA Excel’s Power
Download
6
PP06: Time intelligence Functions “PART I” Year on year change (CALCULATE-SAMEPERIODLASTYEAR-DIVIDE)
AAA Excel’s Power
Download
7
PP07: Time intelligence functions “PART II” shift dates backward using DAX (DATEADD function)
AAA Excel’s Power
Download
8
PP08: Time intelligence functions “PART III” - Running Total - "DATESMTD - DATESQTD - DATESYTD"
AAA Excel’s Power
Download
9
PP09 | Actual Vs Budget | 2 Fact Tables in a Data Model
ِAAA Excel English
Download
10
PP10 | Convert Pivot Table to Sheet Formulas | CUBEMEMBER&CUBEVALUE functions | Power Pivot tutorial
ِAAA Excel English
Download
11
PP11 | DAX | All vs ALLSELECTED vs VALUES | % of Total | Power Pivot Tutorial
ِAAA Excel English
Download
12
PP12 | DAX | VAR & RETURN to simplify your code | Power Pivot Tutorial
ِAAA Excel English
Download