Report on Excel
Paid on delivery
Please check the case study below and submit the required documents with next 8 hours.
Bulkpro is a company that specializes in procuring products (multiple categories) from local manufacturers in bulk and selling them via their website to other local purchasers (dealing in bulk quantity) throughout India.
Your dataset includes Product Data and Order Data for Bulkpro.
Product Data - This data file includes details of each product that is listed on the website including the product category, the website listing date, and the source channel through which the manufacturer has connected with Bulkpro to list the products on the website.
Order Data - This data file includes individual order details of different products that are listed on the website including order quantities, order date-time, etc. Each order is placed by an individual purchaser.
The Bulkpro management suggested the Data Analyst team figure out the reason for the decline of overall orders in the Platinum category placed (both in terms of the number of orders and in terms of daily product quantities ordered).
Use this data to analyze the performance of each channel/segment that can bring insights on the root cause of the problem and suggestions on key focus areas.
The Key Metrics to be looked at should be:
1. Monthly total order quantity
2. Daily total order quantity
3. Average Daily order quantity per product
4. New products onboarded (Monthly / Weekly / Daily)
5. Sales of new products onboarded (not every product that is listed on the website would actually be purchased)
Feel free to use different segments to understand the movements in key metrics. Also, define new metrics that would be useful in tracking business performance.
Assumption: Since product price has not been provided here, you can assume that each product is priced the same and that the profit margin on each product is also equal.
1. Share a detailed working file on all insights (Excel / Power Bi / etc.). Include pivots / charts / crosstabs / etc.
2. Create a doc/pdf file summarizing the analysis that can be shared with the management to update them regarding Key Learnings.
3. The Bulkpro management suggested the Data Analyst team figure out the reason for the decline of overall orders in the Platinum category placed (both in terms of the number of orders and in terms of daily product quantities ordered).
4. Use this data to analyze the performance of each channel/segment that can bring insights on the root cause of the problem and suggestions on key focus areas.
Hint: We can look at creating buckets of different products (with total sales of 10k units, 50k units, 1L units, and so on) - or any other segment that can be prepared from the dataset provided. Analyze these buckets independently and figure out if there is any significant reason behind the numbers falling across different months. There is no limit to the scope of analysis.
Project ID: #36703376
About the project
13 freelancers are bidding on average ₹912 for this job
Hello I'm a professional editor with excel I have 8 years of experience. I have done the work perfectly according to your requirements. Please contact with me. Looking forward to hear from you. Thanks
I can manage easily sales, order, products reports and I will make the excel sheets for all the details monthly, daily orders, etc. and Will send it you. Lets discuss more over chat.
I am a new freelancer and I need job. I have great experience in MS Excel, MS Word and Data Entry............................................................