📊 FFH Intelligent Health Hub Dashboard · Flagship Case Study

One dashboard. Every audience.
Grant-ready from a single source of truth.

The Force for Health built the Sickle Cell Foundation of Arizona a reporting system that tells the same true story three different ways, to the Board, to grant funders, and to the public, from one file. Change one number and every view updates. No spreadsheets, no version drift, no PHI.

FFH
Built byThe Force for Health
×
SCFA
Delivered forSickle Cell Foundation of AZ
See how it works → What we can use it for
+41%Form 10 services, year over year
88%demographic completeness (up from 45%)
3audience views, one data source
~$5Ksaved per year vs. manual reporting
0PHI, aggregate & de-identified only
The Challenge

Three audiences, three sets of numbers, one exhausted team.

SCFA runs on a federal HRSA grant (D1JMC42462). Every year the same impact data has to be re-shaped by hand for very different readers, and every hand-built version is a chance for the numbers to drift apart.

  • 1
    Different story for every reader. The board wants candor and data-quality gaps. Funders want clean Form 10 compliance. The public wants a proud impact number. One spreadsheet cannot be all three.
  • 2
    Manual, every cycle. Re-keying HRSA Form 10, demographics, and service units into slides and PDFs each reporting period, hours of work that produced numbers no one could easily re-verify.
  • 3
    No single source of truth. When a figure changed, someone had to remember every place it lived. Board deck, funder report, and website could quietly disagree.
  • 4
    Compliance risk. Grant reporting has to tie out exactly and must never expose patient identifiers. Hand assembly puts both at risk.
“Walk into a grant renewal with clean, defensible numbers, and let the public see the impact story at the same time.”
The brief, in one sentence.
The Solution

One data file. Four audience-gated views.

Everything reads from a single source of truth. Each view shows exactly what its audience should see and hides what it should not. Edit one number in the data file and the board view, the funder report, and the public page all update together.

🗃

Single source of truth

scfa-multi-year.js

Every KPI, Form 10 row, demographic, and service unit lives here once. Sums are reconciled and tie out.

🔐 Internal / Board
SCFA Board & exec team
Full visibility, including data-quality watch and improvement targets. A built-in toggle previews the funder and public views without leaving the page.
Sees everything
🏛 Funder
AZDHS & grant funders
The grant-report view. Full Form 10 performance and demographics, with internal improvement targets hidden so a work-in-progress metric never reads as a shortfall.
Hides data-quality watch
🌎 Public
Donors, website, prospects
Polished impact numbers only. Data-quality detail, age cross-tabs, and the internal roadmap are all hidden. This is the donor-facing story.
Impact numbers only
📄 Next-cycle template
SCFA team
A zero-state copy of the internal view so the team can see exactly which fields the next reporting cycle needs to fill. No template surgery required.
Ready to fill
Under The Hood

The features that make it grant-grade.

This is not a slide with charts pasted in. It is a live, interactive reporting system engineered to match the grant proposal section for section, and to hold up under a funder's scrutiny.

🎭

Audience-gated views

Internal, funder, and public read from the same data. Show-and-hide logic is set per audience, so the right people see the right level of candor, automatically.

Live
🔄

Single source of truth

One flat data file drives every page and every chart. Change a number once and it propagates everywhere, no more hunting for the other copies.

Live
📋

HRSA Form 10 aligned

Sections A through G mirror the SCFA proposal's reporting requirements: headline KPIs, Form 10 performance measures, demographics, telehealth, and full service-unit detail.

Live
📈

Multi-year, year-over-year

Two official HRSA years are loaded (2023-24 and 2024-25) with a built-in compare, so growth is shown, not just claimed.

Live
👥

De-identified demographics

Age, ethnicity, and insurance breakdowns plus cross-tabs, all aggregate. Every cross-tab reconciles to the same client total.

Live
✅

Numbers that tie out

