PP05: Power Pivot Tutorial - MODEL DESIGN & 3 CRITICAL TIPS; Hide, Sort columns & Update Calendar

Chapters:
0:00 Introduction
1:03 Exercise data
2:29 DATA MODEL design
11:01 Add MEASURES & build a REPORT
15:21 Tip #1 hide columns from CLINET TOOL
18:59 Tip #2 SORT BY COLUMN
21:06 Tip #3 update CALEDANR table
23:21 Close
---------------------------------------------------------------------
To watch the full Playlist
https://youtube.com/playlist?list=PL5NlUYOM2iOjGP2BI0MYQMjLb6ZB4gxWv
---------------------------------------------------------------------
To watch PQB: Power Query Basics Series:
https://youtube.com/playlist?list=PL5NlUYOM2iOhZOJL_GM6zNd2k9-IEqmaV
---------------------------------------------------------------------
To watch PT: Pivot Tables Series:
https://youtube.com/playlist?list=PL5NlUYOM2iOgw8iAgG-DagodGryYSVtEA
---------------------------------------------------------------------
To download the working files:
https://drive.google.com/drive/folders/1zVYeR8EYohbM8nlnpgQTawKjey9Z7Pak?usp=sharing
---------------------------------------------------------------------
To subscribe:
https://www.youtube.com/channel/UCqwLHNFtrOjrOC3CnvviS1g?sub_confirmation=1
---------------------------------------------------------------------
To follow on Facebook:
https://www.facebook.com/excelispower
---------------------------------------------------------------------
To follow on linkedIn:
https://www.linkedin.com/in/amratef

Тэги:

#PivotTables #PowerPivot #Data_Analysis #Office_365 #power_Query #DAX #Data_Model #Add_Custom_Column #Measures #Advanced_Excel #Excel_Tutorial #One_to_Many_Relations #SUM #Implicit_measure #Calendar_Tables #SUMX #Update_Calendar #Hide_From_Client_Tool #Sort_by_Column

Скачать видео