Insight · October 2026
From spreadsheets to governed dashboards
The most common request we receive in the analytics space is "we need to move from Excel to Power BI." It is the wrong request. Power BI is a rendering layer. The capability an institution needs is not "we can build charts" — it is "our steering committee makes different decisions this month than it made last month because the dashboard surfaced something they would otherwise have missed."
That capability has four layers, and a tool migration addresses none of them.
The four capabilities
1. Data governance. Who owns each field, where does it come from, how often is it refreshed, and what is the source of truth when two reports disagree? Without an answer, every dashboard is a contested artefact. With an answer, the dashboard is the meeting's first slide and the conversation moves on.
2. Data modelling. A star schema built once, used by many. Most Excel-to-Power BI migrations recreate the Excel mess inside Power BI — five tabs, three lookup ranges, and a calculation that lives in a single cell nobody can find. The fix is a model with clear fact tables, dimension tables, and measures that are named, documented, and reusable.
3. Visual literacy. The steering committee's ability to read a chart, ask the right follow-up question, and resist the chart that confirms what they already believed. This is a leadership capability, not an analyst one. We have seen perfectly modelled dashboards fail because the committee did not know how to use them.
4. Decision rituals. A standing meeting that opens with the dashboard, not the inbox. Without this, the dashboard is decoration. With it, the dashboard is the institution's nervous system.
What a programme that builds all four looks like
SDI's Spreadsheets to Governed Dashboards programme runs as a five-day cohort followed by a six-week build sprint. In the cohort, participants bring their own dataset and leave with a governed model, a published dashboard, and a one-page data dictionary their colleagues can read. In the build sprint, SDI faculty pair with the in-house team to productionise the dashboard and stand up the decision ritual that uses it.
The artefact at close is not a Power BI file. It is a working dashboard the steering committee opens every Monday morning — and a measurable change in what the committee discusses.
If you are about to buy a BI tool
Pause. Ask whether your institution has the four capabilities above. If any is missing, the tool will not fix it — and the migration will be remembered as the year the dashboards looked better but the decisions did not change.
By SDI Training Faculty · Published 2026-10-03 · Back to insights