brianmtepe/mch-kenya-powerbi-dashboard

Power BI dashboard analyzing maternal and child health Indicators across Kenyan counties # Maternal & Child Health (MCH) County Analytics Pipeline ## Clinical Triage of Service Gaps Across Kenya's 47 Counties This project is a healthcare analytics solution designed to monitor Maternal & Child Health (MCH) indicators across Kenya using MySQL, Python(pandas) and PowerBI. The solution transforms county-level healthcare data into reporting-ready insights that support public health monitoring, risk identification, resource allocation, and evidence-based decision-making. --- # Executive Summary & Analytics Pipeline End-to-end healthcare analytics workflow supporting Maternal & Child Health performance monitoring and decision support. This project transforms county-level Maternal & Child Health (MCH) data into a structured healthcare analytics workflow designed to support monitoring, risk identification, and evidence-based decision-making. The solution combines SQL data modeling, healthcare KPI views, risk segmentation logic, and Power BI dashboards to deliver reporting-ready insights for public health stakeholders. --- # Problem Statement Maternal and child health outcomes are often affected by delayed identification of service delivery gaps and regional healthcare disparities. Public health teams require clear, data-driven tools to monitor mortality trends, evaluate maternal healthcare coverage, and prioritize high-risk counties for intervention. Traditional spreadsheet reporting makes it difficult to rapidly identify: - Counties with elevated under-5 mortality rates - Gaps between facility delivery and postnatal care utilization - Regional inequalities in healthcare service coverage - Counties requiring targeted public health interventions This project addresses these challenges through interactive healthcare analytics and executive-level dashboard reporting. --- # Solution Overview An end-to-end healthcare analytics pipeline was developed to: - Monitor Maternal & Child Health indicators at county level - Visualize mortality and healthca …