• 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
•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
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
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
•Achieved over 85% accuracy in handling imbalanced data in SMOTE by applying a logistic regression model to predict customer subscriptions
Predictive model to predict whether a bank customer will subscribe to a term deposit or not
Tools: Python | scikit-learn
•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
This data set includes information about individual rides made in a bike-sharing system covering the greater San Francisco Bay area. For the data wrangling & analysis I used Python & Jupyter notebook.
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)