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...
top of page
Chris Barber
3 min
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...
216
Chris Barber
3 min
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...
506
Chris Barber
3 min
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...
455
Chris Barber
4 min
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)....
672
Chris Barber
4 min
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,483
Chris Barber
1 min
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
393
Chris Barber
2 min
The 3 things you need to get started with Financial Statements in Power BI
Getting started with Power BI and the Financial Statements
4,431
bottom of page