Finance KPI Tracker – Project Details

CompanyDeloitte
RoleBusiness Intelligence Developer
Duration4 Weeks
Skill LevelIntermediate to Advanced
Tools UsedPower BI, Excel, SQL
DeliverablesKPI dashboard, financial reports, drill-down analytics
Objective

Build a finance-focused KPI dashboard to help Deloitte's internal finance team monitor profitability, expense ratios, cash flow, and revenue forecasts in real time. The dashboard aggregates data from multiple financial systems and supports drill-downs across departments, months, and cost centers. Designed for CFO-level clarity, the visualization supports strategic decisions and compliance tracking.

Key Challenges
  • Aligning inconsistent finance metrics across departments
  • Ensuring accurate forecasting models
  • Creating audit-friendly financial views
Features
  • Monthly expense breakdown and variance analysis
  • Real-time KPIs for ROI, net profit, and operating margin
  • Filterable by business unit and fiscal year
Outcome

Streamlined financial reporting with a centralized KPI system, improving forecast accuracy by 30% and audit readiness.