Content | Star Schema

Sankey Diagram: Data Modelling, DAX, and Visualisation

Dec 612 min read

Sankey Diagram: Data Modelling, DAX, and Visualisation

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

155 views0 comments

Sankey Diagram: the four measure components

Chris Barber

Nov 292 min read

Sankey Diagram: the four measure components

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

68 views0 comments

Sankey Diagram: Completing the dimension and fact input tables

Chris Barber

Nov 223 min read

Sankey Diagram: Completing the dimension and fact input tables

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...

124 views0 comments

Chris Barber

Nov 152 min read

Sankey Diagram: requirements gathering

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

243 views0 comments

Sankey Diagram: why it's an effective way to visualise the P&L

Chris Barber

Oct 161 min read

Sankey Diagram: why it's an effective way to visualise the P&L

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

76 views0 comments

How to model posting date when producing income statement semantic models

Chris Barber

Oct 71 min read

How to model posting date when producing income statement semantic models

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

31 views0 comments

Using prime numbers for performance optimisation (technical article)

Chris Barber

Sep 303 min read

Using prime numbers for performance optimisation (technical article)

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

286 views0 comments

Know your facts Part 4: Power BI, Financial Statements & Kimball

Chris Barber

Apr 25, 20223 min read

Know your facts Part 4: Power BI, Financial Statements & Kimball

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

529 views0 comments

Know your facts Part 3: Power BI, Financial Statements & Kimball

Chris Barber

Apr 8, 20223 min read

Know your facts Part 3: Power BI, Financial Statements & Kimball

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

473 views0 comments

Know your facts Part 2: Power BI, Financial Statements & Kimball

Chris Barber

Mar 25, 20224 min read

Know your facts Part 2: Power BI, Financial Statements & Kimball

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

686 views0 comments

Know your facts Part 1: Power BI, Financial Statements & Kimball

Chris Barber

Mar 10, 20224 min read

Know your facts Part 1: Power BI, Financial Statements & Kimball

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

1,551 views0 comments

Using your Organisational Hierarchy as the basis for report security

Chris Barber

Feb 25, 20221 min read

Using your Organisational Hierarchy as the basis for report security

How using the organisational hierarchy to set security rules saves time & creates a more maintainable, scalable and transparent solution

400 views0 comments

The 3 things you need to get started with Financial Statements in Power BI

Chris Barber

Feb 10, 20222 min read

The 3 things you need to get started with Financial Statements in Power BI

Getting started with Power BI and the Financial Statements

4,522 views0 comments

Anchor 1