KendiLorna/Microsoft-Power-BI-project

Visualization of the Maji Ndogo situation at a national and provincial level using Microsoft Power BI. ## **COMMUNICATING FINDINGS** ## **INTRODUCTION** This is a project done at ALX Africa as part of my learning. Maji Ndogo is a fictional African country facing a water crisis due to persistent corrupt regimes. The country has a new president keen on reversing past governments' damage and restoring Maji Ndogo to its former glory. On the assumption of office, the president ordered a survey of the water sources to assign resources and prioritize areas that were inadequately served. Maji Ndogo has a population of 28 million people living in the five provinces of Maji Ndogo namely Sokoto, Amanzi, Akatsi, Hawassa, and Kilimani, which have a total of 31 urban and rural towns. There are five water sources in the country: wells, rivers, taps in homes, shared taps, and broken taps in homes. ## USER STORY From the survey conducted, the president of Maji Ndogo wants to see the results represented in visuals on a national level and provincial level for the consumption of development partners, provincial leaders, and herself. The results of the survey should show the improvements to be made to water sources in the country as well as the budget. ## OBJECTIVE ### National level 1. What are the key points of the survey results and the overall status of water access in Maji Ndogo? 2. How many people are affected by water access challenges in Maji Ndogo and what are the challenges? 3. How much money will be needed to complete the upgrades, and where does that need to be spent? 4. The data should be broken down at a national and provincial level. ### Provincial level 1. Total budget per province. 2. The number of improvements to be made, whether in rural or urban areas. 3. The relevant statistics for towns in each province. 4. The count of improvements in the province per type. 5. Summary of improvements and costs. ## DATA SOURCE md_water_services Excel workbook from ALX Africa. There are 8 tables in the workbook. ## STAGES 1. Importing data into Microsoft Power BI. 2. Transformi …