Create a Profiling Report in Power BI: Give the End User Information about the Data

Most of the time, you would like to know how the data quality looks like in your tables. Although, this is a process that you mainly check at the time of data preparation, having such report for end users, is also helpful, because sometimes they see an odd outcome, and wonder where this is coming ...

Read More

Build Your First Star Schema Model in Action: Power BI Modeling Basics

Dimensions and Fact tables are the two essential parts of building a data model, and their relationship in the form of Star Schema is the best practice of doing the modeling. However, these are all theories until you really experience it in a real-world example. In this article, I want to put everything you learned ...

Read More

Power BI Architecture for Multi-Developer Tenant Using Dataflows and Shared Datasets

Using Power BI is simple, however, using it properly, needs a good architecture. In a multi-developer tenant, the architecture of a Power BI implementation should allow multiple developers to work on the same solution at the same time. On the other hand, the Power BI architecture should be designed in a way that different layers ...

Read More

Move Your Shared Tables to Dataflow; Build a Consistent Table in Power BI

I have written previously about the use cases of Dataflow in Power BI, and one of them was using one Power Query table in multiple Power BI reports. However, I that article just covered the surface, and I still see many solutions duplicating Power Query scripts in multiple files which brings a lot of inconsistency ...

Read More

Basics of Modeling in Power BI: What is a Dimension Table and Why Say No to a Single Big Table

I have previously written about relationships and the cardinality of the relationship. Now is a good time to explain the two types of tables we deal with every day in a reporting data model; Fact and Dimension table. In this article, I will explain what a Dimension table is, and examples of it, and how ...

Read More