Search Results for: data model

Data Modeling Techniques To Organize DAX Measures

As you progress in Power BI, you will gradually be working with more DAX measures and calculations, and things can easily get cluttered. For today’s tutorial, I will share a few data modeling techniques on how to organize your DAX measures better for a more efficient workflow. You can watch the full video of this tutorial at

Continue reading

Data Modeling In Power BI Using Supporting Tables

Data Modelling Supporting Tables

When doing an analysis on our model, we might want to find an insight that’s unrelated to anything within our tables. That’s where the concept of using supporting tables for Power BI data modeling comes in. Supporting tables don’t have any relationship with our tables, but we can use them to support the visualizations in

Continue reading

Power BI What If Parameter For Data Models

Scenario tables 'what if' parameters

This article will briefly talk about integrating scenarios into our models. We can do that by using the Power BI  What If Parameter feature. We can add this parameter to our reports as slicers or reference them on DAX expressions. Integrating a What If Parameter into our reports enables us to create scenarios or predictive

Continue reading

Power Query Best Practices For Your Data Model

BEST PRACTICES FOR DATA MODEL

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

Continue reading

Power BI Data Model: A Comprehensive Overview

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

Continue reading