Olu Olaoye's Projects
You are a Data Analyst in an Automotive firm in Calgary, AB, Canada. Your Product Manager just approached you and want to know how efficient the makes of vehicles the company sells have performed over a period of time. You were given access to the automobile dataset consiting of key variables needed to answer the questions being asked by your Product Manager.
Data Cleaning and Visualizations in Excel using the bike buyers dataset.
In this project, Nashville Housing Project was cleaned in SQL Server
Data Exploration of Covid-19 Dataset in SQL Server
Descriptive Analytics Project for Boston Housing Prices
The objective of this project is to perform explorative data analysis and consumption clustering on a synthetic smart metering data of about 98 prepaid meters of 2 of the 11 distribution companies (Discos) in Nigeria.
You're given a task as a Data Analyst to scrape data for the top 250 movies from the IMDb website and perform an Explorative Data Analysis (EDA) on the scraped data in order to answer some business questions.
The year was 2018 and the FIFA World Cup that year was hosted by Russia. The world cup 2018 squad dataset was handed over to explore. As a DA in the Analytics team of a Football Academy company, my task was to uncover some hidden insights to help optimize the scouting decisions of the business.
You are a junior data analyst working on the marketing analyst team at Bellabeat, a high-tech manufacturer of health-focused products for women. Bellabeat is a successful small company, but they have the potential to become a larger player in the global smart device market. Urška Sršen, cofounder and Chief Creative Officer of Bellabeat, believes that analyzing smart device fitness data could help unlock new growth opportunities for the company. You have been asked to focus on one of Bellabeat’s products and analyze smart device data to gain insight into how consumers are using their smart devices. The insights you discover will then help guide marketing strategy for the company. You will present your analysis to the Bellabeat executive team along with your high-level recommendations for Bellabeat’s marketing strategy.
You are a junior data analyst working on the marketing analyst team at Bellabeat, a high-tech manufacturer of health-focused products for women. Bellabeat is a successful small company, but they have the potential to become a larger player in the global smart device market. Urška Sršen, cofounder and Chief Creative Officer of Bellabeat, believes that analyzing smart device fitness data could help unlock new growth opportunities for the company. You have been asked to focus on one of Bellabeat’s products and analyze smart device data to gain insight into how consumers are using their smart devices. The insights you discover will then help guide marketing strategy for the company. You will present your analysis to the Bellabeat executive team along with your high-level recommendations for Bellabeat’s marketing strategy.
Data Collection, Analysis and Insights for the latest chocolate ratings from around the world for Gourmet Analytics
As a Data Analyst in the hospitality industry, you're required to build a hotel database in SQL Server and connect it to Power BI and visualize, in order to answer some business questions.
As a Data Analyst in a not-for-profit international education organization, I utilized historical data of the Bridge Kenya Programme to assess the impact of the program in 111 schools, in 7 provinces across 31 regions in Kenya. The data was for over 13,000 pupils from grades 1-5 from the end of an undisclosed school term in the past five years.
You're a Data Analyst in an Application Development firm in Ontario, Canada. The company just developed a mobile game application targeted at young people between the ages of 18 and 45. This mobile application has recorded tremendous success since the launch with over 100 million downloads recorded on various OS platforms. The Product Manager has summoned you and tasked you with the assignment of determining the 3 highest mobile OS usage across all the OS platforms over a period of 5 months. Based on your findings, you're to make recommendations to the business on how the business can utilize its resources in consolidating the gains of this mobile applications based on its users.
Is the movie industry dying? is Netflix the new entertainment king? Those were the first questions that led to the creation of a dataset focused on movie revenue and analyze it over the last decades. But, why stop there? There are more factors that intervene in this kind of thing, like actors, genres, user ratings and more. And now, anyone with experience (you) can ask specific questions about the movie industry, and get answers. The dataset is gotten from kaggle at https://www.kaggle.com/datasets/danielgrijalvas/movies
My first Colab Notebook produced with Google Colab
Practiced Coding
Numpy Module
Data Wrangling using Pandas Library (Python for Data Science)
The data was gotten from kaggle. The combined data source integrates information from four distinct tables, providing a comprehensive overview of various aspects related to the organization's workforce.
You work for a non-governmental organization tasked with predicting climate change and impacts in Africa and report the state of climate change at the upcoming African Union Summit.
Project Case Scenario Below is an analytical test you're to complete - you will find the dataset attached. While some questions have a correct answer, we are more interested in your line of thinking.