Data Loading And Transformation - Power BI Best Practices Vol. 1

Take our Report Development Best Practices Checklist course: portal.enterprisedna.co/p/rep...
Take our full course on Data Transformation & Modeling in Udemy: 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...
Power BI Best Practices Vol. 3 - DAX Calculations - • DAX Calculations - Pow...
Power BI Best Practices Vol. 4 - Reports & Visualization Pt. 1 - • Reports & Visualizatio...
Power BI Best Practices Vol. 4 - Reports & Visualization Pt. 2 - • Reports & Visualizatio...
Power BI Best Practices Vol. 5 - Top 10 - • Top 10 Power BI Best P...
Enterprise DNA Forum post for Extended Date Table M Code - forum.enterprisedna.co/t/exte...
Enterprise DNA Blog post for The Ultimate Budget Allocation Formula For Power BI Analysis - blog.enterprisedna.co/the-ult...
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - enterprisedna.co/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-...
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - enterprisedna.co/enterprise-d...