Business analysis glossary
Pivot Table
What it is
A pivot table is a spreadsheet feature that summarises large tables quickly by grouping rows and calculating totals, counts or averages, with the ability to drag fields into rows, columns, values and filters. It is available in Excel and Google Sheets.
Why it matters
Pivot tables let analysts explore data in minutes without writing code, for example complaints by category and month or sales by region and product. They are expected in almost every Indian BA job description that mentions Excel and are a fast way to test a hypothesis before building a dashboard.
Example
Given an export of ten thousand support tickets, the analyst builds a pivot table with category in rows, month in columns and count of tickets in values. It shows billing complaints doubled after the September price change, which becomes the first slide of her problem statement.