1 / 15

Bringing data into common place through use of appropriate database software

Bringing data into common place through use of appropriate database software. Muhammad Abdul Hannan Khan Senior Advisor HMIS GIZ Health Dhaka, Bangladesh 20 June 2011. DMIS Project objectives. DMIS is a project funded by giz and its objectives are :

kelsie-guthrie
Download Presentation

Bringing data into common place through use of appropriate database software

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Bringing data into common place through use of appropriate database software Muhammad Abdul Hannan Khan Senior Advisor HMIS GIZ Health Dhaka, Bangladesh 20 June 2011

  2. DMIS Project objectives DMIS is a project funded by giz and its objectives are : • Create a central data warehouse for integration of data from different sources, e.g. MIS Health, FP, NNP, UPHCPII, and vertical programs (EPI, TB etc.) • Enhance utilization and quality of routine data • Improve the HIS related capacity of the MoHFW and the performance of the MISs and programs

  3. Making data compatible and comparable UPHCP MIS EPI TB MIS 01.11.2014

  4. Data warehouse today The data warehouse with about 8 million data values and 1,000 data elements is ready for use, e.g. for indicator monitoring; it can create dynamic reports, graphics and GIS presentation for all levels and different queries A web portal is designed and dashboards containing the most important indicators are ready, allowing the utilization of information at the fingertip MISs have started using the same open source software (DHIS2) DMIS is using; standardization and harmonization processes have been initiated 01.11.2014

  5. Opportunities Use the data warehouse as a basis for an integrated e-health architecture, that pools data from all MISs and other systems, e.g. HRIS, Hospital IS, Logistics, finance and poverty related data; DSF; private sector; patient/case based information; integration of all urban health data (SSFP, UPHCP, etc.) & other upcoming systems (e.g. OP reporting) Improve & decentralize data entry and utilization for program monitoring and decision making 01.11.2014

  6. HIS Architecture • External Agencies • Drug Stores • Labs • Logistics management • Requirement Forecasting • Equipment • Monitor Trainings • Monitor Leaves • Monitor Postings • Monitor reporting • Monitor data reliability • Monitor facility services • Perform Disease Surveillance • Lab Tests • Diagnosis • Treatment UID UID UID UID UID UID • Electronic health records • Service tracking in the community • Decision support to work force • Health expenditure tracking • Beneficiary payments • Insurance tracking HIS 5

  7. DHIS 2 : Technical Specifications The Application is Free and Open Source, Developed using four layer architecture. The layers are Database layer, Hibernate, Spring and Webworks. The application is modular in structure and capable of being plugged in with other applications even if running in different platforms The Application run both online and offline with the same features. The application is Database independent and is now currently optimized for free and open source MySQL 5.0 database. The application is platform independent which can be run on both Windows 2000,Me,XP and above and Linux like operating systems. The application is support multi-language customization both the user screen and database. 01.11.2014

  8. Open Source sustainability advantages 01.11.2014

  9. Need for standard identity of reporting units • Present status: No central register of healthcare service providers and administrative division of a country. • Consequence: missing unique identity of districts, upazilas, facilities and NGOs • Example of different spelling of upazila name:

  10. Need for unified definitions of data elements and indicators • Several MISs collect the same information but uses different names of the data elements. • Data elements are not clearly defined and definitions are not shared between MIS’s • Consequence: It is very difficult to interpret routine data and indicators results • Example:

  11. DMIS standards (data interchange) (ISO/TS 17369: 2005 SDMX-HD) • For metadata - ISO/IEC 11179 • For data interchange - ISO/TS 17369: 2005 SDMX-HD

  12. DMIS: ETL (Extract, Transfer, Load) Process

  13. DMIS: Meaning of Data Values

  14. DMIS: ETL Process

  15. Thank you

More Related