Back to projects
Power BI Project

Executive Financial Dashboard — Power BI

A dynamic three-statement dashboard that reads like a CFO wrote it

Power BI
DAX
Financial Analysis
Data Viz
SVG

Overview

A board-ready executive dashboard covering the full three-statement model — Income Statement, Balance Sheet, Cash Flow — built in Power BI on a star-schema data model across FY2023–FY2025. Unlike a typical KPI dashboard that only shows numbers, this one interprets them: every page opens with a plain-language verdict a CFO could read in ten seconds, and the entire narrative recomputes as the fiscal year changes.

Live Dashboard

Interactive — change the fiscal year to see the narrative recompute.

Dashboard not loading? Your browser may be blocking embedded content.

Key Features

  • Narrative headlines that lead with the problem, written in DAX (e.g. "Behind plan — net income materially below budget") instead of burying it under growth figures.
  • A visual hero number anchoring the landing page — Net Income with budget variance and YoY — for clear reading hierarchy.
  • Driver-and-action insights: instead of "revenue below budget," it reasons from the data to "behind plan on volume, not cost — re-baseline the plan."
  • A "CFO Attention" panel that surfaces the most actionable finding (e.g. rising receivables collection time with cash tied up) as a named, color-coded alert.
  • Custom SVG-based KPI cards rendered as DAX measures for precise layout, typography, and conditional color beyond native visuals.
  • First-year edge-case handling: every year-over-year element degrades gracefully ("no prior year") so the dashboard reads correctly in every fiscal year, not just the demo year.

Technical Highlights

  • Star-schema model with a shared "signal brain" — DAX measures that compute severity once and drive every page's narrative consistently.
  • Fully dynamic across three fiscal years via one slicer; headlines, drivers, alerts, and comparisons all recompute.
  • Built with SWITCH, ISBLANK guards, and variance decomposition; unified 2-decimal precision and design system across all pages.

How I Built It

My first version did what most financial dashboards do — it displayed the numbers cleanly but never said what mattered, why, or what to do about it. It was a scoreboard, not a decision tool. I rebuilt it around one principle: hierarchy and judgment over completeness. Every page now leads with the problem instead of the reassurance; the landing page anchors on one hero number; insights name the driver and the action rather than just stating a variance; and the single most actionable finding is promoted into a named CFO alert. The hardest part was technical — the dataset's first year has no prior year to compare against, so every year-over-year calculation broke there. Rather than hide that year, I built guards into every measure so each comparison degrades gracefully, and the dashboard reads correctly in every fiscal year. Building it taught me that the real work in analytics isn't calculating the numbers — it's deciding which ones matter and making those the loudest thing on the page.

base44
Edit with Base44