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.
https://events.sqlbits.com/2023/agenda
-
Updated 12/03/2023 PowerBI PBIX with P&L, Balance Sheet and Cash Flow from AdventureWorks https://github.com/ProdataSQL/FinancialModelling/blob/main/downloads/03.%20Financial%20Reports.pbix
-
AdventureWorksDW2017 This 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 -
PowerBI Report using “Parent Child” Chart of Accounts https://github.com/ProdataSQL/FinancialModelling/blob/main/downloads/Archive/01_P%26L_ParentChild.pbix
-
Sample Files to import into PowerBI with General Ledger and Transactions https://github.com/ProdataSQL/FinancialModelling/tree/main/downloads/Files
-
Sample Business Rules spreadsheet for mapping GL Codes to reports https://github.com/ProdataSQL/FinancialModelling/blob/main/downloads/Archive/glRules.xlsx
Feel free to download. I've already had people confirm thye got this desing pattern working on a good few popular ERPs like SAP, M3, Dyanmics