For financial reporting, can we use the Chart of Accounts as a hierarchy for all our reporting needs ? The short answer is: In the ideal world - Yes. In the not ideal world – No. The Chart of Accounts provides us with a way to categorise Account Codes (aka GL Codes) into an account name and … Continue reading Why Chart of Accounts doesn’t work for Financial Reporting
Tag: Power BI
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