Pivot Tables - Davinia

 Pivot Tables - Davinia Brito 

A pivot table is a table typically created in Excel, used to quickly summarize and organize large datasets. It rearranges or pivots information by putting them into categories, rows, columns, values, and filters. Once you do this, you are able to calculate totals and averages without having to alter the original dataset. They are commonly used in charts in tables in order to spot trends, group information, and create clean reports.  

Above is an example of a set dataset along with its pivot table. In the example provided, the pivot table takes the individual sales records and groups them by Department, calculating their total sales for each group. This is helpful because instead of manually adding sales for Clothing, Electronics, and Home Goods, the pivot table automatically collects these values and shows that Electronics generated the highest sales, followed by Clothing and Home Goods. This makes it easier and helpful in order to rearrange throughout fields without changing the original set.