Top 10 Power BI Best Practices

Today, I’m going to share my personal Top 10 Best Practices for Power BI. Over the past months, I’ve released a series of videos showcasing a number of best practices addressing the 4 pillars in Power BI report development. I talk about some of the best practices I’ve incorporated throughout the years of my Power BI learning journey. I’ve consumed many resources which have been instrumental but have quickly become overwhelming. So I made my own notes that are easy to digest and hopefully these will be useful to others. This will be a little different from the traditional Top 10s — rather than a ranked Top 10, I will instead be presenting my Top 10 favorites.

Greg

***** Video Details *****
00:00 Introduction
00:59 Auto date/time
01:11 Auto-detect relationships
01:20 Cross-filtering
01:38 Dates Table
02:04 Staging & Referencing data
03:36 Data volume
04:05 Star schema
04:32 Relationships
05:01 Verbose variable naming
05:39 SWITCH TRUE
06:16 Measure branching
07:17 Format \ General
08:40 Table-first development

***** Related Links *****

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

#EnterpriseDNA #PowerBI #PowerBIBestPractices #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #PowerQuery #PowerQueryTutorial #PowerBIReporting #PowerBIVisualization

[UU-rygt]

even 2 years later this is still valid. great content!

[jhormangomez]

I also use the underscore prefix to name my variables and @ for new columns in virtual tables, it's the best for readability

[excelrati]

Thanks for this great video. I especially liked the SWITCH TRUE one

[mehdihammadi]

Very interesting tips 👌.
I specially loved the last one start with a table then switch to the desired visual and it let me understand way some MVPs use this technique.

[LuanNguyen-plwf]

I wish i knew this. Man it could save me ton of hours. Thank you 🙏

[guillermoleonrodriguez]

Amazing, congratulation for such incredible video.

[BestICan]

On the topic of data staging queries, I load a monthly update from two flat files in two " From folder" queries. Is it best practice to load each month into two separate staging tables for transformation? The files are a source for Facts and a source for my Customer dimension. Thanks.

[shubhambusiness]

Hello author, Could you please share this pbix file, Thanks