Tableau, LOD and SQL - Behind the scenes | sqlbelle
Tableau, LOD and SQL - Behind the scenes
Ever wondered what SQL statements a FIXED Level of Detail (LOD) expression generates?
In this video we will look under the hood and see what statements are passed by Tableau Desktop to SQL. The demo uses Microsoft SQL Server.
We go through 5 use cases, as identified in the chapters below.
Chapters
00:11 - Setup
02:15 - Use Case 1 - Just aggregate (grand total)
03:02 - Use Case 2 - Dimension and aggregate (subtotal)
03:40 - Use Case 3 - Just FIXED LOD grand total
04:49 - Use Case 4 - Dimension, aggregate and FIXED LOD grand total
06:45 - Use Case 5 - FIXED LOD grand total vs FIXED LOD subtotal
Additional Tutorials
Level Up Tableau
• Tableau - LEVEL UP your problem solvi...
Table Calculations
• Tableau Table Calculations Explained ...
Level of Detail (LOD) Expressions
• Tableau LOD (Level of Detail) Express...
Calculations Playlist
• Tableau Calculations? Follow this pla...
Sets and Set Actions
• Tableau Sets and Set Actions Comprehe...
Top 1-5 LOD Expressions
• Tableau Tutorial - Top 1-5 LOD Expres...
Dates
• Tableau Dates: Complete Introduction ...
Filters
• Tableau Filters - Comprehensive Tutor...
Sample Certification Exam Questions
• Tableau Certification Exam Tips / Han...
Watch video Tableau, LOD and SQL - Behind the scenes | sqlbelle online without registration, duration hours minute second in high quality. This video was added by user sqlbelle 05 March 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 9,403 once and liked it 280 people.