Overview of Pivot Table Components for OLAP
A pivot table is a popular feature many can find in Microsoft Excel and use to interactively analyze the large mass of facts. The robustness of this analysis type allows many to extract trends and patterns that are located inside the data.
The pivot table allows you to organize and summarize this information, focus only on the most relevant data and extract the most meaningful business analysis facts.