Getting started with PivotTables

In this exercise, you will create your first PivotTable to help you explore the data.

To follow along with all exercises on your local computer, you can find all the course material here.

PivotTables are a great way to start exploratory data analysis. They can easily summarize and manipulate data, which makes them a powerful tool. It's also important to make sure everything we do is concise and accurate, so we'll use best practices in naming our fields and formatting the data correctly.

Let's create a PivotTable of Bananas Sales.xlsx to get a better understanding of the data as a whole.