Data analytics · Business intelligence · Full-stack software

Project case studies

Detailed write-ups of selected data analytics, business intelligence and full-stack projects by Emmanuel Abolade. Each page sets out the problem, data, method or architecture, results and limits, and links to the public source or live demo so the work can be checked.

Case studies

Nine projects across analytics, BI and software engineering.

Event Travel Intelligence web app home screen with event selection and journey inputs over a map
Live demo
Full-stack · Decision intelligence

Event Travel Intelligence

A travel-intelligence platform for journeys to major UK events. Enter a starting point and an event to get route analysis, event-adjusted journey estimates, travel risk, Park & Ride options, an interactive map and overnight return analysis. Modelled conditions are clearly separated from measured live data.

  • Python
  • FastAPI
  • SQLite
  • JavaScript
  • Leaflet
  • OSRM
  • Nominatim
Outbound + returnjourney analysis incl. overnight
7 test modulesAPI, engine, live transport
Pages + Renderfrontend and API hosting
FastAPI Swagger documentation page (/docs) for the live Jobs API, showing the interactive OpenAPI interface
Live API · live-ready payments
Full-stack · Payments API

Jobs API with Stripe payments

A jobs-board API with a production-grade Stripe payment flow: hosted Checkout, signature-verified webhooks, idempotent recording and nightly reconciliation. The API is live; payments run in Stripe test mode and are ready to switch to live keys.

  • Python
  • FastAPI
  • PostgreSQL
  • psycopg
  • Stripe
  • Render
  • GitHub Actions
Hosted Checkoutcard data never on the server
Idempotent writesUNIQUE session id
Nightly reconcileStripe as source of truth
Power BI CEO overview for the restaurant financial analysis with sales, payments and trend visuals
Portfolio analysis
Data & BI · Financial controls

Restaurant Financial Intelligence & CEO Dashboard

Multi-unit hospitality financial analysis that surfaced a control gap, not just a dashboard. It became the grounding for the ControlDeck NG product UI.

  • Python
  • pandas
  • SQL
  • Power Query
  • Power BI
≈ ₦2.89bnrecorded sales
19,146payments without payee
Apr 2026expense records collapse
ControlDeck NG CEO Home screen with naira KPI cards, a revenue and expense trend and critical alerts
Proof of concept · live
Full-stack · BI product UI

ControlDeck NG — Executive BI Dashboard

The restaurant analysis turned into a product surface: CEO Home, Financial Control Centre, Sales, Cost & Profitability, Inventory, Purchasing, an AI assistant with demo responses, and alerts. Mock data shaped by real findings.

  • React 19
  • TypeScript
  • Vite
  • Tailwind
  • Recharts
8 screenssingle-page app
₦2.888Bgrounding sales figure
Mock datano live POS feed
Public homepage of the church website with a plum and gold design and a Plan your visit button
Live public site
Full-stack · Auth, roles & realtime

Church Website & Presence Platform

A Next.js 16 and Supabase platform for a church in Hull: a public visitor website, sign-in for members, role-scoped pastor, admin and media areas protected by row-level security, and a projector display updated in real time from the media dashboard.

  • Next.js 16
  • React 19
  • TypeScript
  • Supabase
  • Postgres RLS
  • Realtime
  • Vercel
33 testsauth, session and roles, passing
4 signed-in areasmember, pastor, admin, media
Realtimepresentation display
CV Analyzer Streamlit interface showing the evidence matrix
Completed & tested
Software · Applied AI (guarded)

CV Analyzer & Job Match Optimizer

Matches a CV against a real job description with a traceable evidence matrix and gap analysis. An optional AI phrasing layer is checked after the fact and rejected if it adds anything the CV cannot evidence.

  • Python
  • Streamlit
  • pdfplumber
  • reportlab
  • pytest
117 testspassing locally
CLI + webone shared engine
DOCX / PDFreport export
Olist delivery SLA analysis chart of late-delivery rates
Portfolio analysis
Data & BI · SQL Server

Olist Marketplace — Delivery SLA & Seller Sizing

Public Kaggle e-commerce data analysed in T-SQL and cross-checked in Python, with a recommendation targeted at the sellers driving late volume.

  • SQL Server
  • T-SQL
  • Python
  • Tableau
