While the dashboard sheet shows information on several topics for a quick overview, the analysis sheet focuses on a single topic for data exploration.
We will create two new sheets: one for customer analysis, and the other for product analysis.
Each one will help us understand how the sales are performing.
For the customer analysis, we will create a Pareto analysis to find out who the most relevant customers are, with a share of 80% of our sales.
For the product analysis, we will create a scatter plot to find out how the average discount affects the sales performance.