Tag: Power BI Data Modeling

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 Filtering Techniques For Tables

Power BI Filtering Techniques For Tables

In this blog, we’re going to learn about some essential Power BI filtering techniques for tables. We’ll discuss some simple techniques that we can utilize when we have massive tables on our query.  For example, when we need to extract information from a database or an ERP system, it could have 10 million rows within

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

Reporting Apps Using Power BI For Transport & Shipping

Reporting Apps Using Power BI For Transport & Shipping

In this tutorial, I’d like to demonstrate how you can create logistics reporting apps in Power BI using real-world data. I want to show the extensivity of what you can do in Power BI and its great capabilities. You can watch the full video of this tutorial at the bottom of this blog. We’ll go

Continue reading

Power BI External Tools – Installing Practice Dataset

Power-BI-External-Tools-–-Installing-Practice-Dataset

I want to introduce you to one of the best Power BI external tools that Steven McGuire from the Enterprise DNA forum and I put together to help you with your structured practice. You may watch the full video of this tutorial at the bottom of this blog. I’ve talked a lot about structured practice,

Continue reading