Lamar Miller

In our text, we learn that pivot tables are a great tool that allow us to see the relevant data within a flat file or summary table. A summary table is where your raw data are aggregated so you can build a graph.
A flat file has each piece of data on its own line. Here, you will find a site that explains use cases for pivot tables as well as what they can do to help us export and visualize data.

Some elements of a pivot table include values, rows, columns and filters.

Pivot tables can help with various real-world examples such as sales volume by country. This data can be aggregated in a way where it is simplified down to the relevant data when telling a data story. This data can be sorted by country, year, quarter and dollar amount. This is useful when presenting to clients at your job or helping analyze trends for your own business.

After editing your data to your liking, you will be able to create the example above. This example depicts multiple categories of data which have been aggregated to include sub-categories, timelines and financials.