Tableau, LOD and SQL - Behind the scenes | sqlbelle

Поділитися
Вставка
  • Опубліковано 26 лис 2024

КОМЕНТАРІ • 60

  • @MrBasu-iq6md
    @MrBasu-iq6md Рік тому +1

    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.

  • @TheDistractionStudio
    @TheDistractionStudio Рік тому +12

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

  • @gritmanish
    @gritmanish 4 місяці тому

    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.

  • @saidsaulo1
    @saidsaulo1 Рік тому +4

    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
      @sqlbelle  Рік тому +1

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

  • @Slade69
    @Slade69 Рік тому +1

    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

  • @swagatamchakraborty3352
    @swagatamchakraborty3352 Рік тому +3

    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!

  • @sambarajkanaveni7312
    @sambarajkanaveni7312 Рік тому +1

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

  • @cococnk388
    @cococnk388 Рік тому +1

    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

  • @thedriver492
    @thedriver492 Рік тому +2

    You are providing very imp and quality knowledge about tableau

  • @andrewchalsma
    @andrewchalsma Рік тому +1

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

  • @senthil7590
    @senthil7590 11 місяців тому

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

    • @sqlbelle
      @sqlbelle  11 місяців тому

      Thank you :)

  • @manwendersingh5749
    @manwendersingh5749 Рік тому

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

  • @piyushk3652
    @piyushk3652 Рік тому +1

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

  • @Guna_cocktail
    @Guna_cocktail Рік тому +1

    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!

  • @mesumrazahemani3163
    @mesumrazahemani3163 Рік тому +3

    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
      @sqlbelle  Рік тому +3

      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 :)

  • @rajeshraj-sk8nn
    @rajeshraj-sk8nn Рік тому

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

  • @Деревенскийдух
    @Деревенскийдух Рік тому +1

    Useful video! Thank you a lot!

  • @fuscone
    @fuscone Рік тому +1

    this is a game changer for me, thanks!

  • @peterparker4358
    @peterparker4358 Рік тому +1

    Thanks for sharing 🙂 great content as always ❤️

  • @brunoiungano7192
    @brunoiungano7192 Рік тому +1

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

    • @sqlbelle
      @sqlbelle  Рік тому +1

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

  • @sindhuri81
    @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?

  • @sathya2801
    @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??

  • @chandramouliful
    @chandramouliful 7 місяців тому

    This is awesome!!!

  • @karcolom
    @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?

  • @ravisharma3069
    @ravisharma3069 Рік тому +1

    very Useful content thank you 😍

  • @Priyanka-de4ui
    @Priyanka-de4ui Рік тому

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

  • @tarunpavada427
    @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🙂

  • @dfreshness2006
    @dfreshness2006 Рік тому +1

    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
      @sqlbelle  Рік тому +1

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

  • @pitou00
    @pitou00 Рік тому +1

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

  • @Aleks1246
    @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.

  • @BI-Rahul
    @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.

  • @nirjharghosh4478
    @nirjharghosh4478 Рік тому

    Please show this for include and exclude as well.

  • @yunusteli8697
    @yunusteli8697 Рік тому +1

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

    • @sqlbelle
      @sqlbelle  Рік тому +1

      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 :)

  • @OneNatureOneLife
    @OneNatureOneLife Рік тому +1

    So cool

  • @slowinfastout3304
    @slowinfastout3304 Рік тому

    I thought Tableau was generating queries using analytic functions since this is the way I validate my LOD’s

  • @Chenna_Reddy11
    @Chenna_Reddy11 Рік тому +1

    1st comment

  • @cococnk388
    @cococnk388 Рік тому +1

    Merci !