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

Take our Report Development Best Practices Checklist course: https://portal.enterprisedna.co/p/report-development-best-practices-checklist/ Take our full course on Data Transformation & Modeling in Udemy: https://www.udemy.com/course/power-bi-advanced-data-transformations-and-modeling/?referralCode=2F44B1B51BD63AC57012 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 - https://youtu.be/EocrvXatsd4 Power BI Best Practices Vol. 3 - DAX Calculations - https://youtu.be/NtZnlOP3MoY Power BI Best Practices Vol. 4 - Reports & Visualization Pt. 1 - https://youtu.be/Z9oO0p0E05c Power BI Best Practices Vol. 4 - Reports & Visualization Pt. 2 - https://youtu.be/M_HVYMvtP7U Power BI Best Practices Vol. 5 - Top 10 - https://youtu.be/AlIvIlqKcB0 Enterprise DNA Forum post for Extended Date Table M Code - https://forum.enterprisedna.co/t/extended-date-table-power-query-m-function/6390 Enterprise DNA Blog post for The Ultimate Budget Allocation Formula For Power BI Analysis - https://blog.enterprisedna.co/the-ultimate-budget-allocation-formula-for-power-bi-analysis/ ***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax FREE - Power BI Resources - http://enterprisedna.co/power-bi-resources FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-reference-guide-download/ Enterprise DNA Membership - https://enterprisedna.co/membership Enterprise DNA Online - http://portal.enterprisedna.co/ Enterprise DNA Events - https://enterprisedna.co/enterprise-dna-events-page/