oawoyade/African-Digital-Wallet-Ecosystem-Dashboard

The DataDNA African Digital Wallet Ecosystem Dashboard was developed as a comprehensive business intelligence solution designed to analyse transaction performance, fraud exposure, gig-worker behaviour, customer risk and operational efficiency across a digital-wallet ecosystem in Nigeria, Kenya, Ghana and South Africa. # 🌍 DataDNA Challenge — African Digital Wallet Ecosystem ## 📌 Project Overview The **African Digital Wallet Ecosystem Dashboard** was developed as a comprehensive Power BI solution to analyse transaction performance, fraud exposure, gig-worker behaviour, customer risk and operational efficiency across **Nigeria, Kenya, Ghana and South Africa**. The project transforms **50,000 wallet transactions** into a structured four-page analytical dashboard covering: - Transaction activity - Fraud and financial exposure - Gig-worker and customer risk - Operational performance - Payment-channel behaviour - KYC verification - Transaction outcomes - Emerging risk patterns The dashboard was designed to move beyond basic reporting and provide a clearer understanding of how transaction behaviour, customer characteristics, geography and operational performance interact across the digital-wallet ecosystem. --- ## 🎯 Project Objectives The dashboard was built to answer key analytical questions such as: - How much transaction activity and value moves through the ecosystem? - Which payment channels have the highest fraud exposure? - How does fraud vary across countries and gig-worker segments? - Which customer characteristics are associated with higher risk? - How do KYC tiers compare in terms of fraud exposure? - Which transaction types experience elevated decline, timeout or pending rates? - How efficiently are wallet transactions processed? - Where do operational and emerging risks appear? --- ## 🧱 Data Model The solution was built using a **star-schema-style data model**. ### Fact Table `fact_transactions` Contains the main transaction-level data, including: - Transaction amount - Transaction value in USD - Channel ID - Market ID - Date ID - Fraud loss - Fraud flag - Dispute flag - Reversal flag ### Dimension Tables `dim_channel` Contains: - Channel ID - Channel type - Channel subtype - Digital-channel indicator - Internet requirement `dim_market` Contains: - Cou …