A county-level public health organization utilized reporting that was built upon the EHR itself and ancillary systems. Various departments used inconsistent definitions of data, month-end reporting was done manually after collecting information, and management had no single enterprise-wide perspective across all hospitals, clinics, and community services.

Build a data layer before implementing a reporting layer. In-depth knowledge about the EHR data model and its extension tables, as well as EHR local configuration, made it possible to build reports based on reality rather than raw data extracts. The analytics was implemented as a managed service, ensuring data quality, governance, and consistent KPIs while source systems were changing.

Data warehouse for enterprise healthcare that incorporates Cerner EHR along with financial, scheduling and other ancillary systems; semantic layers of data for clinical, operational and revenue reporting; standard KPI framework and executive dashboards; managed analytics operations and governed change control corresponding to source systems’ upgrades.