Profile Picture
Oyedele Samuel

Data Analyst

ABOUT ME

Greetings! I'm Oyedele Samuel, a passionate Data Analyst who love to transform data into actionable insights with reports and dashboards to help business make data-driven informed decisions. My journey began with a foundation in graphic design, where I cultivated an eye for aesthetics and the power of visual communication.

Driven by a curiosity for uncovering insights, I transitioned into the world of data analytics, armed with proficiency in Excel, SQL, Tableau and Python. My analytical mindset meets a design-centric approach, creating a unique blend of skills that allows me to not only dissect large datasets but also transform findings into compelling narratives through visualizations.

My goal is to leverage soft and technical skills to contribute meaningfully to the data-driven landscape. Ready to use my analytical and communication skills to solve problems by tackling real world projects within a team or as an individual.

Some of my skills and technologies: Python (pandas, matplotlib, numpy, seaborn), Excel, SQL, Tableau, Data Wrangling, Data Visualization etc.

MY RESUME

PORTFOLIO

EXCEL PROJECTS

ALL MESSI CLUB GOALS EXPLORATORY DATA ANALYSIS

A picture of Messi

Excel Spreadsheet was used to perform data preprocessing and descriptive analysis to get insights from Messi's club goal dataset.
Tableau was used to create an interactive dashboard that visualized the insights gotten from the dataset.

FIFA 21 DATA CLEANING

FIFA 21

DATASET:
This a FIFA 21 dataset that consists of player’s attributes and stats like Name, Nationality, Position, Age, Value, Wage, BOV, Attacking, Crossing, Finishing, Skill, Dribbling, Ball Control, Power, Strength, Stamina etc. They are 18979 rows and 77 columns.

I used Excel to perform data cleaning on this dataset. The data issues are cleaned using Excel functions like FIND(), MID(), SUBSTITUTE(), LEN(), IFERROR()

SQL PROJECTS

BUSINESS ANALYSIS IN SQL : DANNY'S DINER CASE STUDY

Danny's Diner

Danny’s Diner is a restaurant business that sell Japanese food and who want to use his business data to help make data-driven decisions for the business.

PostgreSQL was used to perform exploratory data analysis on three datasets from the business data to help provide data insights about the customers. Having this deeper connection with his customers will help him deliver a better and more personalized experience for his loyal customers.

PIZZA RUNNER SQL CASE STUDY

Pizza runner

Pizza Runner is a Pizza business that recruit ‘runners’ to deliver fresh prizza from Pizza Runner headquarters to its customers.

PostgreSQL was used to perform data cleaning and exploratory data analysis on six datasets (tables) in other to provide effective data insights about the customers to the stakeholders of the business. Some business questions were answered to get insights on the business sales.

PYTHON PROJECTS

Oral Insulin Phase II Clinical Trial Data Analysis

Injectible Insulin picture

Objective:
To compare the effectiveness of the new oral insulin (Auralin) and injectable insulin (Novodra) in patients with type 1 diabetes.

Dataset: Auralin and Novodra Trials
The dataset is phase two clinical trial data of 350 patients for a new innovative oral insulin called Auralin - a proprietary capsule that can solve this stomach lining problem: -  Patients data - Treatments data- Adverse reactions data.

Data Wrangling (gathering, accessing and cleaning) was perform on the three pieces of data for better analysis and visualization.

PROSPER LOAN DATA : EXPLORATORY AND EXPLANATORY VISUALIZATION

Performed Exploratory analysis on a Prosper Loan Data gotten from Udacity to explore and convey findings through visualizations. Data wrangling was performed on a subset dataset of 77,543 loans with 20 variables using Python libaries (pandas, matplotlib, numpy and seaborn libraries).

Recommendations was given to help optimize the loan's data and provided a better scheme of loan's to the customer's.

TABLEAU PROJECTS

tableau logo

Tableau is a powerful data visualization tool for data analysis and business intelligence. It has a user-friendly interface, which allows users to drag and drop data to create visuals quickly.
Tableau is used to create interactive dashboards that visualize data and reveal patterns for effective communication.

VIRTUAL INTERNSHIP

KPMG AU DATA ANALYTICS VIRTUAL INTERNSHIP

KPMG Headquarter building

This is a project from my KPMG data analytics virtual internship program where I work as a data analyst to performed three tasks on SprocketCentral Pty Ltd datasets using Excel:-         
Data Quality Assessment  
Data Insights: Targeting
Data Insights and Presentation

I analyzed and visualized the customer datasets to help provide customer insights which could help optimize for targeted marketing. Hence, improve performance by focusing on high value new customers.

TATA DATA VISUALIZATION JOB SIMULATION: Empowering Business with Effective Insights.

Tata building

This is a project from my Tata Data Visualization Job Simulation where I work as a data analyst consultant on an Online Retail Store sales data to provide effective data insights through data visualizations to the stakeholders of the business to make a data-driven informed decision making.

I was able analyzed and visualized the retail store sales data using Tableau to communicate and convey my key findings to the stakeholders. I also provide recommendations for the business growth.

CONTACT

Get in Touch

Open to role or collaboration on any data analysis projects.