Estimates on the use of water dataset for 2020. WHO/UNICEF JMP (Joint Monitoring Programme for Water Supply, Sanitation, and Hygiene)

The JMP dataset estimates household access to drinking water services between 2020 to assess progress toward achieving the sixth SDG. The dataset uses service ladders to benchmark and compare access to drinking water across different countries. The ladder defines five different service levels.

Access to drinking water: Transforming Data

In this project, I was able investigate access to safe and affordable drinking water focusing on inequalities in services levels between different countries and regions.

Sales & Inventory Management Dashboard

To design and develop a dynamic Excel-based dashboard that provides actionable insights into sales performance, inventory levels, and product return trends. The project leverages advanced Excel tools such as Power Query, Pivot Tables, advanced formulas, conditional formatting

Superstore Sales

Superstore sales generally refers to the sales and performance of the superstore.. Analyzing superstore data is essential for store owners, manager and analyst to understand the store performance, identify trends and make inform decisions. ref: kaggle.com

Restoring the lifeblood of Maji Ndogo

At the heart of this project is the water crisis faced by a fictitious country called Maji Ndogo. In this project, I dived deep into the intricacies of using SQL to solve complex problems. This project progressively challenges me and offers less guide as I progress pushing me to think critrically.

Maji Ndogo: From analysis to action

In this third part of the integrated project, l pulled data from many different tables and apply some statistical analyses to examine the consequences of an audit report that cross-references a random sample of records

Visualising Maji Ndogo’s Past

In this first part of the integrated project, we are introduced to updated data concerning the gender composition of queues at shared water taps in Maji Ndogo, and some new crime-related data effectively communicating our findings to our key stakeholders

Moulding data into visual stories in Maji Ndogo

In this second part of the integrated project, we focus on data models. We’ll import tables separately, clean data, and set up a working relational data model in PowerBI. We will also recreate our visuals with the new data model, and see how the new model affected our visuals. Our goal is to refine

Communicating my findings in Maji Ndogo

I finalize our national survey report. I will use DAX to create measures and columns to enrich our data to ensure accurate and useful data representation on the dashboard. I put together all I have learned to create the survey report.