Chris Barber2 minPercentages and Integers in the same measureHow to create Percentages and Integers in the same measure within Power BI
Chris Barber3 minDeviating from Star Schema PrinciplesA finance user case The Star Schema methodology is the application of dimensional modelling techniques to a relational database. This...
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