Chris BarberSankey Diagram: the four measure componentsUnderstanding the Components of a Sankey Diagram When working with a Sankey diagram, there are four key measure components to understand:...
Chris BarberSankey Diagram: Completing the dimension and fact input tablesLevel 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...
Chris BarberSankey Diagram: requirements gatheringIn this blog post, we cover: Layout - 5 steps to understand how the Sankey chart is structured Actuals and comparisons - understanding...
Chris BarberSankey Diagram: why it's an effective way to visualise the P&LWhen communicating profitability to those who aren't accustomed to looking at financial data, I believe the 𝐬𝐚𝐧𝐤𝐞𝐲 𝐝𝐢𝐚𝐠𝐫𝐚𝐦...
Chris BarberHow to model posting date when producing income statement semantic modelsTypically finance teams want to know the posting date in relation to the fiscal period close, that is, postings: Between 1 and 3 days...
Chris BarberUsing 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...
Chris BarberUsing your Organisational Hierarchy as the basis for report securityHow using the organisational hierarchy to set security rules saves time & creates a more maintainable, scalable and transparent solution