High profit amount irrespective of profit ratio
Based on the data provided in D2L (USA.xlsx), provide executive team with visualized data to
help them with decision-making. [Please submit the link of your tableau dashboard not the
complete tableau file. Please review the lecture video on how to create this link.]
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