Age, ethnicity, insurance, Form 10, and service units are all reconciled to their grand totals at build time. Defensible in a renewal review.

Live
🔒

Compliant by design

Zero PHI at this layer, aggregate de-identified data only. MIT-licensed, source owned by SCFA, and built on MIT-compatible dependencies only.

Live
🧩

Embed & gate anywhere

Drops into the WordPress site by iframe, static page, or plugin shortcode, with per-page access gating so board views stay board-only.

Live
⚡

Live-data ready

The data file is built to swap for a live feed: the SCFA Activity Tracker, website and app analytics, and 360 SCD Hub engagement, with no rendering changes.

Phase 2
The Results

Growth you can show a funder.

Two official HRSA reporting years, reconciled to the filings of record, driving three audience views and a year-over-year compare.

6,672Form 10 services, 2024-25
2official HRSA years loaded
88%demographic completeness, up from 45%
~$5Kprojected annual savings vs. manual reporting

Form 10 services delivered

Official HRSA reporting years
4,743
2023-24
6,672
2024-25
▲ +41% year over year
How We Delivered

A phased build, mapped to the contract.

The Dashboard Development engagement runs on a 100-day timeline with three payment gates, each tied to a clear deliverable and a director's note so leadership always knows where things stand.

1
✓ Delivered

Foundation & Prototype

Days 1-50 · 50% activation
  • Data audit & spreadsheet cleanup
  • Executive Dashboard v1
  • Public Impact Dashboard v1
  • Leadership review & refinement
3
○ Pending

Delivery, Training & Approval

By day 100 · final 25%
  • Training & documentation
  • Final production deploy + demo
  • Unified real-time reporting
  • Grant-ready data, ~$5K/yr saved
Ownership built in. The engagement is grant-compliant end to end: SCFA owns the source code on GitHub, only MIT-compatible dependencies are used, and no patient identifiers ever touch this layer. When it is done, SCFA owns a self-maintaining reporting system, not a document that goes stale the day it ships.
What We Can Use It For

This is a repeatable FFH product, not a one-off.

The engine behind the SCFA dashboard, one reconciled data source feeding brand-gated audience views, is exactly the Intelligent Health Hub Dashboard in the FFH white-label program. Any organization that has to report the same numbers to more than one audience can run on it.

🏛

Grant-funded nonprofits

HRSA, CDC, NIH, and state DHS grantees who need clean renewal reporting and a public impact story from the same data.

🤝

Chambers & Community Directors

Chamber of Health directors reporting community impact up to partners and out to the neighborhoods they serve.

🏛

Commissions & public bodies

Boards and commissions with public-accountability duties that must publish transparent, defensible numbers on a schedule.

🏥

Health systems & population health

Program-level impact dashboards that fit the FFH $1-per-head population-health model, board view and community view in one.

🏦

Foundations & funders

Grantmakers who want a consistent, comparable impact view across a whole portfolio of funded partners.

📱

Any multi-audience reporter

If a team is rebuilding the same numbers for board, funder, and public by hand, this replaces that work with one system.

Package it as a white-label Intelligent Health Hub Dashboard

Stand up a branded instance for a partner in the same phased model we used for SCFA: their logo, their colors, their domain, their audience views.

  • Custom brand & domain per partner, their own audience-gated views
  • Same phased delivery we proved with SCFA, foundation, live data, training
  • Network roll-up: anonymized aggregate impact flows to the FFH Network layer
  • Portfolio story for funders and investors from real, cross-partner reach
Proven starting point
$8,000
SCFA Dashboard Development engagement, 100-day phased build.
Reuse leverage
Weeks, not months
The engine, section templates, and compliance framework already exist. New partners re-skin and re-point the data.

Want this reporting system for your organization?

We can brief your board on the live SCFA dashboard, then scope a branded instance for your own numbers. Learn it, live it, share it.

Open the SCFA Command Center → Talk to The Force for Health