Nonprofit & Education

Catalyze Challenge: One Impact Dashboard for Six Grant Rounds

A Tableau impact dashboard that gives Catalyze Challenge one trusted, funder-ready view across six grant rounds — 68 grantees, 63,585 learners and $17.9M in grant investment.

Catalyze Challenge funds career-connected learning programs that help young people explore careers, gain work experience and earn credentials. With grantees reporting across national and regional funding rounds, the team needed one trusted view of impact to share with funders and partners. We built it in Tableau.

At a glance

Client
Catalyze Challenge (career-connected learning grant program)
Tools
Tableau, Airtable, Google Sheets, Excel
Scope
Data modeling, metric design, internal and funder-facing dashboards
6
Funding rounds
68
Grantees
41
States
63,585
Learners tracked
$17.9M
Grant investment tracked
$52.9M
Public & private funding leveraged

The challenge

Grantee results arrived in different shapes for each round. Some metrics were counts, some were percentages, and many were broken out by middle school, high school and post-secondary learners. Data moved from Airtable to Google Sheets to Excel before anyone could chart it, so every report meant manual rework. Catalyze needed numbers it could put in front of funders with confidence, plus an internal view with more detail for its own team.

Our approach

  • One metric model. We restructured every indicator into a single table: category, metric, round, school level, numerator and denominator. Adding a new round means adding rows, not rebuilding charts.
  • Percentages that add up. Rates are calculated from summed numerators and denominators, never by averaging percentages, so totals stay correct when users combine rounds.
  • Two audiences, one source. We built matching internal and external versions of the Overview and Impact dashboards from the same data, so funder-facing numbers always match what the team sees internally.
  • Built for exploration. A round selector switches between Birmingham regional rounds and national rounds 1–4, with a state coverage map, learner breakdowns by school level and rural/urban reach.

What the dashboard shows

The Overview dashboard gives funders the headline view: total investment, funding leveraged, grantees, states served and learners reached, along with the share of learners from low-income (70%) and historically underserved groups (74%), and the share of programs still active after their grant ended (83%).

The Impact dashboard follows learners through the program:

  • 81% of tracked learners completed their program
  • 93% completed the career exploration experiences they started
  • 85% completed work-based learning such as internships and apprenticeships
  • 98% of learners in credential programs earned college credits, industry-recognized certificates or degrees
  • 345 employer partners and 85 education partners worked with grantees
  • In learner surveys, 83% said there are people in their lives who help them succeed and 77% said they learned skills that will help their careers

The result

Catalyze now reports impact from one dashboard instead of rebuilding spreadsheets for each funder update, and the same numbers appear in every internal and external view. In Phase II, we are moving the data source to Airtable as the single source of truth, removing the manual Google Sheets and Excel steps between data entry and dashboard.

Need something similar?

If your program reports outcomes to funders, boards or agencies, we can build the same kind of single, trusted impact view.

Start the conversation

Want results like these for your team?

Book a Free Assessment

We use cookies for analytics to improve your experience. We only track you if you accept. See our Privacy Policy.