Pivot Table

A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data.

A Pivot Table is one of the basic data analysis tools. Pivot Tables can quickly answer many important business questions.

One of the reasons we build Pivot Tables is to pass information. We would like to support our story with data that is easy to understand, easy to see.?

Although Pivot Tables are only tables and thus missing real visuals, they can still be considered as a?mean of Visual Storytelling.

A Pivot Table is used to summarise, sort, reorganise, group, count, total or average data stored in a?table. It allows us to transform columns into rows and rows into columns. It allows grouping by any field (column), and using advanced calculations on them.

More simple explanation is that a pivot table can:?

• group items/records/rows into categories
• count the number of items in each category,?
• sum the items value
• or compute average, find minimal or maximal value etc.