LET'S CONNECT
https://sqlbelle.ck.page
#tableau #analytics #lod #calculation
Practice Questions and other digital products
https://sqlbelle.gumroad.com
This is the first of a series covering the Top 15 Level of Detail (LOD) Examples, based on the Tableau Whitepaper written by Bethany Lyons.
Each use case is explained in detail, with additional discussion on how LODs compare against regular calculated fields and table calculations, and things to watch out for. Some examples will use combinations of these types of calculations.
A variety of other topics and tidbits/tips and tricks will also be covered - applications of blue vs green, creating bins, drop field window, and many more
Sections:
0:00 - Intro
1:36 - Use Case #1: Customer Order Frequency
8:14 - Use Case #2: Cohort Analysis
13:38 - Use Case #3: Daily Profit KPI
21:33 - Use Case #4: Percent of Total
27:44 - Use Case #5: New Customer Acquisition
31:27 - Preview of Part 2 of LOD Examples series
Accompanying Workbook to this Video:
https://public.tableau.com/app/profile/sqlbelle/viz/sqlbelle-Top1-5LODExpressions-Finished/Intro#1
Whitepaper: Top 15 LOD Expressions (Practical Examples)
https://www.tableau.com/about/blog/LOD-expressions
Need an LOD Refresher? Here is a complete and comprehensive tutorial
https://youtu.be/yush1yNz9VM
LOD Series:
Part 1 - Top 1-5 LOD Expressions - Practical Examples
https://youtu.be/j6j_Lxx3ndM
Part 2 - Top 6-10 LOD Expressions - Practical Examples
https://youtu.be/QV4PHxnOsZI
Additional Related Videos:
Tableau Calculations Series in sqlbelle channel:
Part 1 - Basic and Aggregate Calculations
https://youtu.be/QimVQl5AoYM
Part 2 - Level of Detail Expressions - FIXED, INCLUDE, EXCLUDE - Complete Tutorial
https://youtu.be/yush1yNz9VM
Part 3 - Table Calculations
https://youtu.be/3_DeQdE25Bc
10 Tableau tricks you should know
https://www.youtube.com/watch?v=AqnQgGJ3VX0
10 Use Cases for Parameters
https://www.youtube.com/watch?v=0Uar_D57QhU