Project Status Overview
The following requirements were identified during the sprint as highest priority for the phase 1 implementation of the MVP warehouse initiative:
- Develop a data extraction strategy that can support extracting from 14 different MVP sites.
- Capture and correct as many unexpected data scenarios as possible.
- Extract as many observations possible to model the indicators in the attached spreadsheet, eHealth Indicators for Pentaho Dashboard 2011-10-24.xls.
- Develop a load strategy and physical database schema that can support aggregation of the 14 sites' data into a common, centralized data store.
- Develop the needed models to allow Pentaho Analysis reports to be created against the loaded star schemas in the warehouse.
MVP Tasks and Status
Design deployment topology for the MVP ETL and data warehouse initiative.
Implement the ETL processes that will extract, de-identify and load OpenMRS data from the source OpenMRS instances in the field to a centralized warehouse.
Design and implement the OLAP schema models for births, deaths and health indicators.
Install and configure servers per design, both in the United States and Africa (refer to the design slides attached).
Deploy, schedule, monitor and maintain the warehouse solution.
Sprint Objectives & Summary
See the OpenMRS Pentaho sprint page for sprint objectives and a summary of the development effort.