Tableau Tutorial - Practical LOD #11 - Percent Difference from Average Across Range (Part 3)

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

КОМЕНТАРІ • 54

  • @sqlbelle
    @sqlbelle  2 роки тому +5

    Unlock new career opportunities and become data fluent today! Use my link bit.ly/2XxFVJc and check out the first chapter of any DataCamp course for FREE!

    • @MrStark-zy6cd
      @MrStark-zy6cd 2 роки тому +3

      Sure, i have been waiting for a course from you, very excited, thank you

    • @sqlbelle
      @sqlbelle  2 роки тому +4

      Thank you Mr Stark. I have the next LOD part lined up and published for next week :)

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

      Is there a place where we can find data sets please

  • @stephentickal2757
    @stephentickal2757 2 роки тому +6

    I have a master's degree in educational technology and am learning Tableau for my current project. I am picky about what videos I watch, and yours are AMAZING. I couldn't find paid-for videos better than yours. Thank you!!!

    • @sqlbelle
      @sqlbelle  2 роки тому +4

      Hello Stephen - thank you so much for taking the time to share this. It really means a lot. I am happy that you've found the videos helpful. There's still a lot of areas to improve, but happy that at this state people are finding value in them. Thank you again :)

  • @rubenmartinez4555
    @rubenmartinez4555 9 місяців тому +1

    Your videos are top tier class: well paced, thoroughly explained, taking the time to highlight each important element, without any "look how good I am at this" swagger that is sadly so common in many other channels... I'm gradually understanding Tableau much better. Thank you so much for your efforts!

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

      Thank you Ruben, I am glad to hear.

  • @saurabhkhare3315
    @saurabhkhare3315 2 роки тому +1

    Saying again you are doing a tremendous job. You are super clear with your concepts and the way you present the same is awesome. Thanks Donabel we are blessed to have a trainer like you.

    • @sqlbelle
      @sqlbelle  2 роки тому

      Thank you Saurabh, I appreciate the kind comments and feedback!

  • @bavisshyaraghuraman2888
    @bavisshyaraghuraman2888 12 днів тому

    you are awesome madam and excellent way of demonstrating and explaining

  • @HoangNguyen-dg8xp
    @HoangNguyen-dg8xp 2 роки тому +2

    you are the most amazing Tableau Content creator. I love to watch your videos and they help me to understand the concept of LOD. Thank you

    • @sqlbelle
      @sqlbelle  2 роки тому +2

      Thank you so much for your kind note, Hoang! I hope you find this video helpful. The next use cases are more involved than the Top 1-5, and 6-10, so likely there will be a video per use case. Hope these will be helpful too :)

  • @tonylu718
    @tonylu718 2 роки тому +1

    I can't tell you how many "ah-ha" moments I've had after watching your tutorials. You're simply amazing, thank you!!

    • @sqlbelle
      @sqlbelle  2 роки тому +1

      Thank you Tony! I am glad to hear you found the video helpful. I appreciate your note!

    • @tonylu718
      @tonylu718 2 роки тому

      @@sqlbelle Just curious, did you take or receive any formal Tableau training? Your instructions are perfect for beginners AND someone who has a little bit of experience.
      I had Tableau installed on my work laptop and that was it. No idea what it was or how to use it. 3 yrs and some 40+ dashboards later, I'm still learning. 😄

  • @JP_-oq3xn
    @JP_-oq3xn Рік тому

    such a quick and concise method of explanation. I may not understand some of the concepts but it makes it easier for me to learn, knowing it is explained excellently . Thanks !

  • @bavisshyaraghuraman2888
    @bavisshyaraghuraman2888 12 днів тому

    this vedio was very useful, can you please teach to fillter out the tickers which fall under negative value based on % Difference from Selected Range instead of seleting one by one ticker and see which is negative or possitve

  • @sayakpalit3615
    @sayakpalit3615 2 роки тому +2

    Very helpful tutorial on LOD. 👍👌

    • @sqlbelle
      @sqlbelle  2 роки тому +2

      Thank you Sayak!

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

    I really want to thank you for this powerful and excellent content.

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

      Thank you @juancamiloforero7334 - glad you found it helpful!

  • @giuliko
    @giuliko 2 роки тому +1

    I was looking forward for this part 3. Awesome work lady, keep it strong. God bless you.

    • @sqlbelle
      @sqlbelle  2 роки тому +2

      Thank you Giuliko. There's a part 4 next week :) .. I think that should round up the Top 15, but depends on how long the video turns out to be.

    • @giuliko
      @giuliko 2 роки тому +1

      @@sqlbelle for me it could have 15 parts, really. This is such a interesting and challenging topic to discuss and learn and you make it look easier. Thanks for your time and work on that.

    • @sqlbelle
      @sqlbelle  2 роки тому +2

      I totally agree! I think there's a lot to cover. It's easy to mistake one solution to be a be-all end-all solution, but the moment you change data sets, the same calculations may not work the same.
      Thank you for your comment and support! Much appreciated!

  • @abishekthirukonda5607
    @abishekthirukonda5607 2 роки тому +1

    Thank you! This was amazing. Looking forward to your next video.

    • @sqlbelle
      @sqlbelle  2 роки тому +2

      Thank you Abishek!

  • @agermoune
    @agermoune 2 роки тому +1

    can’t believe i missed this! my bell alert was not working. Thx as always. taking Python classes now, so will be looking at your proposed learning site!

    • @sqlbelle
      @sqlbelle  2 роки тому +1

      Thank you Abderrahim :) .. Happy New Year!

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

    Thanks Miss

  • @67yuirty
    @67yuirty 2 роки тому +1

    Thanks For this ..Really very helpful . And very clear explanation

    • @sqlbelle
      @sqlbelle  2 роки тому +1

      Thank you @Rupesh!

  • @simmumuddana792
    @simmumuddana792 2 роки тому

    Hi Sqlbelle, can you please help us with "Jitter Plot" different ways using examples '1. Strip plot & Random Function' '2. Box-and-Whisker plot & Index Function' and any other methods with which we create Jitter plots.

  • @michafabich9213
    @michafabich9213 2 роки тому +1

    extremely useful, thanks

    • @sqlbelle
      @sqlbelle  2 роки тому +1

      Thank you Michal!

  • @NaveenKumar-ig6gn
    @NaveenKumar-ig6gn Рік тому

    Hi , i have one doubt can you please validate the sales on selected date values.? when i compare the data it is giving huge number. if we are selecting any date then it needs to display sales on that selected day right but i can see your video at 29.32 mintute i can see daily sales is one value and sales on selected date is one value , can you please clarify me.

  • @williamzhang4523
    @williamzhang4523 2 роки тому

    Love to watch your videos and they are very helpful!!! thanks a lot. But I have a question that in the case using superstore data set, should we compute the sales on selected data using avg of daily sales instead of sum? I think sum function should works on sales

  • @nallelybalderasacatitla9102
    @nallelybalderasacatitla9102 2 роки тому +1

    Awesome, you are the best

    • @sqlbelle
      @sqlbelle  2 роки тому +1

      Thank you Nallely!

  • @christill1274
    @christill1274 2 роки тому +1

    Hi belle ,I'm your bigest fan.if I follow your playlist called "Learning Tableau? Follow this playlist",can I view all your tableau teaching videos without missing one of them.(my English is not good ,hope you can understand)😀

    • @christill1274
      @christill1274 2 роки тому +2

      i don't want to miss any video of yours,and i want to learn them by the correct consequence😁

    • @sqlbelle
      @sqlbelle  2 роки тому +2

      Thank you Christill. The playlist does not have all the videos in the channel. I also add videos to this playlist every so often. That's a great point, perhaps I can provide an actual list later on for anyone who wants to view the videos in sequence.

  • @user-sq4jw7hs8d
    @user-sq4jw7hs8d Рік тому

    how can i get the link to download this dataset

  • @readistreet9383
    @readistreet9383 2 роки тому

    Hi! thanks a lot for your videos. When try to put the reference band dosent apprears the option to choose date or adj(close). It only appears the whole table, do you know what that is happening? is it for my version of tableau?

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

    I cannot get the average across range to work. I’ve tired so many times. It’s not matching the correct average amount.

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

      It keeps averaging the day between everything per day and then averaging the total averages per day even when it’s fixed to the ticker.

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

      Yeah I’m stuck. I can’t even get the day amount to label on the reference line for selected date. It won’t show up. I followed this step by step.

  • @omegaranger6654
    @omegaranger6654 2 роки тому +1

    Do u hv any udemy course belle??

    • @sqlbelle
      @sqlbelle  2 роки тому +1

      Thank you Omega Ranger - I don't have a Udemy course at the moment.

    • @omegaranger6654
      @omegaranger6654 2 роки тому

      @@sqlbelle pls do one..u r the best tableau teacher

  • @marcellberto2538
    @marcellberto2538 2 роки тому

    Don't forgot to change the aggregation on your label marks from SUM() to AVG() otherwise Selected Sales and % Difference labels will be wrong.

  • @user-vq3km1th8f
    @user-vq3km1th8f Рік тому

    excellent explanation @sqlbelle