This project presents an Executive Financial Performance Dashboard built in Power BI to support FP&A decision-making across revenue performance, budgeting, variance analysis, cash flow monitoring, and rolling forecasts.
The dashboard simulates a real-world corporate finance environment where leadership requires monthly visibility into financial drivers, cost behavior, and forecast trends to support capital allocation and profitability decisions.
The primary objective of this dashboard is to:
- Monitor Revenue vs Budget performance
- Track OPEX trends and cost discipline
- Analyze monthly revenue variance drivers
- Evaluate liquidity through net cash flow monitoring
- Implement rolling 3-month revenue forecasting
- Provide executive-ready financial reporting visuals
This project mirrors a typical FP&A reporting workflow used in corporate finance teams.
- Revenue
- Budget Revenue
- Revenue Variance ($ and %)
- OPEX
- EBITDA
- Net Cash Flow
- Rolling 3-Month Revenue
Provides a high-level financial summary for leadership review:
- KPI Cards (Revenue, OPEX, EBITDA, Variance %)
- OPEX Trend Analysis
- Revenue vs Budget Comparison
Focused monthly variance breakdown to identify drivers of over/underperformance relative to budget:
- Waterfall chart highlighting positive and negative monthly impacts
- Revenue, Budget Revenue, and Variance % summary
Liquidity monitoring and forward-looking analysis:
- Net Cash Flow Trend
- Rolling 3-Month Revenue Forecast
- Financial sustainability assessment
- Separate Actuals and Budget tables
- Dedicated Date table for proper time intelligence
- One-to-many relationships for clean filtering
- Organized measure table for KPI management
- Revenue & Budget aggregation
- Variance ($ and %)
- EBITDA calculation
- Net Cash Flow computation
- Rolling 3-Month Revenue using
DATESINPERIOD
Example:
Rolling 3M Revenue =
CALCULATE(
[Revenue],
DATESINPERIOD('Date'[Date], MAX('Date'[Date]), -3, MONTH)
)
- Power BI (DAX, Data Modeling, Visualization)
- Microsoft Excel (Structured Financial Dataset)
- Time Intelligence Functions (
DATESINPERIOD,CALCULATE,LOOKUPVALUE) - Financial Modeling Concepts (Budgeting, Forecasting, Variance Analysis)
This dashboard demonstrates hands-on execution of:
- Budget vs Actual monitoring
- Monthly variance analysis
- Rolling forecast modeling
- Cash flow visibility and liquidity assessment
- Executive MIS reporting design
- Structured financial data modeling
The structure reflects practical corporate FP&A reporting workflows used in insurance, lending, and technology environments.