Abibat Oki's
Portfolio

Hi there, welcome to my portfolio website! I’m Abibat, a detail-oriented Business Analyst with a strong foundation in financial analytics, customer experience, and data-driven decision-making. I specialize in turning data into actionable insights that improve efficiency, enhance customer journeys, and support business growth. Here, you’ll find projects that showcase my ability to connect data, people, and strategy to solve real-world business problems and create meaningful impact.

UrbanHaul Rider And Operations Analytics

This project analyzes the rider, delivery, and operations data of a last-mile logistics and delivery platform, using Microsoft Excel and Power BI. It models and visualizes revenue, efficiency, and performance metrics across regions and riders. The analysis also includes an interactive dashboard that helps to identify high performers, uncover inefficiencies, and make data‑driven decisions to improve service quality and profitability.

Greenhouse Gas Emissions Analysis Using Databricks

Emi

This project analyzes the EPA’s 2023 county‑level greenhouse‑gas emissions dataset using Databricks. I cleaned and aggregated the data to summarise emissions by state and county, examined per‑capita and climate‑zone patterns, and delivered insights and recommendations for reducing emissions.

Hospital Transaction Analysis

A concise, interactive analysis of hospital transaction data using Power BI. The project cleans, models and visualizes revenue, expenses, profits and key metrics to reveal trends, top-performing specialties and actionable insights for data-driven decision making.

Customer Churn Analysis With Excel

A comprehensive Excel-based churn analysis exploring customer behavior, churn drivers, demographic patterns, and competitor impacts. Includes cleaned datasets, pivot tables, and a dashboard to support data-driven retention strategies.

Bank Customer Segmentation

Unsupervised customer segmentation project to identify high-impact customer groups and support targeted banking strategies like loyalty programs, retention, and personalized offers.

Credit Scoring Model

A credit scoring model to predict loan default risk using machine learning. It is designed to support smarter lending decisions and reduce losses from high-risk loan approvals.

Data Cleaning in SQL

This project is about cleaning the Nashville Housing Data using queries such as CONVERT, SUBSTRINGS, PARSENAME, CTE, and PARTITION BY.

Bike Sales Analysis

An analysis of bike sales data using Excel to identify trends in customer behavior, product performance, and revenue growth through data cleaning, visualization, and exploratory analysis techniques.