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.
4 freelancere byder i gennemsnit ₹3731 timen for dette job
I can assist you with Power BI report in a most qualitative way because I am Senior MS SQL/BI Developer with 10+ years of development experience.
I have worked on various power BI reports using product and order data. This project will not take me time as I already know how to write M language and DAX for the key metrics mentioned
HI Being a data aanalyst with 3 yeras of experince , i am capable of doing all your works which you have mentioned in the above Description. Hope we will come in contacat soon Best Regards Bhaskar.A.B