Creating a basic power pivot and PivotChart
Using dashboards, we can see the data in a visual representation instead of just the figures. This sometimes makes it easier to spot trends and analyze data.
Many times, you will be given data from another person or you will have something that came from an exported CSV file that you need to create reports on. In this first section, we are going to look at pivot tables and PivotCharts and how we can create them.
To start, we are going to create a basic pivot table and a PivotChart to see how this is done. We are going to use our sales data, which shows what has been sold, to whom, and the sales representative who sold it. Refer to the following screenshot:
We are going to create a pivot table and chart of the salespeople and how much they have sold.
Note
If you are already familiar with how to create these items, then skip to the next section.
Let's see how...