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

20201002192904home_assignment_1_visualization.pdf

Powered by WordPress