Data Warehouse

Store rich claims and clinical datasets in a simplified model that can be easily accessed and queried. Claims & clinical data marts with a simplified, analytics-focused data structure. Direct, database-level access for ad-hoc analytics and integrations.

EXAMPLE IMPLEMENTATION

Wherever possible, Arcadia prefers to source the bulk of the clinical information directly from the EHR/HIS. Other data can be loaded from file-based feeds or separate transactional data stores (e.g., ADT store).

Platform_Technology_DataConnect_Architecture

DATA SOURCES

Platform_Technology_DataWarehouse_Sources

ROBUST ANALYTICAL CAPABILITIES

The Arcadia Analytics data warehouse includes location hierarchies and additional data filters to ensure robust analysis capabilities, either via the web platform or third-party business intelligence tools.

Location Hierarchy Example

  • NORTHWEST ALLIANCE ACO [NETWORK]
  • CHICAGO HOPE [POD]
  • NORTHEND CLINIC [LOCATION]
  • CARDIOLOGY [DEPT]
  • SMITH, JOHN MD [PROVIDER]

Additional Filters and Aggregation Tiers

  • Date/Period – Week, Month, Quarter, Year
  • Primary Care Provider – Multiple Attribution Methods
  • Payer/Product – From EHR/PMS & Plan Eligibility
  • Patient Age
  • Primary Language
  • Race/Ethnicity
  • Chronic Conditions – Assessments, Problems & Claims
  • PMPM Cost
  • Risk Score – Derived or consumed by 3rd party
  • MDC/DRG – For inpatient service groupings
  • Provider Network In/Out – For leakage analysis
  • Service Provider Specialty
  • Place of Service
  • Service Facilities – hierarchical as described to left
  • Primary Diagnosis – Hierarchical w/ ICD code structures
  • Primary Procedure – Hierarchical w/ CPT groupings

 

MODES OF DATA ACCESS

Depending on the power and flexibility required, balanced with requirements for additional training and technical skill, the Arcadia Analytics data warehouse is built with a simple, open data model so that you can access your data as you need.

Arcadia Analytics Front-End

Platform_Technology_DataWarehouse_DataAccess_Web

Polished, focused user experience that maintains rich filtering and drill-down capabilities, but with a structured set of graphical and tabular layouts.

 

Arcadia Contract Dashboards

Platform_Technology_DataWarehouse_DataAccess_Contract

Highly simplified summary of shared-risk contracts optimized for tablets and mobile devices with limited drill-down and filtering. Provides trending views and comparisons by pod/practice. Ideal for executive resources.

Database Queries (SQL)

Platform_Technology_DataWarehouse_DataAccess_SQL

Complete flexibility and control. Quick answers for highly-trained analysts. Access to raw, unstructured, or infrequently used data.

Business Intelligence Platforms

Platform_Technology_DataWarehouse_DataAccess_BI

Use tools like Qlik and Tableau for additional flexibility and traditional slice & dice, “drill-down” capabilities. User interface is mostly graphical, but advanced users can inject code for more nuanced requirements.