Edi-champion/orange-money-analysis

SQL analysis of mobile money transaction patterns across West Africa # Orange Money West Africa — Transaction Analysis ## What is this project? An analysis of 500 mobile money transactions across five West African countries where Orange Money operates. The goal is to answer a real business question Orange's leadership would actually care about, using SQL, and turn the results into recommendations, not just run queries for practice. ## Why this matters (the business case) Orange Money's revenue and growth depend on two things: how much money moves through the platform, and whether customers can reliably access it when they need to. Both are shaped by decisions leadership has to make with limited budget :where to put more agents, and which products to push in marketing and partnerships. Right now, those decisions risk being made on intuition or anecdote ("Senegal feels like our biggest market") rather than evidence. This analysis exists to replace that guesswork with numbers: which countries and transaction types are actually carrying the volume, where the platform is failing customers most often (a direct driver of churn and trust), and which customer segments are worth building dedicated products around. The stakes of getting this wrong: investing in agent expansion in a market that isn't actually driving volume wastes budget that could have grown a bigger market further. Ignoring a high-failure channel means customers keep hitting friction and may switch to a competitor like MTN Mobile Money or Wave. ## The business question Orange Money is deciding two things for 2026: 1. Which countries deserve more investment in their agent network (the physical/human network that lets customers deposit and withdraw cash) 2. Which transaction types and channels (Agent, USSD, Mobile App) to prioritize in product strategy This analysis uses transaction data to inform both decisions. ## The data `data/orange_money_transactions.csv` — 500 transactions across: - 5 countries: Senegal, Côte d'Ivoire, Mali, Guinea, Burkina Faso - 6 transacti …