New Year Resolutions

An exploratory analysis (EDA) of the New Year Resolutions made on Twitter in 2015. Each record contains information about the date & time, geographic location, original text, and resolution category of the tweet. The analysis was visualized using Tableau. Check Github for questions and sql queries.

Analysis of Top 100 songs in 2018 on Spotify

An EDA of Spotify's Top 100 songs in 2018. Data was queried using Postgres and Big Query to check top rated artists and other valuable insights by thoroughly exploring the relationships between various features and user interactions to enable a better user experience. Check Github for queries.

HiCi Case Study

EDA into exports by HiCi Ltd, a local food export company. HiCi Ltd is expanding to the European Union. There are risks of product rejection and detaining of the consignment as reported by the EU countries. Check Github for queries. and links for visualization and project description.

Titanic Disaster :Machine Learning Prediction

The sinking of the Titanic is one of the most infamous shipwrecks in history. In this project, I built a predictive model that answers the question: “what sorts of people were more likely to survive?” using passenger data (ie name, age, gender, socio-economic class, etc).

Airline Satisfaction Analysis

An exploratory analysis into passengers' satisfaction levels of different airline offerings

HR Analytics (Attrition) Part I

Exploratory Data Analysis of Attrition among Employees A company has been experiencing a high attrition rate from its staff. This report intends to show how various factors such as age, level of education etc affect attrition. Key: Very Low | Low | Indifferent | High | Very High

HR Analytics (Attrition) Part 2

This is a continuation of HR Analytics (Attrition) project. Here, Random Forest Algorithm was used to determine the probability of an employee leaving.

Designing Database for a Bank's Marketing Campaign

This project involves creating a comprehensive database to store and manage customer information for a bank’s marketing campaigns. The project utilizes MySQL for importing, loading, and creating tables for the database.

End-to-End Data Analytics Webscraping Project

In this project, we scraped Rotten Tomato Website and extracted 140 action movies. This data was imported into sql for Normalization, then to PowerBI for visaualization

Sentiment Analysis of Hotel Reviews

Sentiment analysis is the process of analyzing digital text to determine if the emotional tone of the message is positive, negative, or neutral. This project involves analyzing feedback from customers to know if they are satisfied with services rendered.

A\B Testing Project

A/B testing, also known as split testing, refers to a randomized experimentation process wherein two versions of a variable (web page, page element, etc.) are shown to different segments of website visitors at the same time to determine which version leaves the maximum impact and drives business met

Market Basket Analysis

Market basket analysis is a data mining technique used by retailers to increase sales by better understanding customer purchasing patterns. It involves analyzing large data sets, such as purchase history, to reveal product groupings, as well as products that are likely to be purchased together.

Loan Default Prediction

This is a Streamlit web application for predicting loan default. The app uses a machine learning algorithm (modelled using Random Forest Classifier) trained on the dataset to predict whether a customer is likely to repay a loan or not based on various features.

Prison Database Design

The prison system has no database at the moment which means that an inmate can be incarcerated at a correctional center and still being searched for by security officials not knowing that said person is serving a jail sentence already This prison system database is designed to store and manage

Pyspark: Movie Revenue Classification

Movie Revenue Classification Using PySpark As part of my portfolio, I developed a machine learning project aimed at classifying movies into high or low revenue categories. The objective was to predict whether a movie would attract strong sales based on various features such as genre, release date

Database Design - Pharmacy Store

For this project, I built a complete inventory management system using MySQL for a fictional pharmacist, Chief Lekwot Ejejigbe Edet, who runs 13 shops across Nigeria. The goal was to showcase my skills in SQL, database design, and data automation.

Tableau Interactive Sales Dashboard

Interactive Sales Dashboard for U.S. Retail – Tableau Project In this project, I built a comprehensive sales dashboard using Tableau to analyze publicly available retail data focused on the U.S. market. The dataset, includes historical sales transactions across multiple states, product categories,