Data Modelling - Power BI Best Practices Vol. 2

Today, I’d like to discuss my best practices for Data Modelling. This is Volume 2 of a video series that discusses some of the best practices I’ve incorporated along my Power BI learning journey. As mentioned in the first video, I’ve consumed many resources which have been instrumental but has quickly become overwhelming. So I made my own notes that are easy to digest and hopefully these will be useful to others.

Greg

***** Video Details *****
00:00 Introduction
02:14 Star schema
03:23 Layout - Waterfall
04:06 Layout - Measures tables
04:29 Layout - Supporting tables
04:35 Manage relationships
05:58 Edit relationship
07:13 Single directional arrowhead
07:59 Active and inactive relationships
09:53 Linking columns
10:48 Column visibility

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

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

#EnterpriseDNA #PowerBI #PowerBITutorial #PowerBIDesktop #PowerBIDAX #DAX #DAXTutorial #GregPhilps #PowerBIBestPractices #DataModelling #PowerBIDataModelling

[sagenose]

Another great release. Thank you. There are two dislikes to this video.... I wonder what kind of person clicks that on a free informative video like this.

[darrylmorgan]

Really Helpful Data Modelling Tips...Thank You Greg

[DanielTavares]

I can not wait for the next videos..thanks!!

[learsj]

When would you use a single date table with active and inactive relationships over multiple date tables when you have more than one date object in your fact table?

[ricardothomas]

Good day thank you for this video.
Question, I in order to design/use Fact and Dimension tables in Power BI as described in this video there would have to be an SSIS solution that would have retrieved the data from the source systems and then create the Fact and Dimension tables right?
After which those Facts and Dimensions and pulled into Power BI?

[londonengland]

Where is the first pillar please? Thanks