Report on Excel
₹600-1500 INR
Paid on delivery
Please check the case study below and submit the required documents with next 8 hours.
Case Study:
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.
Output:
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
Dear client, I am writing to propose my services as a Data Entry Operator at FIVERR. With 3 years of experience, strong attention to detail, and efficient data management skills, I can contribute significantly to your More
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 have a very high typing speed within less time and with high accuracy. Also has experience of entering data and various projects. I also have a good communication skills and flexible with time. Which makes me better More
Hi there! I am Maryam, a freelancer copy-paster and data entry specialist. I have the necessary expertise and experience to complete this project - specifically in data entry and extraction, PDF files, attention to det More
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.
Hi, Sir I am collage student but i will give you better results in this project . I really want to work with you . This is my first project . I don't believe in qualification only believe in work Thank you s More
I am a new freelancer and I need job. I have great experience in MS Excel, MS Word and Data Entry............................................................
Thousands of courses authored by our network of industry experts. Master the skills to drive your career. Cloud Labs. Certification Prep. Role IQ. Skill Assessments. Offline Access. Expert-Led Courses. Mobile Apps. Han More
Hello, my name is Freelancer Saikat. I love happy clients and my profile reflects this. My ability to adapt and learn quickly has allowed my clients to label me as “low maintenance for high results”, coupled with 5 yea More
Dear Hiring Manager, Hope you are fine and happy with your life. Before I start my letter I want to thank you for posting the job. In your job posting you are looking for a Data entry expert who knows every basic of da More
