gozzy15/maji-ndogo-water-crisis-analysis

An end-to-end data analytics project analyzing water access, infrastructure, and improvement projects in Maji Ndogo using SQL and Power BI to generate actionable business insights. # Maji Ndogo Water Improvement Project An end-to-end **Data Analytics** and **Business Intelligence** project that analyzes nationwide water infrastructure data using **SQL** and **Power BI** to identify service gaps, prioritize improvement projects, monitor implementation progress, and evaluate financial performance. The project demonstrates how data can be transformed into actionable insights that support evidence-based decision-making and improve access to safe drinking water across the fictional country of **Maji Ndogo**. --- ## Dashboard Preview --- ## Table of Contents - Project Overview - Business Problem - Project Objectives - Tools & Technologies - Database Overview - Project Workflow - Dashboard Highlights - Key Insights - Repository Structure - Project Files - How to Use This Repository - Future Enhancements - Author - License --- # Project Overview The Maji Ndogo Water Improvement Project demonstrates how SQL and Power BI can be combined to solve real-world infrastructure challenges. Using relational database analysis and interactive dashboards, the project identifies communities with inadequate water access, prioritizes improvement projects, evaluates project costs, and measures the overall impact of a nationwide clean water initiative. --- # Business Problem The Ministry of Water Resources needed answers to several strategic questions: - Which communities lack reliable access to safe drinking water? - Which water sources should be prioritized for improvement? - How efficiently were project funds utilized? - Which provinces required the greatest investment? - Which projects generated the highest costs? - What operational factors influence project expenditure? --- # Project Objectives The project was designed to: - Analyze nationwide water infrastructure data. - Evaluate water accessibility across five provinces. - Identify contaminated water sources. - Assess project costs and budget performance. - Monitor project implementation. - …