Question: Executive Overview 1. Identify Key measures and provide aggregate values for each of them 2. Create and calculate profitability KPI; show the contribution of each
Executive Overview 1. Identify Key measures and provide aggregate values for each of them
2. Create and calculate profitability KPI; show the contribution of each product line for the generated profit
3. Identify the profitability of the company across different states of the country; are they above the benchmark?
4. How is each product line performing in terms of the sales? Profitable Products: Find the most profitable products sold by the organization
5. Find the products that are high in sales quantity and profitable to the company
6. Compare all the products based on profitability KPI and the number of quantities sold by the company
7. Find the product that provides high profit amount irrespective of profit ratio Target Market/Customers Using the most profitable products data, identify target customer profiles/market using the attributes available to us about the customers
8. Marital Status
9. Gender
10. Age group/generation, and
11. Commute distance
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
