- Видео 154
- Просмотров 964 069
Data Viz Canvas
Австралия
Добавлен 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's BEST Table Viz Extension Feature
What is the Tableau Table Viz Extension? In simple terms, it’s a powerful tool that lets us create highly customised and interactive tables within Tableau. Think of it as adding a supercharged extension to your existing Tableau capabilities, enabling you to take your data visualizations to the next level.
Why is this so important? Well, for one, it allows us to design tables that are not just informative, but also visually engaging and easy to understand in few simple steps. Whether you're working on a business dashboard, a detailed report, or just exploring data trends, this extension can help you present your information in a way that resonates with your audience.
------------------------...
Why is this so important? Well, for one, it allows us to design tables that are not just informative, but also visually engaging and easy to understand in few simple steps. Whether you're working on a business dashboard, a detailed report, or just exploring data trends, this extension can help you present your information in a way that resonates with your audience.
------------------------...
Просмотров: 588
Видео
Want Data Insights? Master Sankey Charts in Tableau.
Просмотров 20114 дней назад
Want Data Insights? Master Sankey Charts in Tableau Now. In this tutorial I will show you how to create Sankey chart using viz extension in tableau which allows you to visualise complex data relationships and flows, making your insights more dynamic and engaging. Sankey diagrams is named after their creator, Matthew Henry Phineas Riall Sankey, who first used this chart type in 1898 to show the ...
How to Install Python on Mac OS
Просмотров 122Месяц назад
How to install and uninstall Python on Mac OS to run code and python scripts. Step by step tutorial for technical and non technical people. 📚 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/3q...
Tableau Centralised Row Level Security
Просмотров 6393 месяца назад
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 St...
Tableau Virtual Connections
Просмотров 7493 месяца назад
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
Просмотров 1968 месяцев назад
📚 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,5 тыс.8 месяцев назад
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,7 тыс.10 месяцев назад
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
Просмотров 1,2 тыс.Год назад
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,8 тыс.Год назад
📚 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,4 тыс.Год назад
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
Просмотров 4 тыс.Год назад
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
Просмотров 7 тыс.Год назад
How to create rounded progress bar chart in tableau
AI for analytics design - Midjourney AI art generator
Просмотров 2,8 тыс.Год назад
AI for analytics design - Midjourney AI art generator
SQL Command Types for Beginners- DDL,DML,DQL,DCL,DTL
Просмотров 683Год назад
SQL Command Types for Beginners- DDL,DML,DQL,DCL,DTL
My SQL Workbench Interface: A User-Friendly Overview
Просмотров 877Год назад
My SQL Workbench Interface: A User-Friendly Overview
Install My SQL server and Workbench on Mac OS
Просмотров 5 тыс.Год назад
Install My SQL server and Workbench on Mac OS
Tableau Spatial functions-Makepoint, Buffer and Intersect
Просмотров 3,1 тыс.Год назад
Tableau Spatial functions-Makepoint, Buffer and Intersect
Interactive Tableau Dashboard with Dynamic Zone Visibility -sheet swap -zoom in out
Просмотров 4,6 тыс.Год назад
Interactive Tableau Dashboard with Dynamic Zone Visibility -sheet swap -zoom in out
Don't miss out -The Future is Here | Chat GPT
Просмотров 735Год назад
Don't miss out -The Future is Here | Chat GPT
Data: What is it and why is it so important?
Просмотров 2 тыс.Год назад
Data: What is it and why is it so important?
Thank you. Very nicely explained. Liked the video.
How can we get totals for the measures on the top
pls can you send link of creation of Sankey chart
Please use below link to create Sankey chart using extension ruclips.net/video/fV8OEfI_kxA/видео.htmlsi=Jo_-rjQMbvooQOks
Where do I find the drop down arrows?
Can we type filter value manually because minimum and maximum values are not visible.
Type in filter feature is only availabe for dimensions. Its not available for measure values. You can change measure values using slider as of now. May be in future tableau will release that functionality.
How do I add labels? Label is greyed out
Thank you for the tutorial. Can you create for tree diagram too?
Thank you for the brief and well explained tutorial. Please can you create videos for other viz extentions especially the tree diagram?
Great suggestion! I will try.
Great tutorial. Thanks for sharing.
You are welcome. Glad you liked it.
Is this vis extension created and managed by you?
@@MN-gi4xy no , it’s crated by tableau. There are more extensions that are created by third party companies and some by tableau community members in collaboration with tableau.
I have a doubt Suppose I have created a field where I have to find the current quarter sales that is 2024 Q2 and previous quarter sales 2023 Q2 and then find the % change. For current quarter sales, I have hardcoded the year as 2024 but for quarter I have created a parameter that is select quarter and put that parameter in calculation to make it dynamic . And I did the same for 2023. Then I have created another calculated field to find the % change between them. Now I want to add indicators for downward and upward sign according to % change for Q1, Q2 and so on which is controlled by me. How can I add kpi red/ green indicators to them
Thats a great question. You could create a dynamic calculated field that gives the percentage difference between select quarter and selected quarter -1 based on your parameter selection. Please try that and let me know in case of any issues.
Great video, thanks a lot, I am currently cooking my personal web site and just found your video, I have a question, do you know which one of the two method is the best to embed a tableau dashboard?
Very useful & clearly explain, thank you so much
You are welcome. Glad it was helpful!
Legend
Thanks.
@DataVizCanvas additionally here how can I show data displaying only for latest 5 quarters. Because when I am trying to filter out the complete dataset is changing because of order of filter operations
Thanks You Sir
You are welcome 🙏
Can we write custom sql in virtual connection. Once virtual connection is created and we access it from desktop , I dont see any place to write custom sql
Unfortunately there is no option to write custom SQL with data source connecting to virtual connections. You might need to create a seperate object in virtual connection or create a view in database.
Thank you ! For the first method using the shapes feature, if the data currently shows only positive year-over-year trends, how can we dynamically adjust those shapes in the event of potential negative growth in future data refreshes? I am working with a single KPI on the dashboard.
Hi Sir, in the video u sow how to use virtual connection based on full name coz ur sample show one manager handle one region, how about if I want to use based on group name coz in my case one manager not only handle one region but more (it is mean that one user can be in more one metrics group). So let say Joni is manager in Region 1 & 2. So it means that Joni can see data from region 1 & 2.
That’s a great question. Yes if you set up row level security based on user name then that user can see all the data linked to it. In your example you can create local user group based and use that in the policy. That way you can manage users in policy by just adding them in the local group. Please try that and let me know in case of any issues.
What of we want to show in day level which changes dynamically and see proper date values? And also the region values are in different columns each for central, west etc?? Is it possible then?
Hi @datavizcanvas I have a dataset where I want to display the count of approved quotes over time while I showed it. It's showing the 0,1,2 for each date . That's correct while I need to see some change in height or length of the bars over there.
Is there a way to do this when using a custom sql query as the data source? I can't union sql queries so this becomes impossible
Please slove this one question Who are 25th, 50th and 100th customers from top with respect to sum of sales in 2021?
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
@@DataVizCanvas Many thanks for the help! It is not allowing me to comment a link, how should I send it to you?
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 ruclips.net/video/ElD8jbnLjaw/видео.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