Omarahmed988/Unraveling-the-Secrets-of-Maji-Ndogo

A Data-Driven Quest for Equitable Water Provision in Rural and Urban Areas, Empowered by SQL, Spreadsheets, and Power BI # 🌟 Sharing an Incredible Journey! 🌟 I'm thrilled to present one of the most impactful projects I've ever undertaken, leveraging the power of SQL and Power BI. Join me as we delve into the transformative story of the Maji Ndogo project, where data analysis became a catalyst for change. ## Project Overview In Maji Ndogo and communities worldwide, access to clean and reliable water sources is an absolute necessity for daily life. Throughout this project, I collected extensive data on water sources, water collection, and crime, gaining profound insights into the daily lives of residents and the pivotal role water plays in their well-being. Imagine relying on a few primary water sources, often located far from homes. For many, especially women and children, a significant portion of the day is dedicated to collecting water. This arduous task involves enduring long walks under the scorching sun, carrying heavy containers, and waiting in endless lines at the water sources. The physical and time demands of this chore can be grueling, especially for those juggling work and household responsibilities. Unfortunately, these limited water sources often become overcrowded, creating tense situations as people compete for access to this precious resource. Such circumstances can lead to disputes and, in some cases, even escalate into criminal activities. ## SQL Phase In the initial phase with SQL, I embarked on a comprehensive journey, divided into four distinct parts, ultimately converging into a powerful notebook file: #### Part 1: Data Exploration and Refinement I delved into Maji Ndogo's extensive database, housing over 60,000 records across multiple tables. Using basic queries, I familiarized myself with the contents of each table while refining some data using DML techniques. #### Part 2: Deep Data Analysis The second phase propelled me into a deep analytical dive, exploring Maji Ndogo's water landscape. Armed with a vast array of functions, including intricate window …