How Akaike slashed $52k in operational costs for NIHHC through data automation
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
Akaike transformed NIHHC’s paper-based workflow into a fully automated data ecosystem. The new dashboard saves the team over 20 hours of manual work weekly, enabling faster, more reliable grant reporting and freeing them to focus on mission-critical initiatives.
Our ongoing partnership is now leveraging this powerful data foundation to measure and enhance the life-saving impact of their new infant mortality intervention.
saved in operational costs
$52k+
reduction in reporting time
72%
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
“Working with Akaike was an incredible journey of thinking out of the box and providing a different perspective. They quickly became an asset to our team, and we're happy to see them grow and use their skills to help provide valuable resources to other organizations.”