Visualizing disaggregated data with PivotCharts

Data Visualization in Excel

Agata Bak-Geerinck

Senior Data Analyst, Telenet

Aggregated vs. disaggregated data?

White space

Disaggregated data (individual blocks)

A visual of a heap of disarranged lego blocks

A visual of a table listing various individual lego blocks

White space

Aggregated data (counted by color and size)

A visual of a heap of disarranged lego blocks

A visual of a table listing aggregated counts of grouped lego block

Data Visualization in Excel

Aggregated vs. disaggregated data?

White space

Aggregated data

Examples of tables with aggregated data

  • Aggregated data = summarized data
  • e.g., sales per region, profit per product

White space

Disaggregated data

Examples of a table with disaggregated data

  • Disaggregated data = raw, unsummarized
  • Transactional data: one record = one event
Data Visualization in Excel

From tables and charts to PivotTables and PivotCharts

White space

Visualizing aggregated data

Examples of tables and charts when visualizing aggregated data

White space

Visualizing disaggregated data

Example of PivotTable and PivotChart

Data Visualization in Excel

Exploring large datasets efficiently

One dataset = easy data exploration

A picture explaining the connection between the PivotCharts and the underlying data

White space

  • No need for pre-aggregating data into individual tables
  • Single underlying dataset
  • Dynamic exploration and visualization
  • Easy rearranging of row and column series
  • Updates to the dataset result in updating all pivot tables and charts
  • "Once source of truth"
Data Visualization in Excel

Enabling interactivity and building (mini) dashboards

Example of a small dashboard built in excel, incl. timeline and slicer filters

Data Visualization in Excel

How to print in Excel?

White space

  • Useful for capturing insights for meetings or sharing information with senior staff

  • Many settings to choose from:

    • Print areas
    • Page layouts
    • Scaling, margins, and orientation

  • Always consider the environment before printing!

Printing of 50 pages and a scared emoticon

Print settings in Excel

Data Visualization in Excel

Let's practice!

Data Visualization in Excel

Preparing Video For Download...