Question 1: Which company had the highest revenue?

Hint: Use a Column chart. Use Revenue as a Measure and Company as a Dimension. Sort Revenue from low to high.

Question 2: Display the trend of revenue over years for each company.

Hint: Use a Line Chart. Use Revenue as Measure and Year as Dimension. Then add Company as (color) Dimension. Optional: You can focus on only one or two teams.

Question 3: What is the market share of each company by product? Note: you do NOT need to type in the information; just show the chart

Hint: Use a Stacked Bar chart. Revenue (from Measures). Product from Dimensions, the Company (color) from Dimensions.

Question 4: Are there any products that don't sell in specific distribution channels?

Hint: Use a Heat Map. Distribution Channel and Product as Dimensions, and Revenue (color) from Measures

data link here https://docs.google.com/spreadsheets/d/11TbynesCkp3nzf2AfyDOcAIDDtw9mwiF/edit?usp=sharing&ouid=112383055646796696727&rtpof=true&sd=true