Financial Reporting, FP&A & P&L Management Dashboards

Instructor: Alaa Hady · Language: English or Arabic · Suggested duration: 2 days · Level: Intermediate to Advanced (Level 200–300)

Objectives

• Architect a clean Chart of Accounts (CoA) and General Ledger (GL) Star Schema in Power BI that handles hierarchical financial statements.
• Build formatted, asymmetric Income Statements (P&L), Balance Sheets, and Cash Flow views with subtotals, percentages of revenue, and custom row formatting.
• Automate Actual vs. Budget vs. Forecast vs. Prior Year variance bridges (including FX constant-currency isolation).
• Enforce strict financial sign-off, penny reconciliation, and row-level cost-center security.

Outline and contents

1. Why standard Power BI matrices struggle with P&Ls—and how to design a custom Financial Statement Header/Layout table
2. Modelling ERP General Ledger data: Fact GL Transactions, Fact Budget/Forecast snapshots, Dim Chart of Accounts (parent-child hierarchies), Dim Cost Center, and Dim Legal Entity
3. Handling Accounting Sign Conventions (Debit/Credit flip signs vs. natural positive presentation) cleanly in DAX
4. Authoring asymmetric P&L matrices using Calculation Groups, custom layout tables, and Dynamic Format Strings (mixing \ amounts, \%$ margins, and EPS ratios in one column)
5. Building Balance Sheet semi-additive point-in-time balances (LASTDATE, cumulative opening + period movements) and Working Capital KPIs (DSO, DPO, DIO, Cash Conversion Cycle)
6. Multi-currency conversion in DAX: Spot rate vs. Average monthly rate vs. Constant Budget FX rate, and isolating operational variance from FX translation impact
7. Applying IBCS financial storytelling standards: automated Zebra BI / native waterfall bridges for EBITDA and Net Income walk
8. Automating Month-End Close reconciliation checks and deploying cost-center RLS for department budget holders
9. Hands-on Lab: Building an interactive CFO P&L, EBITDA Bridge & Cash Flow Dashboard from raw GL/Chart of Accounts tables

Target audience

Finance teams, FP&A analysts, financial controllers, management accountants, and Finance BI developers.

Expected outcomes

Participants master the exact modelling and DAX techniques required to build boardroom-ready P&L and Balance Sheet reports in Power BI—eliminating days of manual month-end Excel consolidation.