Pivot Table

From CSUMB Data Glossary
Jump to: navigation, search

Pivot Tables are a data summarization tool, enabling you to "pivot" or rotate data and allowing you to look at data from different perspectives and to see a variety of patterns which may not be immediately obvious.

You can use Pivot Tables to automatically sort, group, and total data. You can also choose columns to include or exclude from a Pivot Table or move columns to rows or rows to columns.

Metadata
Where Term Appears
CSUMB Data Warehouse Dashboards:Various
Data Custodian
Institutional Assessment and Research
Data Source
Source Table Name:N/A
Source Field Name:N/A
Census Process:N/A
Logical Transformation / Calculation
N/A
OBIEE Folder and Column
Folder Heading:N/A
Column Heading:N/A


Definition Source

"One of the nice features of OBIEE is being able to view your data from various angles. Pivot tables make it easy to process and summarize large data sets in seconds. Pivot tables are a data summarization tool, enabling you to 'pivot' or rotate data, looking at it from different perspectives and seeing a variety of patterns which may not be immediately obvious. You can then automatically sort, count, total or give the average of the data."[1]

References