Tag: Data Model Power BI

Extract Values From Records And Lists In Power Query

Extract Values From Records And Lists In Power Query

In this blog post, we’ll take a look at how you can extract values from records and lists using Power Query. As you can see, the first column in my table contains records. You can watch the full video of this tutorial at the bottom of this blog. When I click off to the side

Continue reading

Data Model Power BI For Inventory Management

Data Model Power BI For Inventory Management

In this tutorial, you’ll learn how to properly create and set up the data model for inventory management dashboards in Power BI. Before you start working on the DAX formulas and visualizations, make sure to check if your data model is correct. If it isn’t, your DAX formulas aren’t going to work and your visualizations

Continue reading

Power Query Editor: Staging Queries

staging queries using Power Query editor

In this tutorial, we’ll learn about staging queries using Power Query editor. This is a new concept that I’d like to discuss for us to have an understanding of when and where we can use this in the query editor.   Staging queries can be used to configure and expose the data sources parameters to the dimension and fact table queries of the dataset. For Power BI datasets,

Continue reading

How To Use A Measure Table In Power BI

In today’s blog post, I’ll discuss some techniques on how to organize measures using a measure table in Power BI. The best way to organize your measures is to create measure groups or measure tables inside Power BI.  It’s important to learn this technique because you’ll be dealing with hundreds of measures in your analysis.

Continue reading

Building Data Dimensions In Power BI

Build Other Data Dimensions in Power BI

In today’s blog post, I want to discuss how you can build additional data dimensions in Power BI. These dimensions can help you filter your data in different ways. On top of that, these dimensions can help you come up with intuitive visualizations later on. This is also the reason why you need to set

Continue reading