Projects

Six projects from telecom, banking, business intelligence and agriculture. Each one shows the problem, what I did and what changed.

Segmenting 100,000 customers by credit risk

Clustering 100,000 bank customers into six risk profiles, plus a short list of outliers that need a manual review.

RK-meansDBSCAN
clusters.R

4G migration: converting 2.1M subscribers

Finding the subscribers most likely to upgrade, then reaching them by call, by SMS, or the moment they walked into 4G coverage.

SQLPythonSegmentation
campaign rules
IFDevice is 4G-capable
ANDInside 4G coverage zone
SEND VIA
OBDSMSLocation trigger
CONVERTED2.1M

From 3-day reports to real-time Power BI

Replacing a three-day manual reporting cycle with dashboards that marketing and executives can check for themselves.

Power BISQLData modelling
KPI overviewLive
CONVERSION
CAMPAIGNS
REVENUE
REFRESH
3 days → live

Smart Farming Insights for cocoa, cashew and coffee farmers

A Power BI dashboard that brings soil, weather and yield forecasts together for Ghanaian farmers and the people who support them.

Power BIExcelForecasting
smart_farming.pbixUSSD ready
CocoaCashewCoffee
SOIL
pH and moisture
WEATHER
Rainfall outlook
PREDICTEDACTUAL HARVEST

FarmChoice: predicting better harvests

Yield models that gave farmers plot-level advice and contributed to an estimated 15% bigger harvest on pilot farms.

Pythonscikit-learnPandas
yield_model.ipynb
BASELINEWITH RECOMMENDATIONS

Competitor, pricing & churn intelligence

Linking churn to competitor activity and price changes, then turning the findings into one-page recommendations.

SQLRPower BI
decision memo · 1 page
CompetitorPricingLifecycle
Churn drivers
Price moves
Engagement
Recommendation