The Financial “Star” Schema To build our statements we need: - Chart of Accounts Classifications (3 required tables) - Fact Table 1 (Required), e.g. Sales or Actuals - Fact Table 2 (Optional), e.g. Budget or Forecast - Calendar Dimension (Required) - Other Dimension(s) (Recommended), e.g. Customers, Products, GL Descriptions

I'm capping off the week by leading a course on how to build #FinancialStatements in #Excel with #PowerPivot for CPABC.

💡One of the first things we need to understand is how to properly architect the #DataModel so we have the required fact and dimension tables.

#FinancialModeling #ExcelForFinance