How to design a women founder funding reporting dashboard

A women founder funding reporting dashboard should expose decisions and problems, not compress a complicated founder journey into a success counter. Design it from agreed questions, definitions and actions before choosing charts.

What to take away

Set the dashboard scope

State service, reporting period, geography, finance routes, cohort rules and data refresh. Add a visible note when records are provisional. Keep operational monitoring apart from evaluated impact.

Assign a data owner and a decision owner to each section. The first maintains quality; the second must act when a threshold changes. A chart with neither owner is decoration.

Use a journey structure

Create a funnel with unique people or businesses at enquiry, assessed, eligible, started, submitted, offered, accepted and funded. Show movement and outstanding cases, with one consistent unit per chart.

Beside the funnel, display median and upper-tail response times, founder hours, source errors, corrections, accessibility support, complaints and abandonment reasons. Volume without service quality can reward overloading the intake.

The Government Digital Service's performance guidance illustrates why completion and satisfaction need defined attempts and responses. A private funding operator should document its own formulas and avoid implying government endorsement.

Report money carefully

Separate amount sought, offered, accepted and received. Segment by grant, debt and equity because their costs and obligations differ. For debt, retain borrower and repayment context; for equity, keep ownership consequences outside a cash total.

Present approval as a fraction with numerator and denominator on the screen. Add unresolved, withdrawn and missing records. Never choose a denominator merely because it produces a better percentage.

Add outcomes and uncertainty

Show baseline, follow-up window and response coverage for revenue, margin, jobs, product or follow-on-finance measures. Mark forecasts, self-reports, administrative records and independently verified values differently.

The Magenta Book, HM Treasury's guidance on evaluation, explains that process, impact and value for money answer separate questions. Label dashboard changes as observed outcomes until an appropriate design supports attribution.

Protect founders

Suppress or combine small groups where disclosure is plausible. Limit access to row-level demographic and financial data. Do not add sensitive characteristics because they might produce an interesting filter.

Test exported tables as well as the screen. A safe chart can reveal identities through its download. Record role permissions, retention and approved recipients.

Processing applicant data needs a lawful basis under the UK GDPR, and the Information Commissioner's Office is the regulator to follow for retention, individual rights and breach handling. Complete a data protection impact assessment before widening the data you collect.

Run the review meeting

Open with data quality, then service harm, access, finance progress and outcomes. Record decisions, owners and due dates in a separate action log. Freeze period-end numbers and explain later revisions.

Publish only a reviewed extract with method, limitations and contact for correction. This draft needs data-protection, statistical and evaluation approval.

Reconcile before release

At period end, compare funnel totals with the case register, finance records and provider receipts. Investigate duplicate companies, reopened cases, applications spanning periods and money offered but never drawn. Keep a reconciliation note for every manual adjustment.

Test chart labels with a reader who did not build the dashboard. They should be able to identify the unit, time period, location, definition and denominator without opening the database. Replace vague labels such as success or women-led with the exact measured stage and approved definition.

Run access checks using each reporting role. A sponsor may need programme totals but not applicant rows; a case worker may need their open records but not optional research responses. Attempt exports and shared links as well as on-screen navigation.

Create a publication checklist for source refresh, suppression, sample size, rounding, conflicts, version and approval. Where figures are corrected later, preserve the original release date, state the reason and show the affected value.

Archive the dashboard extract with its dictionary, query or formula version and source snapshot. A future reviewer must be able to reproduce the reported number even after live records change.

Before you act

Common questions

What should a dashboard show beside the funding funnel?

Beside the funnel, display median and upper-tail response times, founder hours, source errors, corrections, accessibility support, complaints and abandonment reasons. Volume without service quality can reward overloading the intake, so service quality measures matter alongside movement and outstanding cases.

How should approval rates be presented?

Present approval as a fraction with numerator and denominator on the screen. Add unresolved, withdrawn and missing records. Never choose a denominator merely because it produces a better percentage, and document your own formulas rather than implying government endorsement.

What must happen before the dashboard is released?

At period end, compare funnel totals with the case register, finance records and provider receipts. Investigate duplicate companies, reopened cases, applications spanning periods and money offered but never drawn. Keep a reconciliation note for every manual adjustment, and obtain data-protection, statistical and evaluation approval.