![Data Viz Canvas](/img/default-banner.jpg)
- 150
- 920 755
Data Viz Canvas
Australia
เข้าร่วมเมื่อ 21 ม.ค. 2020
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.
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.
Tableau Centralised Row Level Security
How to implement tableau row level security using Virtual connections.
--------------------------------------------
📚 Recommended Books
--------------------------------------------
📚 DATA VISUALISATION & STORYTELLING
Storytelling with Data: A Data Visualisation Guide for Business Professionals amzn.to/3q9ygPw
Data Visualisation: A Handbook for Data Driven Design amzn.to/3qfb1na
The Big Book of Dashboards amzn.to/3q4i3eG
Data Visualization: A Practical Introduction amzn.to/44KYrel
Storytelling with Data : Lets Practice amzn.to/44O7WcL
Tableau Desktop Specialist Certification: amzn.to/44Ocy2P
Tableau Desktop Certified Associate: amzn.to/3Kk2YfV
📚 SQL
SQL for Data Analytics: amzn.to/3rROkGj
SQL 3 books in 1 : amzn.to/3KklUuY
Learning SQL: Generate, Manipulate and Retrieve Data : amzn.to/3Kn34mN
SQL Quick Start Guide: amzn.to/3KInOpx
📚 DATA ENGINEERING
Data Engineering with Python : amzn.to/3YelH1Y
Data Engineering with AWS: amzn.to/3YgXoAL
Fundamentals of Data Engineering: amzn.to/3OAUVxy
Software Architecture: amzn.to/3KmNffX
System Design Interview: amzn.to/3Yhfy5q
Ace Data Science Interview: amzn.to/3rOxcBl
System Design Interview: amzn.to/3OAw8d7
Designing Machine Learning Systems: amzn.to/3YbGxiB
📚 SOFTWARE ENGINEERING
Clean Code amzn.to/47aBnr4
Clean Architecture amzn.to/3OA8VaP
The Programmatic Programmer: amzn.to/4793k2C
-----------------------------------------
👇 CHECK THIS OUT! 👇
-----------------------------------------
🏪 AMAZON STOREFRONT
www.amazon.com/shop/datavizcanvas
All my recommendations for books, gadgets and gear are also available at my
Amazon storefront. Check it out!
👕 LIKE THE "DATA RELATED GIFTS" WITH CREATIVE, FUNNY & HUMOROUS QUOTES FOR ANYONE WHO LIKE TO LAUGH ?
You can purchase one here: www.datavizcanvas.com/shop/#!/
--------------------------------------------------------------------------------
😍 📧 REACH OUT TO ME ON SOCIAL MEDIA 😍
--------------------------------------------------------------------------------
Instagram: datavizcanvas
Twitter: datavizcanvas
Facebook profile.php?id=100063619264853
Linkedin: www.linkedin.com/in/gurpreetsingh515/
Tableau public public.tableau.com/app/profile/gurpreet.singh2669
Website : www.datavizcanvas.com/
-------------------
GEAR I USE
-------------------
📷 Video
Canon EOS RP amzn.to/3QkOpfU
Canon RF 35mm amzn.to/3rNIh5E
Canon RF 14-35mm amzn.to/44JQw0Y
🎙️ Audio
Rode NT-USB Versatile Studio amzn.to/3DCbxyY
Rode PSA1 Professional Studio Arm amzn.to/3ObseWN
⏱ TIMESTAMPS
‼️ DISCLAIMERS
Links included in this description may be affiliate links. When you buy a product or service with these links, I may receive a small commission. However, there is no additional cost to you :) I genuinely appreciate you supporting my channel so I can continue to provide you with awesome content for free!
Thanks for being a part of this channel and all your support! 💪 🙏
--------------------------------------------
📚 Recommended Books
--------------------------------------------
📚 DATA VISUALISATION & STORYTELLING
Storytelling with Data: A Data Visualisation Guide for Business Professionals amzn.to/3q9ygPw
Data Visualisation: A Handbook for Data Driven Design amzn.to/3qfb1na
The Big Book of Dashboards amzn.to/3q4i3eG
Data Visualization: A Practical Introduction amzn.to/44KYrel
Storytelling with Data : Lets Practice amzn.to/44O7WcL
Tableau Desktop Specialist Certification: amzn.to/44Ocy2P
Tableau Desktop Certified Associate: amzn.to/3Kk2YfV
📚 SQL
SQL for Data Analytics: amzn.to/3rROkGj
SQL 3 books in 1 : amzn.to/3KklUuY
Learning SQL: Generate, Manipulate and Retrieve Data : amzn.to/3Kn34mN
SQL Quick Start Guide: amzn.to/3KInOpx
📚 DATA ENGINEERING
Data Engineering with Python : amzn.to/3YelH1Y
Data Engineering with AWS: amzn.to/3YgXoAL
Fundamentals of Data Engineering: amzn.to/3OAUVxy
Software Architecture: amzn.to/3KmNffX
System Design Interview: amzn.to/3Yhfy5q
Ace Data Science Interview: amzn.to/3rOxcBl
System Design Interview: amzn.to/3OAw8d7
Designing Machine Learning Systems: amzn.to/3YbGxiB
📚 SOFTWARE ENGINEERING
Clean Code amzn.to/47aBnr4
Clean Architecture amzn.to/3OA8VaP
The Programmatic Programmer: amzn.to/4793k2C
-----------------------------------------
👇 CHECK THIS OUT! 👇
-----------------------------------------
🏪 AMAZON STOREFRONT
www.amazon.com/shop/datavizcanvas
All my recommendations for books, gadgets and gear are also available at my
Amazon storefront. Check it out!
👕 LIKE THE "DATA RELATED GIFTS" WITH CREATIVE, FUNNY & HUMOROUS QUOTES FOR ANYONE WHO LIKE TO LAUGH ?
You can purchase one here: www.datavizcanvas.com/shop/#!/
--------------------------------------------------------------------------------
😍 📧 REACH OUT TO ME ON SOCIAL MEDIA 😍
--------------------------------------------------------------------------------
Instagram: datavizcanvas
Twitter: datavizcanvas
Facebook profile.php?id=100063619264853
Linkedin: www.linkedin.com/in/gurpreetsingh515/
Tableau public public.tableau.com/app/profile/gurpreet.singh2669
Website : www.datavizcanvas.com/
-------------------
GEAR I USE
-------------------
📷 Video
Canon EOS RP amzn.to/3QkOpfU
Canon RF 35mm amzn.to/3rNIh5E
Canon RF 14-35mm amzn.to/44JQw0Y
🎙️ Audio
Rode NT-USB Versatile Studio amzn.to/3DCbxyY
Rode PSA1 Professional Studio Arm amzn.to/3ObseWN
⏱ TIMESTAMPS
‼️ DISCLAIMERS
Links included in this description may be affiliate links. When you buy a product or service with these links, I may receive a small commission. However, there is no additional cost to you :) I genuinely appreciate you supporting my channel so I can continue to provide you with awesome content for free!
Thanks for being a part of this channel and all your support! 💪 🙏
มุมมอง: 335
วีดีโอ
Tableau Virtual Connections
มุมมอง 451หลายเดือนก่อน
Tableau Virtual Connections are a powerful feature in Tableau that allows users to manage and secure their data sources more efficiently. With Virtual Connections, you can centralize your data source management, enforce data security policies, and simplify the user experience. This feature is particularly useful for organisations that have multiple data sources and need to ensure consistent and...
How to create Neomorphic Text in Canva
มุมมอง 1876 หลายเดือนก่อน
📚 Recommended Books 📚 DATA VISUALISATION & STORYTELLING Storytelling with Data: A Data Visualisation Guide for Business Professionals amzn.to/3q9ygPw Data Visualisation: A Handbook for Data Driven Design amzn.to/3qfb1na The Big Book of Dashboards amzn.to/3q4i3eG Data Visualization: A Practical Introduction amzn.to/44KYrel Storytelling with Data : Lets Practice amzn.to/44O7WcL Tableau Desktop Sp...
Tableau pulse -AI powered insights
มุมมอง 2.3K6 หลายเดือนก่อน
In today’s video I am going to talk about tableau pulse which leverages the power of Generative AI to bridges the gap between AI and analytics. It handles all the heavy lifting for tasks that would normally be manual and time consuming. It suggests questions and automatically generate insights, to visually summarise key findings in plain language. Tableau Pulse empowers users to explore and ana...
How to add "All" value to Tableau Dynamic Parameter
มุมมอง 1.4K8 หลายเดือนก่อน
Tableau dynamic parameters are much anticipated feature that was released in version 2020.1 It allows us to automatically populate a parameter's value based on data everytime we open the workbook. In todays tutorial, I will show you how to add "All" value option to a dynamic parameter using an extension. 📚 Recommended Books 📚 DATA VISUALISATION & STORYTELLING Storytelling with Data: A Data Visu...
Periodic table in tableau using map layer
มุมมอง 1K10 หลายเดือนก่อน
How to create Periodic Table in Tableau using Map Layer and X,Y Coordinates 📚 Recommended Books 📚 DATA VISUALISATION & STORYTELLING Storytelling with Data: A Data Visualisation Guide for Business Professionals amzn.to/3q9ygPw Data Visualisation: A Handbook for Data Driven Design amzn.to/3qfb1na The Big Book of Dashboards amzn.to/3q4i3eG Data Visualization: A Practical Introduction amzn.to/44KYr...
Create Stunning Sales Dashboard in Tableau from Start to End:Website like Design using Canva
มุมมอง 2.6K11 หลายเดือนก่อน
📚 Recommended Books 📚 DATA VISUALISATION & STORYTELLING Storytelling with Data: A Data Visualisation Guide for Business Professionals amzn.to/3q9ygPw Data Visualisation: A Handbook for Data Driven Design amzn.to/3qfb1na The Big Book of Dashboards amzn.to/3q4i3eG Data Visualization: A Practical Introduction amzn.to/44KYrel Storytelling with Data : Lets Practice amzn.to/44O7WcL Tableau Desktop Sp...
How to create Drop Shadow in Tableau
มุมมอง 2.3Kปีที่แล้ว
In this tableau tutorial, I will be sharing a new technique to create a drop shadow affect to worksheet in tableau dashboard. Check out below video for details. 📚 Recommended Books 📚 DATA VISUALISATION & STORYTELLING Storytelling with Data: A Data Visualisation Guide for Business Professionals amzn.to/3q9ygPw Data Visualisation: A Handbook for Data Driven Design amzn.to/3qfb1na The Big Book of ...
How to create radial heat map in Tableau
มุมมอง 3.6Kปีที่แล้ว
A radial heat map or circular heat map is a variation of heat map, where the table is aligned radially. A heat map is a graphical representation of data where the individual values contained in a matrix are represented as colours that give an immediate insight and guide us on what areas to focus on. In this tutorial I am going to share how to create radial heat map in few simple steps Link to T...
How to create rounded progress bar chart in tableau
มุมมอง 6Kปีที่แล้ว
How to create rounded corner progress bar chart in tableau with drop shadow. Step by step video. 📚 Recommended Books 📚 DATA VISUALISATION & STORYTELLING Storytelling with Data: A Data Visualisation Guide for Business Professionals amzn.to/3q9ygPw Data Visualisation: A Handbook for Data Driven Design amzn.to/3qfb1na The Big Book of Dashboards amzn.to/3q4i3eG Data Visualization: A Practical Intro...
Neomorphic design in Canva
มุมมอง 1.1Kปีที่แล้ว
How to create neomorphic design and shapes in canva. Neomorphism effect is used to create 3d shapes and pop out effect in graphic design. In this tutorial you will learn step by step how to create neomorphism shapes which will help to take your design skills to next level 📚 Recommended Books 📚 DATA VISUALISATION & STORYTELLING Storytelling with Data: A Data Visualisation Guide for Business Prof...
AI for analytics design - Midjourney AI art generator
มุมมอง 2.7Kปีที่แล้ว
AI for analytics design - Midjourney AI art generator
SQL Command Types for Beginners- DDL,DML,DQL,DCL,DTL
มุมมอง 610ปีที่แล้ว
SQL Command Types for Beginners- DDL,DML,DQL,DCL,DTL
My SQL Workbench Interface: A User-Friendly Overview
มุมมอง 726ปีที่แล้ว
My SQL Workbench Interface: A User-Friendly Overview
Install My SQL server and Workbench on Mac OS
มุมมอง 4.7Kปีที่แล้ว
Install My SQL server and Workbench on Mac OS
Tableau Spatial functions-Makepoint, Buffer and Intersect
มุมมอง 2.9Kปีที่แล้ว
Tableau Spatial functions-Makepoint, Buffer and Intersect
Interactive Tableau Dashboard with Dynamic Zone Visibility -sheet swap -zoom in out
มุมมอง 4.4Kปีที่แล้ว
Interactive Tableau Dashboard with Dynamic Zone Visibility -sheet swap -zoom in out
Don't miss out -The Future is Here | Chat GPT
มุมมอง 730ปีที่แล้ว
Don't miss out -The Future is Here | Chat GPT
Data: What is it and why is it so important?
มุมมอง 1.6Kปีที่แล้ว
Data: What is it and why is it so important?
Coxcomb Chart in Tableau: How to Create and Use it
มุมมอง 3.5Kปีที่แล้ว
Coxcomb Chart in Tableau: How to Create and Use it
Dynamic Sorting in Tableau: Here's How to Do It
มุมมอง 4.3Kปีที่แล้ว
Dynamic Sorting in Tableau: Here's How to Do It
Tableau Tips & Tricks that you should know | Amazing tableau tips
มุมมอง 5Kปีที่แล้ว
Tableau Tips & Tricks that you should know | Amazing tableau tips
Good work, thank you for the video
You are welcome. Glad you find it useful. 🙂
Hi Gurpreet, thanks for sharing this. It was really helpful. I have a follow up question: Let' say I have a 1. Actual sales data (how much sales did a seller achieve) 2. Sales Target data (how much sales was the seller targeting to achieve) 3. Seller attributes (seller name, region etc.). With these data sets I need to combine seller name, seller target sales and seller actual sales and ensure that seller can only see their own data. How can I do achieve this tableau virtual connection on Tableau Server Version: 2024.2.0? I'm basically trying to understand how can I join two tables (Actual sales data, Sales Target data) and apply rls (using Seller attributes data) simultaneously. Thanks again!
Thats a great question. Once you have applied row level security on the primary fact table and then join it with secondary table, it will only retrieve related rows from secondary table. Example: Table one is sales with row level security applied on Region (Central) Table two is returned orders and is joined with Table one on Order ID field.. Once the join is created in the workbook then it will only show all the sales made in Central region and corresponding returned items. Hope that helps.. Please feel free to reach out if you need more info.
Hi Gurpreet, thanks for sharing this. It was really helpful. I have a follow up question: Let' say I have a 1. Actual sales data (how much sales did a seller achieve) 2. Sales Target data (how much sales was the seller targeting to achieve) 3. Seller attributes (seller name, region etc.). With these data sets I need to combine seller name, seller target sales and seller actual sales and ensure that seller can only see their own data. How can I do achieve this tableau virtual connection on Tableau Server Version: 2024.2.0? I'm basically trying to understand how can I join two tables (Actual sales data, Sales Target data) and apply rls (using Seller attributes data) simultaneously. Thanks again!
Thats a great question. Once you have applied row level security on the primary fact table and then join it with secondary table, it will only retrieve related rows from secondary table. Example: Table one is sales with row level security applied on Region (Central) Table two is returned orders and is joined with Table one on Order ID field.. Once the join is created in the workbook then it will only show all the sales made in Central region and corresponding returned items. Hope that helps.. Please feel free to reach out if you need more info.
I followed the same approach but my hierarchical tree needs to connect nodes in level 3 with nodes in level 1 for example, without any direct links to a node in level 2. However, when doing this in tableau, its causing some issues and placing the level 3 node in level 2. How can I fix this?
Seems like an issue with the start and end node.. Could you please share the link of the dashboard and i can have a look.
@@DataVizCanvas Thank you! My specific data would be the following, I just centered it around zero per level. Maybe I am doing something wrong? docs.google.com/spreadsheets/d/1L9ocAdHvSaB3UFFTAzyY8hHzSzc3-Uu_/edit?usp=sharing&ouid=110348840310824771709&rtpof=true&sd=true
Can you share how it would be possible to sort the categories not by Rank (of sales) but instead a manual sort - ie I can choose if furniture is at the top regardless of sales? Thanks for your help
Thats a great question. You could use the custom sort on the dimension value rather than sales. Please try and let me know incase you need more info.. Cheers!
is it possible to remove lines when we hover over any data points?
No , we cant . Its basically selecting that data point and showing the details in the hover over.
really nice tutorial. Do you happen to have the script on how to set up the start_node_id and the end_node_id?
No, I dont have the script for this scenario. I generated the data manually for this tutorial. You can download the data from my tableau public profile
Thank You very much !!!
You are welcome! Glad it was helpful !
this is good thanks a lot, however, if i just want to show the null value months only and other side where the sales were done, how that can be done ?
Try using Tableau relationship data model. That will help you to cover such scenarios. Please check my tutorial on Relationships th-cam.com/video/ElD8jbnLjaw/w-d-xo.html
Hi there! i love the video and we are using it in our company for a different use case where it is super valuable to make business decisions! Could you however explain why in the 'Sales' function you use WINDOW_SUM, this i dont understand
This was very helpful! Thank you!
You are welcome. Please stay tuned for more such videos.
I dont see option to create virtual connection in my companys cloud server
That's a great question. Virtual connections are only available if you have Data management Add on. Please check with your tableau Admin in your company if they can get Data management add on.
@@DataVizCanvas okay.Thanks for the reply.
it was so helpful thanks for making video and please make more videos on scenario based questions
Thanks for your feedback. I will try my best. Please feel free to share if you any scenario that you would like more information on?
You saved me. Thank You!!!
Glad I could help! You are welcome :-)
Can we get the entire data into power point?
Not that I am aware of.
Really like it
Thanks for your feedback and supporting my channel.
Tableau is stressful. All these steps just to see a funnel😢
Thanks for your feedback. I can understand your concern. Hopefully in the coming release tableau will come up with easy steps.
Why are the sales numbers halved? It doesnt reconcile to the data.
Seems like data densification is not implemented correctly. Please check the steps again
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?
Yes, you can by adding additional calculations. Please give a go and let me know if you need more info.
Thanks , helped for current value - default value in Parameter
Glad it helped! Please stay tuned for more such videos.
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
Thanks for your feedback. Will see what i can do in future tutorial to make things more clear so my audience can understand it better. In the meanwhile if you have any questions, please feel free to reach out. :-)
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?
You can do that by clicking on the dropdown on the top right corner of the sheet and hide the title.