Search Results for: data model

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

Data Modelling In Power BI: Tips & Best Practices

Data Modelling In Power BI: Tips & Best Practices

In this tutorial, you’ll learn valuable tips and best practices for data modelling in Power BI. You can watch the full video of this tutorial at the bottom of this blog. This is one of the four pillars of Power BI report development and is a proven method to develop reports with ease. Honing in

Continue reading