In this channel I will be sharing different artistic ways of visualizations, data visualization techniques, tips & tricks of data analytics within tableau community. Working with data means designing ways to transform the abstract data into something that can be seen, felt and directly connected to our lives. Through this channel I am trying to reach to wider visual analytics community and help them design the data visualization that can be felt and connects us to the information.
Who am I?
I am Gurpreet Singh - Data Visualization Specialist (Tableau Certified Professional) and Tableau Ambassador. My journey with Data & Analytics started back in 2009 when I did my Masters in Information System and have been in Data analytics and visualization industry since then. The power of data and how it assist humans to make decisions led me to explore my interest in Data Analytics. I enjoy working closely with data using visualization tools to tell the story which keeps me motivated.
Пікірлер
Why are the sales numbers halved? It doesnt reconcile to the data.
hi, if i want to do dynamic sorting by measure like the way with parameter, but only within each category of a dimension, is it possible?
Thanks , helped for current value - default value in Parameter
You can say step by step like why we need to do those things and what are the trying to implement you just simply saying and I don't understand what are you trying to say
Great brother ! thanks a lot !
You are welcome. 🙏
thanks, this is very helpful
You are welcome. Glad you liked it 🙏
are bhaiya debate me Kisi knowledgeable person ko bulao. aap log bhi na kisis ko bitha dete ho
Thanks for your feedback
Thank you very helpful however, I get a error for the intersect function: Cannot mix aggregate and non-aggregate arguments with this function
This error message comes when you are aggregate value is mixed with non aggregate value. Try using Attr() function for non aggregate value.
Hello , what if we want "All" as an option in the drop down menu, would appreciate if you could help with this
how to export the image to shape in tableau ?
Please try saving the image you wanna use as shape in the Tableau Repository under shapes folder. Once you do that then tableau desktop will automatically pick it up from there. Hope that helps
Great work man! Much appreciated 😊
Happy to help!
Such an innovate way to show data. You are an artist. I have a video suggestion - you should try to recreate 1 tableau Viz of the day every 10/15 days , would be great to learn
Great suggestion! I will see what i can do. In the meanwhile, please feel free to reach out if you have any questions :-)
Fantastic video as always - One question, when I use this in my data set for a 4 month period - Jan-Apr and I swapped the x and y axis , Apr shows left and Jan shows right. How do I fix this ? I swapped the view as I prefer the vertical view instead of the horizontal one
It must be something to do with x axis and y axis values.. as when you sway the axis, it might have rotated it clockwise. Please try and work with x axis values and try to switch them . It should work. Please let me know in case of any issues. Hope that helps
@@DataVizCanvas thanks works now !
Hi! What would be the reason/work around if I only can select false - the TRUE option does not come up for me
True option will come if in the calculation the condition is met. Try changing the value in the parameter and try again. Hope that helps. Please feel free to reach out if you need more information. Thanks
Great tutorial. Can you explain how one might ad labels tot he inner circle dots or outer circle dots? I do like the hovering capability but could not add labels as I normally would. Thanks.
Any thoughts on how to show labels on the inner and out circles? Thanks.
You are an excellent teacher!
Thanks 🙏
to much background music - info is useful but hard to concentrate because of background music
Thanks for your feedback. Will try to make a better experience in the future tutorials.
So disappointing why trivial things like sorting, have their non-intuitive trick. why is the sort button on each column for then??!
Thanks for your feedback. There is defaut sorting option available as well. This is a different way to do dynamic sorting in tableau.
Thank you, that was so helpful!!
You are welcome. 😊
Awesome video! Just wondering how to sort by category in a specific order (pipeline) vs by total sales by category. I can't seem to do it with custom sorting.
You can do that by sorting in tableau calculation in a particular order. You can also do that by bringing calculated field in the table calculation. Please try that and let me know incase of any issue.
Am I missing something or where can I find the dataset?
You can download the tableau workbook with dataset from my tableau public profile.
Excellent... can we get those images in Raw format?
You can download my dashboard from tableau public and use the images from there. Hope that helps
Great tutorial, Thank you. @ 11:16 Why am I getting double texts?
Could you please share more details, tableau .twbx file would help me in investigation
Please, question, not cushion. One simple word.
Thanks for your feedback.
Great.Thanks for the Video.
You are welcome 🙂
But its showing me three tab. but its have three values
Could you please provide more details. Thanks
May be I am missing something here, but why the %'s are not adding up to 100%?
Its the Profit ratio measure which need not to add up to 100%. It may vary based on the profit made in each region. Hope that helps
Thank youuuuuuu😃😃😃
you are welcome
Hi, glad you made this video and all the informative comments and replies on this video. I had a question too, please do reply- I had a requirement to embed a dashboard into our own company's website and i had created a dashboard in Tableau-cloud but as you said anyone in public internet cant see that. i will choose tableau public for this but how can i connect tableau public with some databases/aws, as i see there are not much connectors available in Tableau-Public just G drive and a "O Data" please suggest me. I was thinking of setting the backend data in Postgre.
Tableau Public doesnt have much data connector options. The best way id to use static excel data which you can update every now an then. In tableau 2022 conference they talked about Broadcast option where you can broadcast your dashboard to public. Please check that with your tableau account manager if that option is stilll available? I will investigate as well and will let you know if i find something on that.
Can you give any resource to understand what's going on for the X part
Hello, I just had to visit my high school math ;) No other resource apart from my tutorial. Please let me know which part you didnt understand and i will try to provide more details.
❤👍
Hi! Thanks for the nice explanation! I have a question tho. If i understand it all correctly, i am now sorting on the total value of the sales. However, in my case, i am building a bigger dendogram, where the layers further in the tree are based on different criteria, so meaning in 1 layer of the diagram, i need different sheets for the branches of the previous layer. Because of this, i need to be able to sort the branches so the dont switch around once the values are in a different order. How would i need to change that? Hope my question is clear :)
Hi. How to hide worksheet title too?
Very useful and request to provide a function of how to then calculate the average days after getting difference of all dates created from using "Datediff" function
What if the data is not hierarchical ? Category and Subcategory are hierarchical
Thanks, how I can see the % and not the numbers instead ?
my Y axis did not came in the center
Hi I am new to tableau and I find this video helpful to what I need but I have a question? How do I hide the 2 dynamic sorting fields that are put on the rows shelf? Thank you in advance!
Hello, why should we always include those two parameters ?
Thats a great question. This is what is available by default. I havent removed it and tested it but feel free to delete them and try if that works and share the outcome.
This is exactly what I wanted, except I can't access to the data sheet that I still don't understand completely. Can you provide data sheet please?
Great video! I have one of these with a slider for the date - is there a way to convert the numbers in the axis to go back to mmm-yy field so its congruent with the slider... otherwise the number just keeps going up when they look at more than 12 months.
This is wonderful video, thank you so much for this. But doesnt that hidden sheet create problem during tab navigation?. I am trying to build an accesible Dashboard and I am integrating Tab focus as a part of it. Leaving the "Hide sheet" will make the Tab to focus on it. Is there a workaround we can do to not include "Hide sheet". I know it is needed to include all values in extension, but if there is a workaround it will be helpful for my Dashboard design.
thank you so much for this.
Hi, I enjoy watching your videos and seeing how your dashboards evolve. I have been following this video to incorporate it into my dashboard but have had no success. I get to a certain point in the video where you drag the path(bins) from the rows to the details in the marks card, and in your video, you get many dots, when I do that my visual does not change and I just have a single dot. I have gone through your video 4 times and can not find where I have gone wrong, now I'm thinking it may be my data. Is there any advice you can provide me regarding this?
How would you do this with a bar chart?
Awesome! Thank u!
that's great but whenever i use it in the dashboard i got 2 shown values one on the top point of the gauge and one at the center point of the gauge. how can i solve this in order to see just the value at the top point of the gauge?
very useful video but the background music is distracting
Thanks for the feedback. Will see what I can do in future videos
LOVED this tutorial...one question...is it possible to resize the axis/column? I'm applying this filtering to tickets within our internal system here at work, and it would be most valuable to be able to resize meaning shrink, and expand each column.
Can you pls provide access to the data that you used to create the bump chart?