Welcome to Yusuf Olaniyi's Portfolio - Data Analytics Section

Summary

I'm proficient in using SQL, PowerBI and Python for data analysis. Below are some of my analytic projects including Exploratory data analysis, Explanatory data analysis, and Market analysis

DATA ANALYSIS WITH SQL AND PowerBI

February 2022

Market Analysis
with SQL

I utilized PostGRE SQL to conduct a detailed market analysis spanning five African countries. Focusing on profit, brand performance, and country-specific insights, I unearthed valuable patterns to enhance the company's market strategies. This project showcases my expertise in leveraging SQL for in-depth business analytics and strategic decision-making.

September 2023

Global YouTube Analysis
with SQL

I analyzed 2023 Global YouTube Statistics using SQL Server, focusing on video views, channel performance, and subscriber data. This project demonstrates my expertise in leveraging SQL for detailed data analysis, offering valuable insights into YouTube's global trends and user engagement patterns.

October 2023

Global YouTube Analysis with PowerBI

I conducted thorough cleaning and analysis of the 2023 Global YouTube Statistics using Microsoft PowerBI, PowerQuery, and Excel. Through these tools, I extracted valuable insights and formulated strategic recommendations. This project demonstrates my expertise in data processing, visualization, and providing actionable insights essential for strategic decision-making.

DATA ANALYSIS WITH PYTHON

May 2022

Missing Medical Appointment
Analysis

I utilized Python libraries including Numpy, Pandas, Matplotlib, and Seaborn to analyze 110,527 missing medical appointment records. Through exploratory data analysis, I identified factors contributing to patient no-shows. This project demonstrates my proficiency in Python-based data analysis and visualization, providing valuable insights for healthcare appointment management.

July 2022

@we_rate_dog
Data Wrangling

I utilized Python libraries and Tweepy to extract and wrangle data from Twitter API. Employing effective data manipulation techniques, I gained insightful information. This project illustrates my proficiency in Python-based social media data analysis, demonstrating my ability to extract meaningful insights from Twitter data.

July 2022

Exploratory and Explanatory Data Analysis

I conducted exploratory and explanatory data analysis using Python on a bike-sharing dataset from the San Francisco Bay area. Through detailed analysis, I revealed patterns in rider behavior, highlighting my expertise in leveraging Python for comprehensive data insights. This project demonstrates my ability to extract valuable information for optimizing bike-sharing services.