Role: CSRAnalyst - CSR
Data Location: Case Study - Data and Analytics
Submission Time: Within 7 days
14-02-2022
Customer ID: Unique ID per customer
Session ID: Unique ID per sessions
Login ID: Assigned on customer login
Platform ID: platform of session i.e android, iOS, mweb,dweb
Duration: Duration of every session
Transaction ID: Unique ID Data captured on successful transaction on Web and app
Order ID: Unique ID for every order entering operational system
Funnel Level: Depth of funnel reached by a user in a session
Value: Order value is denominated in integers at the lowest unit. e.g. 5000 GBP => 50 GBP (because the lowest unit in GBP is a penny, w/ 100 pence = 1 GBP) currency_details.csv a table with iso codes and exponents for currencies
- exponent column can be used to convert the integer amounts in the transactions table into cash amounts. (e.g for 5000 GBP, exponent = 2, so we apply: 5000/(10^2) = 50 GBP
Above dataset is generated by an online food delivery business ‘Kaboom’ spread across multiple countries. Please help us understand more about the business in general from the following questions. Please focus on the logical explanation of your answer. You can use any tool of your choice to load/unload/query/analyze/visualize the data. Please present your findings within 8 slides (including title) and share the code within 7 day of receiving the case study.
Questions
- Provide an exploratory analysis of the dataset answering the following
- Define consumers who have the highest intent of purchase and which is the most cost effective channel to target them?
- What is the overall health of business and why? Which country contributes most to the bottomline and why?
- Which cities provide an opportunity for Kaboom?
- Kaboom wants to drive sustainability across the markets they operate in. Based on the current datasets, can you think of any KPIs to focus on. What additional data points would you add to the datasets and why (choose the top-3).