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...
Смотрите видео Tableau, LOD and SQL - Behind the scenes | sqlbelle онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь sqlbelle 05 Март 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 9,403 раз и оно понравилось 280 людям.