Creating the analysis sheets

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. 

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset