Chapters:
------------------------------------------------------------------------------------------------
Intro: 0:00
1- What is power pivot (1:00)
2- What are power pivot uses: (4:34)
3- How to activate power pivot: (8:06)
4- One to Many relations - tart of the practical example: (10:47)
5- Trigger data model directly by creating a pivot table: (19:16)
6- Trigger data model using the power pivot ribbon: (21:32)
7- Add Calculated Column: (23:17)
8- Calculate Average Price using Dax Measure: (28:25)
9- Add number formatting to a Dax Measure: (33:31)

To watch PQB: Power Query Basics Series:
   • PQB :Power Query Basics  

To watch PT: Pivot Tables Series:
   • Excel Data Analysis: PT - Pivot Tables  

To download the excel file:
https://drive.google.com/file/d/1Tj6C...

To subscribe:
   / @aaaexcel  

To follow on Facebook:
  / excelispower  

To follow on linkedIn:
  / amratef