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

0

Desktop Version

0

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.

0

D. Key Components of a Pivot Table

0

E. Examples

0

0

0

0

F. Your Turn

Identify the grouping and aggregation terms in the following sentences.

What is the maximum weight recorded for each day?