Kgabolele/Maji-Ndogo-project

This project focused on analyzing water usage data for a local communities # 🌍 Maji Ndogo Project: Water Usage Analytics Empowering communities with data-driven water management solutions ## 📌 Overview The **Maji Ndogo Project** is a comprehensive data analysis initiative focused on understanding and improving water usage in a small community. Using **Excel**, **MySQL**, and **Power BI**, the project transforms raw infrastructure and usage data into actionable insights that can support decision-making, budgeting, and sustainability efforts. ## 🛠️ Tools & Technologies - **Excel** – for data cleaning and initial exploration - **MySQL** – for structured data storage and complex querying - **Power BI** – for data visualization and dashboard creation ## 📊 Key Features - **Project Monitoring**: Track the progress of water infrastructure projects in different towns and provinces. - **Spending Insights**: View total expenditure by region and funding usage breakdowns. - **Budget Forecasting**: Estimate future costs and identify opportunities for cost reduction. - **Completion Status**: Visualize completed and backlogged repairs and installations. - **Location Analysis**: Drill down from national to provincial to town-level insights. ## 🔍 Data Sources - **Infrastructure Cost Table** – includes unit costs, locations, and adjustment factors - **Project Status Table** – tracks the completion and backlog status - **Town & Province Mappings** – used for regional breakdowns - **Funding Details** – showing funding sources and usage ## 📈 Dashboard Highlights - Bar charts and maps displaying spending by location - KPI indicators for project completion rate, total expenditure, and funding gaps - Filters for province, town, and funding source - Forecasting visuals to support budget planning ## 📂 Suggested Folder Structure