Northern Indiana Hispanic Health Coalition
Healthcare
Nonprofit
Northern Indiana Hispanic Health Coalition (NIHHC) is a 20+ year nonprofit dedicated to addressing healthcare information gap for Hispanic communities in Indiana through educational programs and community health initiatives.
Results
reduction in reporting time
72%
Using the automated dashboard, NIHHC is able to deliver quick and reliable data insights for grant reporting, helping them secure an additional $250k grant.
Furthermore, the dashboard enabled NIHHC to visualize their impact to stakeholders, positioning them as a leading healthcare nonprofit organization.
reduction in data entry errors
100%
additional grant awarded to support their infant mortality initiatives
$250k
Challenge – NIHHC
Manual data entry & fragmented systems
Siloed databases with limited integration
No fast way to communicate program impact
Our Solution
Optimized ETL to unify data flow
Built automated dashboards for real-time insights
Reduced manual workload and improved reporting clarity
What We Did
-
Digital Transformation of Data Collection using Microsoft Forms
We fully digitized NIHHC’s existing paper surveys into bilingual Microsoft Forms (Spanish and English). This approach not only simplified data collection, but also optimized staff resource allocation and enhanced data accuracy.
-
Automated ETL Pipeline with Microsoft Power Automate
A fully automated data pipeline was implemented to consolidate and transform data from multiple sources - removing repetitive manual tasks and ensuring clean, up-to-date information flows seamlessly into reporting tools
-
Real-Time Power BI Dashboards
By replacing time-consuming ad hoc reporting with instantaneous visualizations, NIHHC staff now gain immediate access to accurate and report-ready insights. These dashboards not only streamlined program development but also empowered stakeholders with rich, real-time data with just a few clicks.
- Liliana Quintero, Executive Director of NIHHC