From Data to Dashboards in a Week

Most charity dashboards die in the first month. Either they were too ambitious to maintain, or too thin to be useful, or they were built once and never connected to a decision. The trick is not building a fancier dashboard. It is building a smaller one, then putting it in the path of an actual decision.

What follows is a five-day process, repeatable on most small charities, that produces a dashboard the senior team will open weekly. It does not need a BI specialist, a data warehouse, or new licences. It needs one named owner and one hour a day for a week.

The five days

Day 1 - Define the questions

Before any data, before any tool, sit with the senior team for 60 minutes. The only question on the agenda: "What questions do you want answered every Monday morning?"

You are looking for 6–10 questions, each of which has a single number as the answer. Examples that work:

• How much did we raise last week, against the same week last year?
• How many new monthly donors started this month?
• How many beneficiaries did we serve last week, by programme?
• What is our 30-day email open rate trend?
• How many active risks are tagged red on the register?

Examples that don't work (yet):

• "How are we doing?" - too broad.
• "What is the predicted retention curve for our new monthly giving cohort?" - too sophisticated for week one.
• "What's the donor lifetime value?" - almost certainly noise without 24 months of data.

Pick the 6–10 questions that, if answered weekly, would change someone's decision. Write them down.

Day 2 - Locate the data

For each question, identify exactly where the answer lives. Not "in the CRM" - the specific table, the specific filter, the specific export. By the end of the day, every question has a documented data source.

Most of the time, this exposes one or two questions that cannot be answered today. That is useful. Either redefine them, or accept that question moves to "phase 2." Do not stall the dashboard waiting for the perfect data; ship 6 questions instead of 10.

Day 3 - Plumb the pipes

Set up the boring infrastructure. For most small charities, this looks like:

1. A scheduled CRM export (CSV or via a connector) into Google Sheets or similar.
1. A second sheet that pulls in finance system data (often a manual export at first; that's fine).
1. A third sheet that pulls in email and digital metrics (via Mailchimp/HubSpot/Mailerlite's API or a connector tool).
1. One "join" sheet where the data lives in a structured format, ready for visualisation.

You are not building a data warehouse. You are building the smallest piece of infrastructure that lets one dashboard answer 6–10 questions reliably each Monday.

Day 4 - Build the dashboard

Open Looker Studio (free), Tableau Public, or whatever your team can use. One page per audience: the senior team page, and optionally a fundraising-specific page. Resist the urge to build a five-page dashboard with tabs and filters and drill-throughs - week one is one page, scannable in 30 seconds.

Each question gets one chart or one big number. The headline number is what someone will read first; the small chart shows the recent trend. Two visual elements per question, no more.

Three design rules that hold up:

• Numbers, not adjectives. "Up 12%" beats "Strong growth."
• Colour means something. Green / amber / red is a status convention; do not use it for decoration.
• No "explainer" text on the dashboard itself. The dashboard answers; explanations live in a linked one-page document.

Day 5 - Connect it to a decision

A dashboard not connected to a decision is decoration. The way to connect it is to put it in the standing agenda of the senior team meeting. Every Monday, ten minutes: open the dashboard, talk through the trends, name one thing to change in the next 7 days.

That is the entire point. The dashboard is not a deliverable. The Monday decision is the deliverable. The dashboard is the artefact that makes the decision easier.

Three habits that keep it alive

Habit 1: One owner, weekly maintenance

A named person, with 1–2 hours a week, refreshes the data, checks the formulas, and chases the questions that broke. Without that, the dashboard rots inside a quarter.

Habit 2: Quarterly review

Once a quarter, the senior team reviews the questions themselves. Are these still the right ones? Add up to two new ones, retire up to two old ones. The dashboard slowly evolves with the strategy.

Habit 3: A "definitions" doc

Every metric on the dashboard has a written definition: "Active monthly donor = direct debit set up, last collection within 60 days, no cancellation request received." Pin it next to the dashboard. The first time someone disagrees with a number, the definitions doc is what saves you.

Three traps

Trap 1: Vanity metrics

"Followers," "page views," and "subscribers" without context are vanity. They go up, they look impressive, they change no decisions. If you cannot answer "what would I do differently if this number doubled?" the metric is decoration.

Trap 2: Too many filters

A dashboard with 14 filters is a dashboard for someone who knows exactly what they are looking for. Senior teams want answers, not exploration. Build the dashboard for the questions you defined on day one. Anyone who needs deeper analysis can fork the data into their own view.

Trap 3: Tool maximalism

You do not need a data warehouse, a BI platform, and three vendor logins to start. A Google Sheet feeding Looker Studio gets 80% of the value at 5% of the cost. Add complexity only when you have outgrown the simple version, not before.

A 6-question dashboard, opened every Monday, beats a 60-metric dashboard, opened twice. The discipline is what counts, not the tooling.

A short closing

Five days. Six questions. One named owner. A standing 10-minute slot in the Monday senior team meeting. That is the smallest credible version of a charity dashboard, and it is enough to start changing decisions. Build that, run it for a quarter, and only then think about phase 2. The temptation to build the perfect dashboard is what stops most charities from having any working dashboard at all.

Further reading

AI for Charities: What to Use, What to Avoid | The Five-Minute CRM Health Check | Choosing a Charity CRM in 2026