pivot tables
Data aggregation grids
A pivot table is a data analysis tool in spreadsheet software that summarizes large datasets by reorganizing and aggregating information.
Users can "pivot" data—rotating rows into columns or vice versa—to reveal patterns and relationships: The pivot table showed sales by region and quarter.
The name comes from the ability to rotate the data's orientation while preserving its relationships.
Microsoft's data-crunching application
- Google SheetsCloud spreadsheet application
- cellsBasic biological units
- rowsSide-by-side sequences
- columnsUpright structural shafts
fields · values · drag-and-drop · slicers · formatting · layout · interactivity · workbook
Tool that divides thinly
- filterPorous separation device
- criteriaStandards for judgment
- excludeBar from participation
- selectCarefully pick from options
segment · isolate · narrow · drill-down · hierarchy · expand · collapse · hide
Combined collection of items
- totalsFinal sums computed
- averagesCentral tendency measures
- countsTotals or matters
- sumsAddition results
percentages · subtotals · grand totals · consolidation · rollup · cross-tabulation · breakdown · grouping
Prevailing directions of change
- varianceSpread around the mean
- comparisonAssessment of similarities
- metricsStandards for assessment
- insightsPenetrating understandings gained
patterns · outliers · correlation · anomalies · benchmarking · year-over-year · distribution · ranking
Excel
Microsoft's data-crunching application
- Google SheetsCloud spreadsheet application
- cellsBasic biological units
- rowsSide-by-side sequences
columns · fields · values · drag-and-drop · slicers · formatting · layout · interactivity · workbook · data source
slicer
Tool that divides thinly
select · segment · isolate · narrow · drill-down · hierarchy · expand · collapse · hide · timeline
aggregation
Combined collection of items
sums · percentages · subtotals · grand totals · consolidation · rollup · cross-tabulation · breakdown · grouping · statistics
trends
Prevailing directions of change
- varianceSpread around the mean
- comparisonAssessment of similarities
- metricsStandards for assessment
insights · patterns · outliers · correlation · anomalies · benchmarking · year-over-year · distribution · ranking · performance
- Office SoftwareMicrosoft Office, LibreOffice, OpenOffice, spreadsheet, word processor
- data analysisstatistics, analysis, analytics, conclusions, mean
- spreadsheetscell, cells, column, columns, row
- tabulationstables, tallies, tallying, tabulating, totals
- cutting thingschopping, mincing, julienne, chiffonade, cubing
- analyticsanalytics, metrics, dashboards, KPI, dashboard