Content | Star Schema

Percentages and Integers in the same measure

How to create Percentages and Integers in the same measure within Power BI

Deviating from Star Schema Principles

A finance user case The Star Schema methodology is the application of dimensional modelling techniques to a relational database. This...

1,535 views4 comments

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...

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...

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)....

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,064 views0 comments

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

The 3 things you need to get started with Financial Statements in Power BI

Getting started with Power BI and the Financial Statements

3,537 views0 comments

Anchor 1