Data Analyst and Power-BI Expert Need!
Budget: ₹600 – ₹800 INR
Analyse the data set. Use "User Profile" and "User_Order_Number" sheet for data metarials as per your need!
Answer the following questions:
1. Make a cohort, based on the User order pattern and behaviour pattern to find the answers for the follow questions
Questions Analyze the following data in google sheet
1 How many successful orders are there?
2 How Many users repeated their order
3 Make a Subtotal in upper cell.
4 % of Repeat user year on year
5 % of churn users year on year
6 In which category do users invest most?
7 what are the cancellation rate of the users?
8 Monthly how many unique users are ordering?
9 Users average ticket size of investment
10 Users average Interest rate they invest in?
11 Which is the most demanding contract period for the users?
12 What are the most demanding farm for the user?
Create a chart through Power BI/Tableau any other visualization tool (your preference), how you want to visualize it.
Sort the User_order_data using Python to find the difference between the different customer type
Answer the following questions:
1. Make a cohort, based on the User order pattern and behaviour pattern to find the answers for the follow questions
Questions Analyze the following data in google sheet
1 How many successful orders are there?
2 How Many users repeated their order
3 Make a Subtotal in upper cell.
4 % of Repeat user year on year
5 % of churn users year on year
6 In which category do users invest most?
7 what are the cancellation rate of the users?
8 Monthly how many unique users are ordering?
9 Users average ticket size of investment
10 Users average Interest rate they invest in?
11 Which is the most demanding contract period for the users?
12 What are the most demanding farm for the user?
Create a chart through Power BI/Tableau any other visualization tool (your preference), how you want to visualize it.
Sort the User_order_data using Python to find the difference between the different customer type