rwahito/African-Gig-Economy-Digital-Wallet-Data-Challenge-

As a data analyst, the aim of the project is to uncover the patterns and trends within the African gig economy. As well as identify any fraudulent activities through the analysis # African Gig Economy & Digital Wallet Report **Analysis Period: 2023–2024** --- ## Executive Summary Africa loses an estimated **$4 billion annually to scams and cyber fraud**. Within the four markets covered in this dataset, Kenya has also experienced significant digital-fraud exposure. According to *Eastleigh Voice*, **2.3% of transaction attempts involving Kenyan consumers in 2025 were suspected of digital fraud**, below the global average of 3.8% but the second-highest rate among the African countries analyzed, behind South Africa. For the period **2023–2024**, this analysis examines transactions conducted through different channels and the workers operating across four African markets. The analysis focuses on: - Transaction performance - Fraud exposure - Market performance - Channel performance - Worker risk --- ## Dataset Structure To download the dataset as well as the project guiding details Click here The dataset contains: - **4 Dimension Tables** - Channel - Market - Dates - Workers - **1 Fact Table** - Transaction History ### Tables | Table | Description | |---|---| | **Channel** | Contains the different channels and sub-channels through which transactions were made | | **Market** | Contains the four markets covered in the dataset | | **Dates** | Contains the dates and periods covered by the transaction data | | **Workers** | Contains worker information including gig segment, risk score, demographics, and activity status | | **Transaction History** | Contains all transactions recorded during the analysis period | --- # Project Objectives ## Transactions 1. Determine: - Total amount transacted - Fraudulent transactions - Total transactions - Fraud loss - YoY change 2. Identify which markets recorded the highest transaction activity. 3. Identify which channels recorded the highest transaction activity. 4. Analyze the monthly transaction trend. ## Risks 1. Determine the average worker risk score. 2. Analyze risk scores by market. 3. Analyz …