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
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.
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.
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
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.
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.
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.