Pivot Table
Pivot table is a data analysis tool that summarizes, organizes, and reorganizes large datasets to reveal patterns and insights by automatically grouping and aggregating selected values.
- displays of data that are shown in a table format
- can range in complexity depending on the analysis
- allow us to visualize groups within groups
- putting data into a pivot table unlocks the ability to visualize this data in a pivot chart
Example Pivot Table
- displays data by two categories at a cross section
- Associates Degree, or the education, is the row, and the Education Type is the column
- pivot gives us a grouping of the degrees and then creates the two additional groups that are not associated with a degree
- grouping allows us to see degree, high school, and some college, so a little higher-level category of the data
