LODs of Fun with Jedi Filters: Level Of Detail Calcs for Data Geeks
summary
Walks through concrete Tableau recipes using LOD expressions to solve real problems: detect customers with >6% discount by aggregating fixed LOD at customer even when only industry is shown; implement proportional brushing by fixing monthly totals and add to context so comparisons respect region filters; do market‑basket (paper co‑purchased with 102 binders = 11% of binder items) and path analysis (keeps connected edges so US→Afghanistan shows); replicate a company’s YoY growth across competitors using count distinct and warn about performance tradeoffs.
AI-written summary · about
chapters (13)
- 0:00Introduction
- 1:20Overview
- 2:30Guided Analysis
- 4:28Fake Data
- 7:41Proportional Brushing
- 10:20Proportional Filtering Example
- 12:55Market Basket Analysis Example
- 18:34Profit by Country Analysis Example
- 23:09Path Analysis Example
- 28:05Competitor Analysis Example
- 42:58Drill Down
- 48:19Dynamic Swap
- 49:20Summary
related talks
01h 01mEffective Data Visualization
48mData Visualization in Practice
01h 10mStorytelling through data
42mInteractive Data Analysis: Visualization and Beyond
32mData Viz for Engineers: Optimizing Insight & Decision Making Through Visualization
01h 38mEffective Data Visualization
49mVisualizing Data: the Good, the Bad, and the Ugly
25mTake your Power BI Reports to the Next Level