Choose Index below for a list of all words and phrases defined in this glossary.

Pivot Table

index | Index

Pivot Table - definition(s)

Pivot Table - To 'pivot' is to '˜slice-and-dice' your data to get different views of the same data. A pivot table usually refers to a tool that lets you look at your data in different ways to obtain a desired report. Specifically it allows you to reorganize and summarize selected columns and rows of data in your database tables without changing the data that is actually contained in the tables. Refer Slice and Dice for more information.

[Category=Business Intelligence ]

Source: ElegantJ BI Business Intelligence, 03 November 2012 10:01:02, External 

These advertisers support this free service

pivot table - A pivot table is a program tool that allows you to reorganize and summarize selected columns and rows of data in a spreadsheet or database table to obtain a desired report. A pivot table doesn't actually change the spreadsheet or database itself. In database lingo, to pivot is to turn the data (see slice and dice) to view it from different perspectives.

A pivot table is especially useful with large amounts of data. For example, a store owner might list monthly sales totals for a large number of merchandise items in an Excel spreadsheet. If the owner wanted to know which items sold better in a particular financial quarter, it would be very time-consuming for her to look through pages and pages of figures to find the information. A pivot table would allow the owner to quickly reorganize the data and create a summary for each item for the quarter in question.

Related glossary terms: Universal Data Access (UDA), hybrid online analytical processing (HOLAP or Hybrid OLAP), geographic information system (GIS), DSTP (Data Space Transfer Protocol), multidimensional online analytical processing (MOLAP), FileMaker (FMP), meta, data mining, data warehouse / database warehouse, data preprocessing

[Category=Data Management ]

Source:, 31 August 2013 09:09:37, External  



Data Quality Glossary.  A free resource from GRC Data Intelligence. For comments, questions or feedback: