One survey, all results made interactive, delivered in under two weeks
In this case study, we detail how we helped the National Association of Community Health Centers (NACHC) present the findings of its 2026 Food for Health National Assessment in an interactive Power BI dashboard. We delivered it in under two weeks, without overstating what a survey can tell you.
Background to the project
NACHC fielded its Food for Health National Assessment between January and March 2026. In total, 285 health centers responded, a 19% response rate against the 1,512 centers in the 2024 HRSA Uniform Data System (UDS). The assessment records what health centers offer and what they track. It does not measure whether programs work.
NACHC wanted to share the findings in a form that readers could explore themselves. Turning survey data into an interactive report is harder than it looks:
- Multi-select questions. Three questions (initiatives supported, conditions targeted and outcomes tracked) allow several answers, spread across 33 option columns.
- Different bases for each question. Not every center answers every question. The initiative question had 161 responses, conditions 159 and outcomes 158, so a single national denominator would misstate the results.
- Small groups. When responses are split by region, some groups fall into single digits.
- Consistency with the published report. Every percentage had to match NACHC’s national report.
Our strategy
Adaptive & Co built the dashboard in Power BI on a purpose-designed data model. Its aim was that any figure on the page could be traced back to the file it came from. The work came down to five decisions:
- Standardized Fact Architecture
- Dynamic Denominators
- Strict Model Relationships
- Interactive Comparison switcher (A field parameter lets readers swap the grouping between national, location, patient volume and sites operated)
- Embedded Governance & Safeguards
Results at a Glance
- Delivery time: Designed, built and checked in under two weeks
- Dashboard pages: 4: national adoption, programs offered, conditions and outcomes, and regional findings
- Responses covered: 285 health centers
- Model: 7 tables, 3 relationships and 22 measures
- Comparison views: National, location, patient volume and sites operated
- Base transparency: Every published figure shown with its own n
- Traceability: Every figure can be traced back to the source extract
What these numbers mean in practical terms
NACHC now has a dashboard where readers can explore the findings themselves without misreading them. Because each percentage carries its own base, someone looking at a chart can see how many health centers sit behind it. Small groups are flagged rather than hidden.
It also makes the patterns in the data easy to find. Readers can see:
- How widely programs have been adopted. The overview page shows the share of responding health centers offering a Food for Health program, and how that varies by location, patient volume and number of sites.
- Which initiatives are most and least common. Nutrition security programs sit at the top and medically tailored food towards the bottom. Readers can switch the comparison to see whether that holds for urban and rural centers, or for larger and smaller ones.
- Where programs are focused. Conditions targeted and outcomes tracked sit side by side, so readers can see where program focus and measurement line up and where they don’t.
- How adoption differs across the country. The regional table covers all ten HRSA regions, with small bases clearly marked.
Outcomes
In under two weeks, NACHC went from having raw survey results to accessing that data through a published, interactive dashboard that matches its national report and shows readers how many health centers sit behind each and every figure. Getting the data model right at the start, with a consistent structure, a base for every question and safeguards built in, made that pace possible without sacrificing accuracy. The dashboard gives NACHC a trustworthy and accessible way to share what health centers are doing on Food for Health, and a documented foundation that can be maintained and built on in the future.
