Nick's Power BI Tricks - Data Modeling Edition

In this video, Nick shares some essential Power BI tricks for data modeling. He demonstrates how to create relationships between tables, create calculated columns, and measure values. Nick also shows how to use advanced features such as hierarchies and date tables to enhance your data model.

-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:

Let's connect:


Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
#pragmaticworks

00:00 Intro
02:03 Creating a Measures Repository
05:38 Organizing Measures into Folders
08:20 Adjusting Aggregation Types for Fields
10:39 Managing Implicit Measures and Aggregation Types
13:34 Utilizing "Show Related Fields When Card is Collapsed" Feature
15:07 Creating New Tabs in the Model View to Focus on Specific Sections

[caifax]

never knew layout was used that way. I've ended up getting used to Manage Relationships view instead, but that layout has really convinced me to switch back to that view. Thanks so much!

[hemanthrao]

Excellent techniques. Thank you for your knowledge. thanks

[HachiAdachi]

Tip 1.1: you can actually delete the 'HideMe' column *after* you add a measure to _Measure table.
Tip 2.1: you can even add a subfolder under a folder with "\". e.g. Prices\Max Prices

[billgillaspey]

I surely learned a lot--thanks for the tips & tricks !! You got more you can share...??

[sandbox]

Great tips! I did not know about these helpful tricks ;)

[dutchinfluencer]

You can just go to the data tab and add table and give it a name in dax for example "_measures =" to get a virtual table to put measures in. It will add a column by itself.

To be honest, I would always hide every column in fact tables and only put measures in it if you are working on large models. It will organize the facts on top and the dimensions at the bottom. If you have over a 100 measures (we have maybe about 500 measures in ERP model) a measure repository will be a mess.

I think it's the best way to keep the model understandable from a business user perspective. Just my two cents.

[milpatel]

The most important pain point about creating a measures table wasn't addressed: if you have 50 measures, you have to manually click each measure and change the Home table - this isn't feasible.

[SM-csnt]

These are more like Beginners Tips and Tricks and to be honest I expected more advanced advice here.

Also little here has to do with Data Modeling and more to do with how to use PowerBI

[SMStudio]

one note: separate measure table is slower - storing a measure there and not in the connecting Fact table results higher query times.

[digicrazemd]

Hi sir, Are you looking for professional YouTube thumbnail designer?