Pivot Tables
A. What Is a Pivot Table?
It is an approach to summarize data in order to highlight trends and insights.
B. Where to Start a Pivot Table?
Online Version

Desktop Version

C. Think of Each Column (Variable) in Your Dataset as a Poker Chip
Each variable is an independent unit of information. When you build a pivot table, you place these chips on the board (rows, columns, values, or filters). Each chip you spend represents one variable being used to organize or summarize the data.

D. Key Components of a Pivot Table

E. Examples




F. Your Turn
Identify the grouping and aggregation terms in the following sentences.
What is the maximum weight recorded for each day?