# Africa Water & Sanitation Forecasting Dashboard
## Overview
This project analyzes and forecasts access to safe water, sanitation, and hygiene in Sub-Saharan Africa
(2012–2030) to support SDG-6 (Clean Water & Sanitation) monitoring.
The project was presented as an **analytics case study** with Power BI dashboards, forecasting models,
and business insights.
## Tech Stack
Python | SQL | Power BI | Prophet | Streamlit
## Key Features
- 📊 Interactive dashboards tracking water, sanitation & hygiene metrics (2012–2022)
- 🔮 Forecasting using Prophet & SARIMA up to 2030
- 🌍 Regional comparisons (Urban vs Rural, East vs West Africa)
- 💡 Business Insights: By 2030, 800M+ people may still lack access to clean water
## Demo
- 📑 Case Study Presentation (PPT/PDF)
- 🖼️ Dashboards (sample screenshots below)
## Dashboard Screenshots
## Business Insights
- Drinking Water: ~29% access by 2030 (~360M with access, ~840M without)
- Sanitation: ~28% by 2030
- Hygiene: ~27% by 2030
- Urgent focus needed in Nigeria, Ethiopia, DR Congo (largest shortfalls)
## Notes
- 🔒 Source code & Power BI files are not publicly shared (confidential).
- 📩 Available upon request for interview/review purposes.