Tag: Data Modelling

Building Data Dimensions In Power BI

Build Other Data Dimensions in Power BI

In today’s blog post, I want to discuss how you can build additional data dimensions in Power BI. These dimensions can help you filter your data in different ways. On top of that, these dimensions can help you come up with intuitive visualizations later on. This is also the reason why you need to set

Continue reading

Active And Inactive Data Relationships In Power BI

Active And Inactive Data Relationships

Previously, I discussed the importance of data model relationships in Power BI. I also introduced the one-to-many and many-to-one relationships. Now, I’ll teach you about the difference between active and inactive data relationships. These are important concepts that you need to be familiar with in data modelling. In this example, you can see that the

Continue reading

Techniques To Manage Your Data Model In Power BI

Techniques To Manage Your Data Model

For this tutorial, I want to discuss techniques in managing the relationships between the tables inside your data model. There are a lot of things that you need to remember to make your data model work effectively inside Power BI. It’s important to create a well-developed data model to help you communicate your business information

Continue reading

Understanding What Data Modeling Is And Creating The Right Relationships

After having an extensive discussion about the query editor, it’s time to move all that data into a Power BI report through data modeling. Data modeling allows you to connect different data tables in your Power BI report by creating relationships between them. Fixing Relationships In The Core Data Model My core data model consists

Continue reading

Converting A YYWWD Code Into A Date Value In Power BI

How To Convert YYWWD Code Into Date Value In Power BI Query Editor Tutorial

In this blog, we will be discussing how to convert a YYWWD code into a Date Value. This tutorial was based on a response to a query of an Enterprise DNA Support Forum member. The member asked for a way to convert his Confirmed delivery date field, which is in a year, week, and day of

Continue reading