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
Analytical / Business Case
Sales Performance Analysis - Excel charts and pivot tables showing quarterly sales trends
Data Visualization

Sales Performance Analysis

Excel-based analysis of quarterly sales performance, identifying key trends and providing actionable recommendations for sales strategy improvement.

Excel Pivot Tables Data Visualization
Technical Project
Predictive Modeling for Patient Readmissions - Python machine learning model visualization and results
Model Visualization

Predictive Modeling for Patient Readmissions

Python-based predictive model using machine learning to identify patients at risk of readmission, enabling proactive care interventions.

Python Pandas Scikit-learn Jupyter
Analytical / Business Case
Healthcare Operations Efficiency Analysis - Process flow diagrams and efficiency metrics
Workflow Diagram

Healthcare Operations Efficiency Analysis

Process improvement analysis using Excel to identify bottlenecks in healthcare operations and recommend efficiency improvements.

Excel Process Analysis Business Intelligence
Technical Project
Data Pipeline Automation - ETL architecture diagram showing data flow and transformation steps
Architecture Diagram

Data Pipeline Automation

Automated ETL pipeline using Python to process and transform healthcare data, reducing manual processing time by 80%.

Python ETL Automation Data Engineering
Analytical / Business Case
Financial Performance Dashboard - Power BI executive dashboard with KPI metrics and financial charts
Dashboard Preview

Financial Performance Dashboard

Executive-level Power BI dashboard providing real-time insights into financial performance metrics and KPIs for stakeholder decision-making.

Power BI Dashboard Design KPI Tracking