A pivot table is a powerful statistical tool that allows you to summarise or aggregate smaller sets of data based on an extensive database. It helps you analyze new relationships and connections between data sets by giving you a more focused view of the database. It also allows you to shift (pivot) the table's axis and see the details of your data from a different angle.