Philopater-George/Maji-Ndogo-Water-Crisis-A-Power-BI-Data-Analytics-Project

# Maji Ndogo Water Crisis: A Power BI Data Analytics Project This repository contains a comprehensive Power BI project analyzing the water crisis in Maji Ndogo. The project is divided into four parts, each building upon the last to provide a deep dive into the data, from initial exploration to the creation of a public-facing dashboard for tracking improvement efforts. ## Project Overview The goal of this project is to use Power BI to analyze survey data from Maji Ndogo to understand the state of water access, identify key challenges, and track the progress and financial aspects of a project aimed at improving water sources. The project addresses various aspects of the water crisis, including population distribution, water source types, queue times, water pollution, and the social impact of water collection, such as crime rates. ## Tools and Technologies * **Power BI:** Used for all data modeling, analysis, and visualization. * **DAX (Data Analysis Expressions):** Utilized for creating complex measures such as cumulative costs, budget tracking, and basic water access percentages. * **Power Query (M Language):** Employed for data cleaning, transformation, and shaping the initial datasets. ## Part 1: Visualising Maji Ndogo’s Past In the first part of the project, we focused on the initial exploration and visualization of the survey data. This phase was crucial for understanding the basic landscape of the water crisis in Maji Ndogo. ### Key Activities: * **Data Import and Cleaning:** The initial dataset was imported from a CSV file into Power BI. Basic data cleaning and transformation were performed to ensure data quality and usability, such as verifying correct data types. * **National-Level Analysis:** Visuals were created to represent the survey results at a national level. This included a pie chart showing the urban vs. rural population split and a bar chart illustrating the distribution of different water source types. * **Infrastructure Mapping:** A custo …