Ilesanmi Samson

PORTFOLIO

Data Analyst well versed in Excel, SQL, Python, PowerBI and Tableau

Excel Dashboard

Sales Analysis

• Which product and city has generated the most profit and sales for the last 2 years?
• The category and subcategory of each product.
• The total sales and profits for each quarter for the last 4 years.
• The cities with the top sales

Tools: Excel, PivotTable, Chart

LinkedIn Data-Analyst Jobs In Africa

•Made an exploratory analysis on the number of Data Analyst Jobs made available in Africa
• What types of jobs are available -- Remote, Full-time or Hybrid
• Are there increases in Data Analytics jobs?
• What are the industries to look into?

Tools: python | PowerBi

House Rent Prediction

Regressive Predictive Analysis

•Created a WebApp displaying predictable home rental prices using Streamlit
•Achieved exploratory and predictive regression analysis of over 4,700 customer datasets

Tools: python | scikit-learn

Data Analysis

Impact of Weather Conditions on Air Quality

Case Description

A company in the environmental consulting industry is seeking to analyze the air quality in a specific city during hot and cold weather, during high-wind conditions and during precipitation. They are interested in making recommendations to the government and businesses in the region on how to mitigate the impact of weather conditions on air quality.

Tool: PowerBI

Analysis on Ford Go-Bike System Data

Exploratory and Explanatory Analysis

•Performed exploratory and descriptive analysis of over 183,000 trips across 16 trait datasets to gain insight into multiple factors that influence trips and correlations. •Discovered patterns, spotted anomalies, and tested hypotheses with the help of summary statistics and graphical representations

Tools: Python | Medium


We Rate Dogs

Data Wrangling Project

This is a data wrangling project. In this project, I made use of the Data Wrangling steps, which are:
1. Gather
2. Assess
3. Clean

In this project I gathered data from multiple sources (WeRateDogs twitter account, downloaded programmatically)