SELF-GUIDED BA PRACTICE Packages available · Access after confirmed paymentSee packages ↗

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.

Used in these guides

CHECK BEFORE CONTINUING

Keep your work safe