Based on the data provided (USA.xlsx), provide executive team with visualized data to help them with decision-making
Based on the data provided (USA.xlsx), provide executive team with visualized data to help them with decision-making
-
Identify Key measures and provide aggregate values for each of them
-
Create and calculate profitability KPI; show the contribution of each product line for the generated profit
-
Identify the profitability of the company across different states of the country; are they above the benchmark?
-
How is each product line performing in terms of the sales?
-
Find the products that are high in sales quantity and profitable to the company
-
Compare all the products based on profitability KPI and the number of quantities sold by the company
-
Find the product that provides high profit amount irrespective of profit ratio
DETAILED ASSIGNMENT