Kelechi Ogbogu
Data Analytics Portfolio

I’m a data analyst who loves turning messy numbers into practical insights that teams can actually use. I work hands-on with tools like SQL, Power BI, Python, Tableau, and ETL pipelines to build dashboards, automate reports, and structure data in ways that make decision-making easier and faster. I enjoy solving problems, collaborating across teams, and translating complex datasets into clear stories that drive impact. My goal is always to help organizations not just understand their data, but act on it to improve workflows and achieve better results. Check out my LinkedIn page:
@Kelechi Ogbogu.

Car Scrap Price Prediction Using Regression Analysis in Python

In this project, I built a Linear Regression model to predict scrap car prices. I cleaned and processed the data, handled categorical features, and removed outliers. After training the model, I evaluated it using R² and cross-validation. The model achieved around 80% accuracy, providing a reliable baseline for predicting car scrap values.

December 29, 2022

Global Super-store Sales Data Analysis

This project explores Global Superstore’s sales data to identify patterns in customer behavior, product performance, and seasonal trends. It showcases my ability to clean and analyze data and provide recommendations that can guide stakeholders in making better decisions.

December 01, 2022

An Analysis of Police Deaths in America Using R

This project analyzes US police deaths in the line of duty, revealing that gunfire, automobile crashes, and heart attacks are the leading causes, with certain ranks and states most affected. It demonstrates my ability to clean and analyze data, extract meaningful insights, and make recommendations using R programming.

August 09, 2022

Hospitality Data Analysis with SQL

This project looks at hotel reservation data to see how people book rooms, which room types are most popular, and how revenue varies across properties. It shows my skills in cleaning, organizing, and analyzing data using SQL.

August 17, 2022

Sentiment Analysis of the news of Marc Cucurella's transfer to Chelsea Football Club.

This project analyzes Twitter reactions to Marc Cucurella’s transfer to Chelsea FC using Natural Language Processing. I scraped tweets, cleaned and processed the text, and performed sentiment analysis to classify reactions as positive, neutral, or negative. The results show that most tweets were positive, with a smaller portion being negative. This project showcases my skills in web scraping and sentiment analysis using Python.

August 22, 2022

Online Retail Data Analysis With Exce

This project analyzes retail sales data to categorize products based on how well they sell and the value they bring to the business. Using Excel, I cleaned and prepared the data, applied RFM-inspired scoring to group products, calculated revenue, and identified trends in sales and back orders. The project highlights my ability to manipulate large datasets, create formulas, use pivot tables, and visualize insights in Excel to support business decisions.

November 21, 2022

Fraudulent-Transaction-Detection

This project builds models to detect fraudulent activities using Logistic Regression, XGBoost, and K-Nearest Neighbors. I handled imbalanced data, trained the models, and evaluated their performance using confusion matrices, demonstrating my skills in classification and data preprocessing.