DeleLinus/HFR-Analytics

KaggleX Project Showcase: Prototype End-to-end Analytics Solution on Cloud for the Nigeria Health Facility Registry (HFR) ## Table of Contents 1. Project Description 2. About Nigeria HFR 3. Project Development 4. References # Prototype End-to-end Analytics Solution on Cloud for the Nigeria Health Facility Registry (HFR) This is an end-to-end data engineering project that entails the design and implementation of a data warehouse for the Nigeria Health Facility Registry which is itself a program under the Nigeria Ministry of Health. This project development emcompasses: 1. The design of a **data ingestion pipeline architecture** showing the different Google Cloud Serevices, tools and framework used. 2. The design of the **ERD(Entity Relationship Diagram)** of the system and schema of my final data mart used for reporting. 3. **The implementation of Data Extraction, Transformation and Loading (ETL)** with **Google Cloud Integration** 4. The **Automation and Scheduling** of the processes 5. Basic analytics # About Nigeria HFR The Nigeria Health Facility Registry (HFR) was developed in 2017 as part of effort to dynamically manage the Master Health Facility List (MFL) in the country. The MFL "is a complete listing of health facilities in a country (both public and private) and is comprised of a set of identification items for each facility (signature domain) and basic information on the service capacity of each facility (service domain)". The Federal Ministry of Health had previously identified the need for an information system to manage the MFL in light of different shortcomings encountered in maintaining an up-to-date paper based MFL. The benefits of the HFR are numerous including serving as the hub for connecting different information systems thereby enabling integration and interoperability, eliminating duplication of health facility lists and for planning the establishment of new health facilities. # Project Development ## Data Ingestion Pipeline Architecture This design has been made using app.diagrams.net . * The data source as provided remains the H …