Case Studies

A collection of data analytics projects by Ibinabo Adiela, focused on solving real-world business and healthcare problems. Each case study highlights the analytical approach, tools used, and key insights, with detailed documentation and code repositories included where applicable.

Technical Project
Reducing Missed Appointments in an Outpatient Clinic - Power BI visualization showing factors affecting missed appointment rates
Dashboard Preview

Reducing Missed Appointments in an Outpatient Clinic

An end-to-end healthcare analytics project using Excel and Power BI to uncover patterns behind outpatient no-shows.

Power BI DAX Excel
Technical Project
Which Customers Are Likely To Churn and Why - Customer Churn Prediction with Streamlit
Data Model Prediction

Predicting Customer Churn Risk

Churn prediction system built to help retention teams identify which customers are most at risk and why.

Python Logistic Regression Streamlit
Technical Project
Ethereum_Whale_Tracker_Dashboard
Ethereum Whale Tracking Dashboard

Ethereum Whale Tracking Dashboard

A lightweight on-chain analytics tool for tracking and analyzing large Ethereum transfers and capital movement.

Python Streamlit Alchemy API Ethereum (On-Chain Data)
Analytical / Business Case
Sales Dashboard with Power Bi
Sales Dashboard

Sales Dashboard with Power Bi

Analyzed sales dataset with 185,000+ rows, identified trends, and created visualizations using Power BI, revealing insights on top-selling products, weekend sales spikes, and opportunities for growth and optimization.

Excel Power BI Data Visualization
Technical Project
Geospatial Analysis and Outlier Detection of Election Data
Geospatial Analysis

Geospatial Analysis and Outlier Detection of Election Data of Akwa Ibom State

This project examined the 2023 Nigerian election in Akwa Ibom State by calculating outlier scores and identifying significant anomalies.

Python EDA Geospatial Analysis Excel
Analytical / Business Case
Patient_satisfaction_dashboard
Dashboard Preview

Patient Satisfaction in The Emergency Department

Investigated the factors influencing patient satisfaction in hospital Emergency Departments (EDs) using data visualization techniques in Tableau.

Tableau Data Analysis Data Visualization
Analytical / Business Case
Immunization_Dashboard
Immunization Dashboard

Immunization Analysis using PostgreSQL and Tableau

Analyzed flu shot compliance using PostgreSQL and Tableau, uncovering key insights on vaccination trends across demographics. Developed visualizations to guide targeted healthcare interventions based on age, race, and geographic location

PostgreSQL Tableau Data Visualization
Technical Project
Pyschometric_Ai_Model
Machine Learning

Psychometric AI Model

Using Python programming language and machine learning techniques this project seeks to provide personalized career guidance and recommendations to individuals, empowering them to make informed decisions about their professional trajectories.

Python Flask API Machine Learning Postman
Analytical / Business Case
Titanic
Dashboard Preview

A Quick Review Of The Titanic Dataset

The analysis aims to identify factors that influenced the passengers' survival on the infamous cruise ship.

Python Data Analysis Data Visualization