Analysis overview and configuration
| Parameter | Value | _row |
|---|---|---|
| aggregation_function | sum | aggregation_function |
| top_n | 10 | top_n |
| significance_level | 0.05 | significance_level |
| time_granularity | monthly | time_granularity |
| pareto_threshold | 80 | pareto_threshold |
| min_group_size | 2 | min_group_size |
This pivot summary analysis organizes 9,994 transactional records across three product categories (Technology, Furniture, Office Supplies) and four geographic regions to identify which groups drive the largest value contributions. The analysis reveals distribution patterns, hierarchical breakdowns, and temporal trends to support strategic resource allocation decisions.
The data exhibits moderate concentration rather than extreme skew. While Technology leads in absolute value, the 36.4%–31.3% spread across categories suggests no single group dominates decisively. The cross-tabulation reveals regional performance disparities, with East consistently outperforming South. Monthly aggregations indicate stable demand with seasonal fluctuations,
Data preprocessing and column mapping
| Metric | Value |
|---|---|
| Initial Rows | 9,994 |
| Final Rows | 9,994 |
| Rows Removed | 0 |
| Retention Rate | 100% |
This section documents the data preprocessing pipeline for the pivot analysis covering 9,994 transactional records across three product categories (Technology, Furniture, Office Supplies). Data quality and retention rates directly impact the reliability of the aggregations, group comparisons, and Pareto analysis presented in the overall summary.
The 100% retention rate indicates that no data cleaning transformations were necessary, suggesting the source data met quality standards for the pivot summarization objective. This complete preservation is critical because the analysis relies on accurate group counts and sums—any row removal would have skewed the Pareto principle findings (all 3 groups account for 80% of total) and the regional cross-tabulation distributions. The absence of filtering decisions simplifies interpretation: reported metrics reflect the raw data without adjustment
| category | finding | impact |
|---|---|---|
| Dataset | Analyzed 9994 records across 3 groups. Total sum: 2,297,201 | Info |
| Top Group | Technology leads with 836,154 (sum of total: 36.4%) | High |
| Pareto | 3 of 3 groups account for 80% of total sum (Pareto principle) | High |
| Cross-Tab | Pivot covers 3 x 4 = 12 group combinations (Category x Region) | Info |
| Hierarchy | Treemap shows 17 sub-groups nested within 3 parent groups | Info |
| Spread | Top group is 1.2x larger than bottom group (high concentration = uneven distribution) | Medium |
This analysis synthesizes a pivot table summarization of 9,994 transactional records across three product categories and four geographic regions. The findings reveal how value concentration and distribution patterns across groups can inform resource allocation and performance monitoring strategies.
The data demonstrates relatively balanced value contribution across product categories, with Technology holding a modest 5.1 percentage-point advantage over the lowest performer. The absence of a dominant 80/20 pattern indicates that all three groups merit sustained attention rather than concentrated focus
Descriptive statistics for each group including count, sum, mean, median, min, max, and standard deviation
This section provides foundational group-level statistics that decompose the total aggregated value (2.3M) across three product categories. It establishes the baseline performance metrics—count, sum, mean, median, and variability—for each group, enabling comparison of both volume and value characteristics across the portfolio.
The three groups exhibit distinct operational profiles: Technology generates premium value through fewer, higher-value transactions; Furniture maintains moderate volume and value; Office Supplies drives transaction count but with lower per-unit economics. The near-alignment of mean and median group totals indicates no single outlier category distorts the overall portfolio, reflecting a balanced business model across product lines.
Pivot table showing the primary measure aggregated by row and column dimensions
This pivot table cross-tabulates three product categories (Furniture, Office Supplies, Technology) against four geographic regions (Central, East, South, West), revealing how value is distributed across 12 category-region combinations. This matrix enables identification of high-performing and underperforming intersections, supporting targeted business analysis by geography and product line.
The pivot reveals that Technology performs strongest in the East region, while Furniture underperforms in the South. Office Supplies shows high transaction volume (1,712 records in East) but moderate value generation ($205,516), suggesting lower average transaction size. The relatively symmetric distribution (low skew) indicates no extreme outliers, though regional performance varies meaningfully by category.
This cross-tabulation compl
Hierarchical treemap showing parent groups and sub-groups sized by the primary measure
This treemap hierarchy decomposes the three main product categories into 17 sub-groups, revealing granular contribution patterns within each parent group. By sizing rectangles proportionally to their aggregated values, it enables rapid visual identification of which specific product lines drive revenue and volume, supporting deeper category-level performance analysis.
The hierarchy reveals that while the three parent categories are relatively balanced (31–36% each), their internal structures differ significantly. Technology and Furniture show concentration risk with dominant sub-groups, whereas Office Supplies distributes value across more sub-categories. This suggests different market dynamics: Technology and Furniture may be
Groups ranked from highest to lowest by aggregated value with percentage of total
This section ranks all three product categories by their total aggregated value to identify which groups contribute most to overall business performance. Understanding the hierarchy of value drivers is essential for resource allocation, inventory management, and strategic focus within the pivot analysis.
The three-way split reveals a fairly equitable value distribution across product categories, with Technology maintaining a modest 5% advantage over Furniture and 5.1% over Office Supplies. This near-parity suggests that all three categories are strategically important and contribute meaningfully to the $2.3M total. The 1.2x ratio between top and bottom groups indicates moderate concentration rather than heavy skew.
Full cross-tabulation matrix showing record counts and aggregated sums for every combination of row and column groups
This cross-tabulation matrix maps all 12 intersections of product categories (Furniture, Office Supplies, Technology) and regions (Central, East, South, West), showing both transaction volume and revenue value. It reveals whether high-volume segments also generate high revenue, or if value concentration differs from transaction distribution.
The cross-tabulation reveals that transaction volume does not perfectly predict revenue value. Technology products generate disproportionately high revenue per transaction in the East region, while Office Supplies achieves revenue through transaction volume rather than unit value. This suggests different market
Time-based aggregation showing how the primary measure evolves over time periods for each group
This section tracks how each product category (Furniture, Office Supplies, Technology) performs across 48 months (2014–2017) at monthly granularity. Understanding temporal trends reveals whether growth is consistent, seasonal, or cyclical—critical for inventory planning, demand forecasting, and identifying which categories are gaining or losing market momentum over time.
The 48-month timeline reveals that all three groups maintain consistent monthly reporting, but with pronounced variation in both transaction volume and aggregated value. The positive skew (0.92) in aggregated values indicates a right-tailed distribution—most
Pareto (80/20) analysis showing cumulative contribution of each group to the total
This section applies the Pareto principle to identify which groups drive the majority of total value. It reveals whether value concentration follows the classic 80/20 pattern or is more evenly distributed, helping prioritize resource allocation and strategic focus across product categories.
Unlike typical Pareto distributions where 20% of items generate 80% of value, this dataset exhibits relatively uniform value distribution across all three product categories. Each group independently contributes roughly one-third of total revenue ($719K–$836K range), with Technology holding a modest 5% advantage over the lowest performer. This balanced portfolio structure indicates diversified revenue streams without dangerous dependency on any single category.
The analysis covers 9,994 records aggregated across 48 monthly