PP02: Power Pivot tutorial - Data extraction & modeling
Chapters
-----------------------------------------------------------------------------------------------------------------------
Intro 0:00
1- From excel table 4:00
2- Copy and paste from a range of cells 6:59
3- From another Excel workbook 9:15
4- From CSV file 11:24
5- Left & Len DAX Functions 13:43
6- From a folder contains CSV files using Power Query 16:36
7- Star Schema 24:16
8- Implicit & Explicit measures 29:18
9- Calculate: total quantity, no of transaction using Sum & Count functions 36:08
10- 3 different places to write DAX measures 37:46
To watch the full Playlist
• PP: Power Pivot Tutorial
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 files:
https://drive.google.com/drive/folder...
To subscribe:
/ @aaaexcel
To follow on Facebook:
/ excelispower
To follow on linkedIn:
/ amratef
On this page of the site you can watch the video online PP02: Power Pivot tutorial - Data extraction & modeling with a duration of hours minute second in good quality, which was uploaded by the user AAA Excel's Power 06 September 2021, share the link with friends and acquaintances, this video has already been watched 20,958 times on youtube and it was liked by 516 viewers. Enjoy your viewing!