96,470delivered orders
6.77%late-delivery rate
44%of late orders >8 days
CloudDesk Power BI executive overview of support resolution times
Portfolio analysis
Data & BI · Statistics

CloudDesk — Support Root Cause

Hypotheses on documentation, reassignment, team and category tested against resolution time, CSAT and renewal.

  • Python
  • pandas
  • statsmodels
  • Power BI
2,400tickets
7.80 hmedian resolution
4.52average CSAT
Nigeria at 66 Power BI dashboard with KPI cards and a 1960 to 2025 trend
Completed analysis
Data & BI · API to Power BI

Nigeria at 66 — World Bank Data Story

World Bank API extraction in Python, pandas validation and a one-page Power BI story.

  • Python
  • requests
  • pandas
  • Power BI
7 × 4indicators × countries
1,848rows prepared
1960–2025coverage

Skills and where to verify them

Each skill below links to public work that shows it. Where source code is private or not linked, that is stated.

Skill-to-evidence map
SkillEvidence
SQL (SQL Server, T-SQL)Olist delivery SLA (sla.sql)
SQL (SQLite)E-commerce orders SQL analysis
Python (pandas)Restaurant financial intelligence · CloudDesk RCA · Olist cross-check
Statistics (regression, correlation)CloudDesk RCA
Power BIGrandStay · Restaurant financial intelligence · CloudDesk · Nigeria at 66
Excel and Power QueryGrandStay
TableauOlist delivery SLA · Daikibo (Deloitte job simulation on Forage)
React and TypeScriptControlDeck NG (live demo)
APIs (FastAPI) and system integrationEvent Travel Intelligence (live app) · Jobs API with Stripe payments (live API docs)
PostgreSQL and Stripe paymentsJobs API with Stripe payments (public code)
Next.js, PostgreSQL and PrismaBibiunique booking live demo (source code private)
Automated testingCV Analyzer (pytest) · Church platform (Node test runner) · Event Travel Intelligence tests
Next.js, Supabase and row-level securityChurch presence platform (live public site)
Realtime featuresChurch presence platform (Supabase Realtime presentation display)
REST API extraction (Python)Nigeria at 66 (fetch_world_bank.py)
Applied AI (guarded LLM integration)CV Analyzer (ai_phrasing.py)

More projects

Smaller builds, prototypes and earlier analyses. More repositories are on GitHub.

Bibiunique Booking

Next.js · TypeScript · Prisma · PostgreSQL · NextAuth · Resend

Appointment scheduling MVP for an independent makeup artist business: public pages and Book flow, an availability API, duplicate start-time prevention (unique Booking.startsAt), admin login to approve or cancel bookings and manage services, and confirmation emails.

MediaSuite (MediaDesk) prototype

React · TypeScript · Vite · Tailwind CSS

Interactive browser prototype for an all-in-one media production and church presentation workspace: media library, songs and lyrics, service planner and a preview-to-live projection flow. A proof of concept, not the final desktop application.

GreenTech Manufacturing Downtime Analysis

SQL Server · Power BI · Excel · Power Query · DAX

645 batches and 885 downtime events analysed; 56.3% batch delay rate, with Cleaning/Sanitation the leading cause (86 incidents).

E-commerce Orders — Cleaning, EDA & SQL

Python (pandas) · SQLite · matplotlib

The same 1,200-order dataset across cleaning, SQL analysis and explanatory charts: 41% of orders cancelled or returned, $519,674 of revenue not collected.

Daikibo Industrials — Deloitte job simulation

Forage · Tableau · Excel

Training simulation (Forage / Deloitte Australia), not employment. Factory device downtime analysis and a Tableau dashboard with factory-to-device drill-through. Completed August 2026.

DecodeLab — Order cleaning & EDA

Python · pandas

Cleaned 1,200 e-commerce orders (types, dates, coupon fill, total checks) and documented distribution and status findings.

RCCG Games Day Coordinator Portal

HTML · CSS · JavaScript

Lightweight client-side portal: enter a first name to see an assigned role for a games-day event. A front-end utility, not a full-stack application.