A dynamic three-statement dashboard that reads like a CFO wrote it
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.
Interactive — change the fiscal year to see the narrative recompute.
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.