Before we begin creating the dashboard, we need to review the information that is required by the business. The case study that we will address is as follows.
Suppose that the company is a worldwide wholesale seller of food and beverages. This means that they need to review information about the sales in several countries. They need to know their performance in each of them, and they require this information to be detailed by the customer name, category name, and product name. They also need to know the average percentage of discounts, how many orders they have issued, and the total sales amount. Each of these key indicators should be dictated by the month and year.
That explains the basis for this case. We need to find the perfect solution by accessing the right dashboard and displaying all of the data in the most consolidated fashion. Let's...