Need an analysis in Excel and Visualization case study
Budget: ₹600 – ₹1,500 INR
Prepare analysis on the Orders Data and Customer Data while touching upon monthly revenues, users, monthly revenue per user etc
Prepare an analysis showing how many users placed a Purchase order, while how many actually converted bifurcated by
Month
Customer Profession
Prepare a COHORT analysis showing the purchase pattern of users by month
Cohort Analysis: Cohort analysis is a type of analysis where we understand the behavior of customers by groups over a period of time. Eg. How are the customers who joined in the month of Jan 2021 are performing in the coming months in terms of # of orders placed, # of purchases made etc
See example Cohort Analysis table
Prepare an analysis showing how many users placed a Purchase order, while how many actually converted bifurcated by
Month
Customer Profession
Prepare a COHORT analysis showing the purchase pattern of users by month
Cohort Analysis: Cohort analysis is a type of analysis where we understand the behavior of customers by groups over a period of time. Eg. How are the customers who joined in the month of Jan 2021 are performing in the coming months in terms of # of orders placed, # of purchases made etc
See example Cohort Analysis table