Power Query is used to prepare each of the tables loaded into the data model. Hence, it’s fundamental that the tables, fields, and measures in the data model should be uncomplicated and user-friendly. In this tutorial, let’s talk about some Power Query best practices for our data model, some of its features, and why we
The second pillar of Power BI development is data modelling. In this tutorial, you’ll learn about all the important things to consider when it comes to setting up your Power BI data model. What follows is a comprehensive overview on data model development best practices. Organizing Your Power BI Data Model 1. Star Schema One
This tutorial is about the best practices when using the VertiPaq Engine in Power BI. You’ll learn different techniques and approaches to make your DAX calculations perform smoother. To be able to utilize your data models and relationships, you need to set them up in a way where you can understand the flow of your
This tutorial will feature the best practices for DAX calculations when developing reports in Power BI. You can watch the full video of this tutorial at the bottom of this blog. DAX calculations are one of the four pillars of Power BI development. In this post, you’ll learn tips on how to maximize your DAX in order to obtain
In this tutorial, I will discuss Power BI datasets, including data types and the importance of naming conventions. The data used in this example is a resource pack made available for Enterprise DNA members. We want to make sure that when we import this Excel data into our Power BI model, we get an error-free
