Tag: Fact Tables

Data Model For Power BI Retail Sites Dashboards

Data Model For Power BI Retail Site Dashboards

In this tutorial, you’ll learn about developing a data model for Power BI Retail Sites Dashboards. The methods discussed will help you harvest valuable insights easily from your report. From start to finish, you’ll see how amazing DAX formulas are in calculating and filtering results for you to harvest and gather. Arranging The Data Tables

Continue reading

Calculated Columns Power BI: Tips & Best Practices

Best Practices When Using Calculated Columns In Power BI

This tutorial will discuss the best practices in using calculated columns in Power BI. We’ll also be going through the DAX formulas used to create them. In previous discussions, we’ve gone through how to write different measures in Power BI, but another technique we can use is to create calculated columns. Other than measures, using

Continue reading

Building Your Data Model Relationships In Power BI

Building Your Data Model Relationships

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

Continue reading

What Are The Different Data Table Types In Power BI?

What Are The Different Data Table Types

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

Continue reading

Power BI Calculated Column vs Measure: A Comparison

In this blog, I’m going to compare Power BI calculated column and measures, and then cover some of their differences. I’m also going to show you optimal situations where you can use either of them. Creating Calculated Columns I’m going to start by creating a calculated column in Power BI. This is probably what you’re

Continue reading