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...
top of page
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...
160 views0 comments
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 𝐬𝐚𝐧𝐤𝐞𝐲 𝐝𝐢𝐚𝐠𝐫𝐚𝐦...
45 views0 comments
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...
26 views0 comments
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...
278 views0 comments
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...
523 views0 comments
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...
471 views0 comments
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)....
682 views0 comments
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,528 views0 comments
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
399 views0 comments
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,491 views0 comments
Anchor 1
bottom of page