Road Accident Dashboard in Excel

In this project, I designed and developed an interactive Road Accident Dashboard using Microsoft Excel. The project involved a comprehensive end-to-end process, from data acquisition to creating insightful visualizations. This dashboard showcases my skills in data analysis, visualization, and Excel.

Pizza Sales Dashboard on Excel

In this project, I successfully executed a data analytics initiative that combined the power of Excel and SQL. The project journey encompassed data import, cleaning, processing, complex querying, and ultimately, the creation of an insightful dashboard.

Exploring the US Bikeshare Data

I delved into Bikeshare data from major US cities using Python. I learned to analyze usage patterns, station popularity, trip durations, and user demographics. The project helped me explore peak hours, popular stations, and user behaviors, requiring Python, pandas, and numpy for analysis.

Maji Ndogo Water - National water survey results

In this project, I investigated access to safe and affordable drinking water in an "imaginary" town called Maji Ndogo. This project is inspired by the UN's sustainable development goal 6: Clean water and sanitation. I used Excel, SQL, and Power BI to clean, process and derive insights from the data.