Tag: Data Modelling

Data Model Power BI For Inventory Management

Data Model Power BI For Inventory Management

In this tutorial, you’ll learn how to properly create and set up the data model for inventory management dashboards in Power BI. Before you start working on the DAX formulas and visualizations, make sure to check if your data model is correct. If it isn’t, your DAX formulas aren’t going to work and your visualizations

Continue reading

How To Use Natural Language Query (Q&A) In Power BI

In this tutorial, I’ll show you what you can do with Natural Language Query (Q&A). It’s a feature within the Power BI online service and embedded in the Power BI desktop as well. For example, you’re in a meeting and you have your report, dashboard, and app ready, but you don’t have the specific information

Continue reading

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 in Power BI

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