- Customer Stories
- /
- Centralized Data Infrastructure and Automated Reporting System
Centralized Data Infrastructure and Automated Reporting System
Fully centralized enterprise data warehouse.
Faster reporting cycles
Employee hours saved annually
Reduction in invoice/payment delays
Modernized data infrastructure and automated reporting that let end-users access and interact with data insights efficiently.
Fragmented financial and clinical data slowed down NHCA, a post-acute healthcare network operating across 6 US states. Reports were manually compiled from legacy systems, spreadsheets, and ad hoc file submissions, leading to human errors, slow turnaround, and zero real-time visibility.
Solution
Blackthorn AI delivered a fully centralized enterprise data warehouse, modernized ETL pipelines, and built a robust layer of automated reporting and secure data input interfaces.
To deliver a fully centralized enterprise data warehouse, modernized ETL pipelines, and built a robust layer of automated reporting, Blackthorn AI applied:
Project duration
01-08 Weeks
Developed 6 interconnected databases with OLAP cubes and data marts to consolidate healthcare and finance data from multiple departments into a secure, scalable Jet-based enterprise data warehouse.
08-18 Weeks
Migrated ~65 data pipelines from Talend to SSIS, redesigned ETL logic, eliminated file-based sources, and automated data loading into SQL Server to ensure consistency and scalability.
18-34 Weeks
Created 38 stakeholder-specific dashboards to visualize patient outcomes, finance metrics, and operational KPIs — providing real-time, self-service access to actionable insights.
34-46 Weeks
Built 27 Excel-integrated Jet Reports on top of the unified data warehouse to generate monthly, quarterly, and annual financial statements automatically, eliminating manual work and errors.
46-55 Weeks
Implemented 13 secure, SQL-integrated web forms to replace legacy file-sharing workflows — enabling users to input, review, and route financial and clinical data directly into the system.
Team Size
Delivering Impact
Beyond the values already highlighted, there’s even more to discover. Our commitment to innovation, client success, and impactful results sets us apart
1,000+
Employee hours saved annuallyThrough automation of ETL processes, reporting, and data entry — freeing up the internal ops team for strategic work.
45%
Reduction in invoice/payment delaysBetter visibility into schedules and centralized templates helped address broken invoice cycles.
50%
Faster reporting cyclesAutomated reporting pipelines cut monthly financial and operational report delivery times by half — enabling faster insights and decision-making.
65+
Legacy pipelines migratedRebuilt and optimized 65+ Talend pipelines into SQL Server Integration Services (SSIS), ensuring high data quality and scalability.
90%
Reduction in human errorsReplacing manual Excel workflows and legacy Talend scripts with automated data pipelines and input web forms drastically reduced data-entry mistakes.
