Don't Make These DATA MODELING MISTAKES | Data Modeling Best Practices in Power BI | Goodly

In this video, we will learn about the 5 best Data Modeling practices to help us make some intelligent & efficient models!

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[shujashakir]

Because I focus primarily on building a right data model and spend most of my working hours on that issue, I also realised we need to separate all text values from the fact table and accomodate them in separate dimension tables so that fact table has only numeric values. I found that eases our task like nothing else. I worked on data with 12 million rows and everything worked butter-smooth only after I moved all its text values to smaller dimension tables.

[fredhazelton]

This is excellent! Becoming my fav channel for PBI

[tomoleusz]

Thank you for another great video. I find you channel one of the best PBI resources on YouTube. Your skill of explaining complex topics in simple way is truly amazing. Recently I struggled with exactly the same granularity issue as in your video. It took me some time to figure out why my average calculations did not work 😅

[Ramesh]

We want an end to end DAX learning video with examples on row and filter context.

[udusegbe]

Totally agree. I always follow the mantra of keeping the model simple. I resonate well with #3 - reducing columns in fact table. Too often I enter into discussions on why to use only columns that are specifically needed. And you rightly alluded to: there is the inherent human need to keep hold of something that is not needed now but want to hold on to it anyway! ;-)

[Ratnakumarwrites]

More videos on data modelling would be awesome

[sauravkragrawal]

Hi Chandeep, your videos just keep making me a bigger fan of urs.

I have a query and need ur help pls.

There are 2 data sets : One for Jan 23 and other for Dec 22. There are 300 columns and lacs in each. Objective is to compare the value of each cell and give a pivot table with the reference to those cells which are not matching. Please note that row numbers might be different in both workbooks and hence a field named "unique identifier" is used as the unique finder of the row values.

Another catch is if any value is newly inserted in existing row in Jan 23, that should not reflect as a variance.


Request your guidance please.

[VishwasKadrolli]

Hi Chandeep, great to see your videos. One other best practice I follow is creating the 'Measures Table' and giving right names to the measures.

[abdosobhy]

YOU ARE AWESOME!
Thanks a lot, I really enjoy your videos, they make me understand PowerBI much better!

[rudroroy]

This was great video, thank you, I would love to see more "Best Practises in Power BI" Videos.

[mjtr]

Your explanations are so clear and easy to understand even by beginners like me ❤

[Chris-tjes]

Best video i have seen so far on best practices. Straightforward. Many thanks 🙏🙏🙏

[sanketadhyapak]

Great Video ❤ Very recently i have started following few of these practices..especially having minimum required columns in Fact👍

[venkysamudrala]

Hi Chandeep/Goodly, another awesome video and thanks for imparting your knowledge to all of us. Big fan here.

On reducing the granularity, how to model when the user is requesting for Median and Nth Percentiles on TATs (the user wants to parameterize the N) and also wants to view at variable slices/dimensions? I do want to create an aggregate table to improve the performance, however, confused about how to get the best of both worlds.

Will look forward to your suggestions...

[gustavobarbosa]

Hi, Chandeep. thank you for one more useful and interesting video! However, I have one doubt.

You concluded your comment on the need to check granularity saying that the second code option would be preferrable for not triggering context transition.

However, I had the impression that using a measure within another measure always triggers the transition. Do I have it wrong? A simple yes or no would suffice. Thanks again!

[abhishekkumar-eswl]

Hi sir, First of all, I watched your first video and I liked it very very much. Thanks a lot for helping the community. Also can you please suggest any of your video for Dimensional Modelling with some example (Facts and Dimensions)?

[emilmubarakshin]

Thank you sir, for sharing these Wonderful advices. Every video from you is like a gift. Thank you again and have a wonderful day.

[vasilisa]

Hi, Chandeep! Amazing tips, thank you!

[pierregrand]

Hi. Thank you for all your invaluable videos tackling real issues faced. One question about bridge table. Do you recommande to use ‘reference’ the original table or ‘Duplicate’ table. I would go for ‘Reference’ assuming the data are loaded only once but could create some issues that I do not know afterward?

[IvanCortinas_ES]

Thank you for this brilliant and clear explanation!!