Data Loading And Transformation - Power BI Best Practices Vol. 1
21.8 هزار بار بازدید -
3 سال پیش
-
Take our Report Development Best
Take our Report Development Best Practices Checklist course: https://portal.enterprisedna.co/p/rep...
Take our full course on Data Transformation & Modeling in Udemy: https://www.udemy.com/course/power-bi...
I’ve done a lot of research throughout my Power BI learning journey, and the volume of information can be overwhelming. In this video, I’d like to present and simplify some of the best practices I’ve adopted when developing Power BI reports for an efficient and optimal data loading and transformation.
Greg
**** Video Details ****
00:00 Introduction
01:17 Summary of content
01:42 Auto detect relationships
02:37 Cross filtering/highlighting
04:31 Separating dataset
05:22 Dedicated date table
06:43 Source
07:17 Staging & referencing data
08:27 Data Volume
10:15 Query folding
12:56 Connectivity mode
13:32 Location / Shape
14:29 Naming / Data types
16:10 Granularity
**** Related Links: ****
Power BI Best Practices Vol. 1 - Data Modelling - Data Modelling - Power BI Best Practi...
Power BI Best Practices Vol. 3 - DAX Calculations - DAX Calculations - Power BI Best Prac...
Power BI Best Practices Vol. 4 - Reports & Visualization Pt. 1 - Reports & Visualizations Pt. 1 - Powe...
Power BI Best Practices Vol. 4 - Reports & Visualization Pt. 2 - Reports & Visualizations Pt. 2 - Powe...
Power BI Best Practices Vol. 5 - Top 10 - Top 10 Power BI Best Practices
Enterprise DNA Forum post for Extended Date Table M Code - https://forum.enterprisedna.co/t/exte...
Enterprise DNA Blog post for The Ultimate Budget Allocation Formula For Power BI Analysis - https://blog.enterprisedna.co/the-ult...
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - http://enterprisedna.co/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...
Take our full course on Data Transformation & Modeling in Udemy: https://www.udemy.com/course/power-bi...
I’ve done a lot of research throughout my Power BI learning journey, and the volume of information can be overwhelming. In this video, I’d like to present and simplify some of the best practices I’ve adopted when developing Power BI reports for an efficient and optimal data loading and transformation.
Greg
**** Video Details ****
00:00 Introduction
01:17 Summary of content
01:42 Auto detect relationships
02:37 Cross filtering/highlighting
04:31 Separating dataset
05:22 Dedicated date table
06:43 Source
07:17 Staging & referencing data
08:27 Data Volume
10:15 Query folding
12:56 Connectivity mode
13:32 Location / Shape
14:29 Naming / Data types
16:10 Granularity
**** Related Links: ****
Power BI Best Practices Vol. 1 - Data Modelling - Data Modelling - Power BI Best Practi...
Power BI Best Practices Vol. 3 - DAX Calculations - DAX Calculations - Power BI Best Prac...
Power BI Best Practices Vol. 4 - Reports & Visualization Pt. 1 - Reports & Visualizations Pt. 1 - Powe...
Power BI Best Practices Vol. 4 - Reports & Visualization Pt. 2 - Reports & Visualizations Pt. 2 - Powe...
Power BI Best Practices Vol. 5 - Top 10 - Top 10 Power BI Best Practices
Enterprise DNA Forum post for Extended Date Table M Code - https://forum.enterprisedna.co/t/exte...
Enterprise DNA Blog post for The Ultimate Budget Allocation Formula For Power BI Analysis - https://blog.enterprisedna.co/the-ult...
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - http://enterprisedna.co/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...
3 سال پیش
در تاریخ 1399/11/30 منتشر شده
است.
21,848
بـار بازدید شده