About

Hello! I’m Mariam Adepoju and I am excited to welcome you to my portfolio website. As a data analyst, with passion for transforming raw data into clear and actionable insights, I have worked on several projects which have contributed to sharpening my skills in Excel, SQL, Python, Power BI, Tableau, and data visualization. My journey in data has been driven by the fascination of how information can shape business strategies and drive informed decisions. Whether uncovering patterns in large datasets or presenting insights in a clear and visually compelling manner, I’m dedicated to making data accessible and actionable. With my analytical skills, attention to detail, and drive to uncover the hidden truths in data, I am eager to continue making a significant impact. I am always looking for new opportunities to grow and contribute in the ever-evolving world of data analysis.

Education: BSc Accounting

Projects

HR

HUMAN RESOURCES ANALYSIS

This report presents a detailed analysis of employee-related metrics based on the company's Human Resources Dashboard. It encompasses statistics on workforce activity, departmental distribution, state-level hiring, employee demographics, performance ratings, educational qualifications, and income patterns. The visualizations used to derive these insights provide a comprehensive view of the HR landscape, enabling data-driven decision- making for workforce planning and management.

kitchen

SALES PROJECT

Sales project is a consumption product selling company and the dashboard talks about all its transactions that took place in 2014. Lets analyse the sales trend, transaction by amount, sales by region, the best sales rep and a lot more.

kitchen

GLOBAL SUPERSTORE

Global Superstore is a global online retailer based in New York, boasting a broad product catalogue and aiming to be a one-stop-shop for its customers.This analysis shows the countries that generated the highest profit, The products that generated the highest revenue, shipping costs, the least profitable Country and a lot more. This dataset was cleaned and sorted using excel, queried using SQL and visualized using Power Bi.

kitchen

HOTEL DATASET

The Hotel dataset contains 66,542 hotel bookings between January 1st 2010 and December 31st 2019, from a company dedicated to assisting international travelers in securing accommodations in various destination countries. Lets analyze more insight into customer behavior, booking patterns, the most frequently booked hotel during the specified time frame, and other relevant factors using SQL

kitchen

SQL MURDER MYSTERY

Investigating the murder in SQL City on January 15th, 2018, this project started with the search for the crime scene report, showing SQL City as the location and the specific date. This led to the identification of the witnesses.

Kindly checkout my other projects on GitHub

Contact