M

MARIAM ADEPOJU

About

Mariam Adepoju, a data analyst, whose curiosity for data analytics started in 2022. Along the line, she worked on projects that involved the use of data collection and statistical analysis. She went ahead to recieve comprehensive training at Vephla University and this has enabled her to not only collect, clean, and analyze diverse datasets but also to transform raw data into compelling visual narratives. She has been able to gather both theoretical and practical knowledge on data visualization, data cleaning, Excel, SQL, R, Power BI, and Tableau

Education: BSc Accounting, 2019-Present - Obafemi Awolowo Univeristy, Osun state

Projects

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. This SQL analysis covers various aspects of hotel bookings and customer behavior, including seasonal patterns, demographic distributions, payment methods, hotel ratings, and occupancy trends. It provides valuable insights for users to optimize strategies and enhance customer satisfaction in the hotel industry

Contact

linkedin LinkedIn
email Email