Phemelocodemode/Mukuru-Case-Study

End-to-end remittance data analysis for a leading African fintech — SQL, Python, Excel and Power BI across 568K+ transactions covering paid order trends, customer retention and data quality validation. # Mukuru Remittance Analysis — Data Analytics Case Study ## Overview End-to-end data analysis of a fintech remittance dataset spanning 13 months (April 2012 to April 2013). The analysis covers paid order volume trends, customer retention metrics and data quality validation across Mukuru's Southern African remittance corridors. The project was completed as a technical assessment for a Data Analytics Intern role at Mukuru, a leading African fintech company specialising in international and domestic money transfers. --- ## Business Context Mukuru's core business is remittances — helping customers move money across Africa, primarily from South Africa to Zimbabwe, Malawi, Zambia and other Southern African countries. This analysis answers two key business questions: - **Commercial Team:** How are paid order volumes trending month on month and year on year? - **Customer Journey Team:** How large is the active customer base and how many customers are returning senders each month? --- ## Dataset The dataset consists of 568,638 remittance orders across 6 related tables: | Table | Description | |---|---| | Orders | Core transaction table — one row per order | | Users | Customer master table — one row per customer | | Country | Country dimension — maps CountryKey to country name | | Currency | Currency dimension — maps CurrencyKey to currency | | CustomerAcquisitionCosts | CAC by brand, year and channel | | PayInPartnerCommercials | PayIn partner rate information | **Note:** Raw datasets are not included in this repository as they contain proprietary business data. The SQL scripts, analysis workings and findings report are included as the analytical deliverables. --- ## Project Structure ``` mukuru-remittance-analysis/ │ ├── README.md │ ├── sql/ │ └── mukuru_analysis.sql # All SQL queries for Q1 and Q2 │ ├── excel/ │ └── Mukuru_Excel_Workings.xlsx # Calculation workings with live formulas │ ├── report/ │ └── Mukuru_Analysis_Report.docx # Fu …