​

In this article, we discuss another core concept; that of granularity. In doing so, we'll cover: Definition of Granularity Why you should (almost always) work at the atomic level Why more Foreign Keys results in more rows Sparsity in the fact table Definition of Granularity Granularity relates to the level of detail in the fact table. It can be explained in: Business terms, i.e., Sales is explainable by Date, Product, Department, Geography, Customer, General Ledger (GL) and

Keys are a core component of star schema modelling; relationships between tables are built using the keys. This article covers: The main...

Like the Functional Requirements, the Non-Functional Requirements (NFRs) - how Power BI operates - are of critical importance. This article covers: Why you need to understand Functional and Non-Functional Requirements from the outset Generic modelling rules NFRs: Performance, Scalability, Security, Maintainability, Reliability, Extendibility and Recovery Why you need to understand Functional and Non-Functional Requirements from the outset Understanding Functional and Non-Fun

Referential integrity is a common problem encountered when data modelling which can impact understandability, performance, reliability,...

Star Schema is the "go to" modelling approach used in Power BI. This article covers: 1) What is a Star Schema 2) Bus Matrix and Star...

The same measure can be explained by a single dimension in different ways. For instance, when goods are shipped between countries,...

Imagine you’re faced with millions (or even billions) of journal entries, and someone asks, “Why did we miss our budget?” Where do you...

Calculating each line on a Profit & Loss (P&L) statement separately with DAX in Power BI is not considered best practice for several...

A common source of frustration is that totals in business intelligence (BI) don't add up. In the above example, we've drilled down from...

Now that we have the inputs ready, there are four key steps to build the solution: Power Query Modelling DAX Visualization Let's dive...

Understanding the Components of a Sankey Diagram When working with a Sankey diagram, there are four key measure components to understand:...

Level Sorting From To Colour Code Justification 1 1 B2B revenue Revenue 1 left 1 2 B2C and other revenue Revenue 1 left 2 1 Revenue Gross...

In this blog post, we cover: Layout - 5 steps to understand how the Sankey chart is structured Actuals and comparisons - understanding...

When communicating profitability to those who aren't accustomed to looking at financial data, I believe the 𝐬𝐚𝐧𝐤𝐞𝐲 𝐝𝐢𝐚𝐠𝐫𝐚𝐦...

Typically finance teams want to know the posting date in relation to the fiscal period close, that is, postings: Between 1 and 3 days...

Disclaimer! This blog post contains my thoughts surrounding using prime numbers for performance optimisation. I am not advocating you do...

Mixed Grain Fact Tables Granularity is determined by the number of foreign keys in the fact table. For instance, the grain of your...

Statement of Cash flows With the Statement of Comprehensive Income (SOCI) and Statement of Financial Position (SOFP) there are no...

The first part of this series examined the TRANSACTIONAL fact table as the optimal solution for Statement of Comprehensive Income (SOCI)....

How the Kimball methodology aligns with Power BI for the Statement of Comprehensive Income