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

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: *****

***** Learning Power BI? *****

[kevinmcmullen]

Thanks Greg! This is a great overview of tips and best practices/settings for data load/transformation in Power BI.

[DaveShaw-zq]

Great Video, with some really use tips, thanks a lot

[wasiuibrahim]

After the data preview is displayed, Load and Transform buttons are greyed out. Pls what is the causes?

[AbouAli]

Unbelievably perfect ….very well done!!

[darrylmorgan]

Some Really Great And Helpful Tips...Thank You Greg

[katB]

Thanks for sharing! Data loading sources - no mention on data flows?

[DanielWeikert]

Thanks for sharing. What is the idea behind reference data in your best practise tips?

[gregorywhite]

This is great! You mentioned separating the data from the visuals and endorsing datasets. Sounds good. What EntDNA videos would walk me through this?

[iraninejad]

Interesting tips! Quick Q, what's the best practices to work with data with different granularity level within a report?

[laurentmarc]

Very good package of tips :-) For performace reasons, in QueryEditor, should we choose the columns first, and then filter the rows or the contrary?