Using Many to Many for Financial Reporting

1) For multiple Reports and Report Variations As discussed in a previous blog article, simple Profit and Loss may assume a single reportinghierarchy rolling up account numbers into a reporting line and heading.As this starts to break down we may have a Many to Many mapping between Account Codes and Reporting Lines. Like below, and … Continue reading Using Many to Many for Financial Reporting

Financial Modelling in PowerBI – Downloads

For my session in SQL bits on Financial Modelling in PowerBI there are couple of useful downloads if you want to follow or dissect at home.1) AdventureWorksDW2017This data warehouse has an albeit basic data warehouse version of an accounting table and Account Dimension, so good to use as a demo and starting point.https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2017.bak 2) PowerBI … Continue reading Financial Modelling in PowerBI – Downloads