UX Techniques Supporting Varying Levels of Aggregation
summary
Aggregation choice flips conclusions: the same dataset shows 48 of 50 states example where more states’ averages fall yet the population-weighted average rises, and hospital waits read 8 vs 30 minutes depending on per-hospital or per-patient aggregation. Practical tactics include SQL window functions (OVER, PARTITION), data prep for D3, quick Excel prototyping, and metadata windows for moving seasons. ClearStory Data combines Spark + D3 + React into a web app that blends sources, scales to large sets, and keeps exploration interactive.
AI-written summary · about
chapters (6)
- 0:00Start
- 5:59Affordances for Visualization Types
- 11:26Vertical Drilling
- 15:10Curated "Drilling" Requires Users to Identify Categories
- 17:45Window Operators
- 18:39Data By The Bay Script Examples
related talks
48mData Visualization in Practice
01h 55mUse your data to tell stories
30mSeeing the needle AND the haystack: single-datapoint selection for billion-poin...
15mThe Future of Data Visualization on the Web
20mDesigning for Big Data
34mVisualising Multi Dimensional Data
38mAdd ALL the things: abstract algebra meets analytics
21mVisualising Enterprise Data with D3
