A non-profit Medicare and Medicaid mental health claims provider envisioned optimized operational dashboards with updated KPIs and visualizations. The system comprised of user scorecards, claims processing reports, and provider and subscriber metrics. They sought to put in place a DWH solution that consolidated the data from multiple sources and standardized them into a customer data warehouse. The governance and access regulations were expected to be HIPAA-compliant.
The DWH system required real-time integration with multiple source systems. The data input came from varied sources and in different formats, including printed paper forms. Acquiring data from these sources and digitizing paper forms was one of the primary objectives of this initiative.