utioritse/Maji-Ndogo-Water-Services-Project

Maji Ndogo is a fictional African country with a severe water crisis. Their new president wants to ensure the project to eradicate this situation is data-led. # Water Services Project Maji Ndogo is a fictional country in Africa. Their newly elected president, Aziza Naledi, is determined to tackle many of the country’s challenges, including its water crisis. She has recruited a team of Data Analysts to ensure the project is data-led. After letting go of corrupt surveyors and visiting water sources nationwide, the project is ready to kick off and President Naledi wants to have an idea of the cost on a national and provincial level. ## Objectives - Create features that give stakeholders a good overview of the situation of the country on a national and provincial level. - Estimate the total cost required to establish functional water sources across the nation. - Determine the number of water sources needed. - Analyze regional disparities - Identify and prioritize provinces based on urgency and resource scarcity - Track cumulative cost to avoid overspending - Assess vendor performance ## Stakeholders - The Presidency of Maji Ndogo - Water source vendors - The people of Maji Ndogo ## Tools Used The project was executed entirely in Power BI, leveraging its data visualization and analytical capabilities: - Visualizations: Designed to present data insights clearly and effectively to stakeholders. - DAX formulas which were used to create calculated columns and measures, enabling deeper analysis and accurate estimations. You can view the dashboards here and here PDF versions here and here