How to Model the Data in Power BI — Data Analysis in Power BI — Chapter 5

Explore data modelling capabilities like relationship, hierarchy and calculation using DAX.

Power BI helps you to understand your data after loading it but using the data modelling capabilities of this tool, you can create matured and refined analysis.

In previous blogs of this series (Data Analysis in Power BI), we get an idea of how to do data some ETL processes using Power BI.

In this blog, we are going to understand how to build the enriched data model to perform worldly analysis.


Define Relationship Cardinality and Cross-filter

To start with modelling, you need to design the relationship among tables. When you are defining this, at that time you should keep in mind what could be the cardinality and cross filter for these relationships.

Here is the video with examples to guide you.


Create Hierarchy

By default, you will get a date hierarchy if there is any date type column in your data set.

But if you want to create other hierarchies like product, geography etc., then there is a way to create that.

In the below video, you can find some examples which will help you to get a clear idea.

Calculation using DAX

DAX is one of the key parts of a well-performed data model.

It can help you to create some measures as well as calculated columns based on your requirements and allow you to reduce the data model size.

I think you should understand DAX in a proper way so that it will help you to create a powerful data model.

An enriched data model is the key point of any successful data analysis project.

Here are some series of videos on DAX to start with.

Conclusion

In this blog, you learn about below things

  1. Define Relationship Cardinality and Cross-filter
  2. Create Hierarchy
  3. DAX

In my next blog, we will learn more in detail.

If you have any questions related to this project, please feel free to post your comments.

Please visit my website for other technical resources.

Please like, comment and subscribe to my YouTube channel which you have already seen. 🙂 Keep Learning.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: