Chris Barber3 minKnow your facts Part 4: Power BI, Financial Statements & KimballMixed Grain Fact Tables Granularity is determined by the number of foreign keys in the fact table. For instance, the grain of your...
Chris Barber3 minKnow your facts Part 3: Power BI, Financial Statements & KimballStatement of Cash flows With the Statement of Comprehensive Income (SOCI) and Statement of Financial Position (SOFP) there are no...
Chris Barber4 minKnow your facts Part 2: Power BI, Financial Statements & KimballThe first part of this series examined the TRANSACTIONAL fact table as the optimal solution for Statement of Comprehensive Income (SOCI)....
Chris Barber4 minKnow your facts Part 1: Power BI, Financial Statements & KimballHow the Kimball methodology aligns with Power BI for the Statement of Comprehensive Income
Chris Barber1 minUsing 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
Chris Barber2 minThe 3 things you need to get started with Financial Statements in Power BIGetting started with Power BI and the Financial Statements