Tableau, LOD and SQL - Behind the scenes | sqlbelle

Подписаться 127 тыс.

Просмотров 9 тыс.

50% 1

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 you...
Table Calculations
• Tableau Table Calculat...
Level of Detail (LOD) Expressions
• Tableau LOD (Level of ...
Calculations Playlist
• Tableau Calculations? ...
Sets and Set Actions
• Tableau Sets and Set A...
Top 1-5 LOD Expressions
• Tableau Tutorial - Top...
Dates
• Tableau Dates: Complet...
Filters
• Tableau Filters - Comp...
Sample Certification Exam Questions
• Tableau Certification ...

Опубликовано:

30 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 60

@TheDistractionStudio Год назад

If there is ever a Nobel Prize for Tableau - You absolutely deserve one. Love your content.

@sqlbelle Год назад

Thank you Rajan :)

@PatrickBateman12420 Год назад

Kind of from RU-vid: 27,300 subscribers prize!

@saidsaulo1 Год назад

I have been watching tons of Tableau videos across the years. This is part of top 5 best videos I have watched. Congratulations! So informative.

@sqlbelle Год назад

Thank you Saulo, I appreciate your note. I am glad to hear you found it helpful.

@swagatamchakraborty3352 Год назад

Very useful BTS video on Tableau's fixed LODs. Excellent content and keep posting more such videos on what happens under the hood for various Tableau operations!

@sqlbelle Год назад

Thank you Swagatam!

@mesumrazahemani3163 Год назад

Excellent, please do the same with Power BI too. I always thought Tableau might execute some window functions but instead it leverages basic methods of SQL, probably for hyper optimization. Also include difference in Relationship or Join

@sqlbelle Год назад

I agree! I thought I would see some window functions too. I havent quite explored INCLUDE/EXCLUDE yet, but my guess is those may be using correlated subqueries. We'll see :)

@brunoiungano7192 Год назад

Wonderfull!!!! Manu thanks!! Can you do it a similar video with LOD + dimension and context filters?? Thar would be really great!!!!!

@sqlbelle Год назад

Thank you Bruno! Yes hoping INCLUDE/EXCLUDE + context filters

@MrBasu-iq6md Год назад

Never thought of using Tableau this way. This tutorial shows a totally new approach to deal with data. This is a gem of a tutorial. Can't thank enough.

@piyushk3652 Год назад

Really amazing...I am speechless for your efforts and knowledge...👌👌👌👍🤝

@sqlbelle Год назад

Thank you Piyush!

@Slade69 Год назад

No other channel can match the level of detail you present in your videos. You have astounding level of dedication and it shows. Even though I am aware about SQLs , I would love to learn everything from scratch from you from beginning to advanced. I know I will be able to learn things which I had no idea about

@sambarajkanaveni7312 Год назад

Great effort is now being made to find this type of explanation; please continue to post videos.

@sqlbelle Год назад

Thank you Sambaraj!

@gritmanish 2 месяца назад

Thank you. At least 10 years working on Tableau and I have never seen anyone not even from Tableau marketing guys showing this detailed explanation.

@Aleks1246 Год назад

Hi, I was using Tableau Public version to proper name from Employee_Name aDINOLFI wILSONK aITSIDI kARTHIKEYAN aKINKUOLIE sARAH aLAGBE tRINA aNDERSON cAROL aNDERSON lINDA aNDREOLA cOLBY aTHWAL sAM bACHIOCHI lINDA to proper with format. I use formula UPPER(LEFT([First Name],1))+LOWER(RIGHT([First Name],LEN([Last Name])-1)). It did the job but it also cut short some of the names. I wonder what I did wrong. Thank you.

@pitou00 Год назад

unable to get 4th and 5th part :( . will come again tomorrow

@sqlbelle Год назад

Thank you Atul

@sathya2801 Год назад

Hey absolutely loving your content, 👍, also I would like to know if there is any way we can use table calculation function like window_sum, window_max etc or ATTR fn in our LOD Calculation??

@karcolom Год назад

Very informative! Looks like you need sysadmin fixed server role or ALTER TRACE permission. Not sure I’ll get that permission, oh well. Do you know if Snowflake has something similar?

@yunusteli8697 Год назад

Hi dona, when we catch up for a live session?

@sqlbelle Год назад

Thank you Yunus! I will try to schedule one in the next couple of weeks. I had issues with the streaming quality last time so just trying to fix that :)

@manwendersingh5749 Год назад

I really like your channel. I'm 100% sure your growth, the way you explain is awesome 👌.

@Деревенскийдух Год назад

Useful video! Thank you a lot!

@sqlbelle Год назад

Thank you!

@tarunpavada427 Год назад

Hi Donabel, in tableau order of operations sets are above dimension filter, does that mean sets does not get affected by dimension filter,cuz i have created a set on a date field and using same date field as filter on dashboard, while updating date field the date set is getting affected. Is my understanding wrong? Thanks in advance for ur help🙂

@sindhuri81 Год назад

Very well explained, nice video providing us some real knowledge. Could you please let us know how to do this tracing when using Oracle SQL Developer tool?

@Priyanka-de4ui 11 месяцев назад

could you please share it with Include and FIXED lods as well?

@thedriver492 Год назад

You are providing very imp and quality knowledge about tableau

@sqlbelle Год назад

Thank you :)

@rajeshraj-sk8nn Год назад

Take a bow for your efforts. Can we do the same with databricks?

@nirjharghosh4478 Год назад

Please show this for include and exclude as well.

@senthil7590 10 месяцев назад

Your video is more than tableau documented explanation. When it comes for refreshment always come to your Tableau Videos' .

@sqlbelle 10 месяцев назад

Thank you :)

@Guna_cocktail Год назад

Thanks for your effort in breaking it down so well. very insightful. Looking forward to the next one. Thanks again for sharing your knowledge. Much Appreciated!

@sqlbelle Год назад

Thank you Guna!

@dfreshness2006 Год назад

Thank you, this was very helpful. I am interested in knowing how INCLUDE and EXCLUDE work as well. I tend to never use INCLUDE/EXCLUDE because FIXED seems much more intuitive.

@sqlbelle Год назад

Thank you - I am curious about it too. I use FIXED LODs more often, but will definitely post what I find out :)

@cococnk388 Год назад

Mme you are really helping us … what a difference from other channels… I see you really love going in depth in understanding concepts .. I am just following your footsteps. I am amazed thanks again

@sqlbelle Год назад

Thank you Coco!

@andrewchalsma Год назад

Thanks for pealing away the mystery. It's really good to know it is such simple SQL.

@sqlbelle Год назад

Thank you Andrew!

@OneNatureOneLife Год назад

So cool

@sqlbelle Год назад

Thank you Hussain!

@chandramouliful 5 месяцев назад

This is awesome!!!

@Chenna_Reddy11 Год назад

1st comment

@sqlbelle Год назад

Thank you Chenna :)

@cococnk388 Год назад

Merci !

@sqlbelle Год назад

Thank you so much!!

@BI-Rahul Год назад

Could you please create a video demonstrating how to implement real-time currency conversion in a Tableau Dashboard? The video should include a parameter or filter that displays the currency of different countries. When a user selects a currency they want to view, the dashboard should update in real-time to reflect the selected currency's conversion rates.