In today’s tutorial, I want to highlight how important it is to build your data model relationships correctly. Data modelling is one of the foundations of your Power BI report so it’s necessary to set it up correctly. Previously, I discussed some techniques that can help you manage your model right. One of them is
In today’s blog, I want to teach you all about data table types. It’s important to understand how the tables work so you can build your data model effectively. A data table contains columns and rows of information used to achieve easier visual representation. There are two types of tables within a data model: the
This tutorial will cover about the most important Power BI dimension table in any model, the Date Table. The best practice when designing a model is to check for date fields. If they are present, always include a date dimension table. A Date Table includes all the attributes that you may want to slice, dice,
Let me discuss some advanced transformations in Power BI through the query editor. Remember that you can combine different actions within the query editor to fully optimize your models. It’s just a matter of familiarizing yourself with the different transformations in Power BI and finding out what scenarios they’re useful for. Exploring The Different Transformations
In this quick Power BI query editor tutorial, you’ll learn how to organize your queries to create intuitive models. It’s important that your models are as intuitive as possible. Not only will this make it easier for you to work on your models, it will also make it easier for other people to jump in
