Which tool is used to summarize data by categories and measures?

• A. Data Dictionary
• B. Pivot Table
• C. Data Warehouse
• D. Data Pipeline

Answer: (D)

Pivot tables are designed to summarize large data sets by organizing data into categories and computing aggregate measures. You can set one field as a row category, another as a column category, and a numeric field as the value to summarize (using sums, averages, counts, etc.). This creates a cross-tabulated view that makes it easy to compare totals and statistics across different groupings, such as by product, region, or time period.

The other options don’t provide this built-in, interactive summarization capability: a Data Dictionary describes metadata about data elements, a Data Warehouse is a storage system for integrating data from multiple sources, and a Data Pipeline moves data between systems.