Chandoo
Do you want to know how to analyze data and create beautiful dashboards with Tableau? This video is for you. Learn how to go beyond the basics of Tableau and use concepts like: π Calculated measures & columns π Customizing visuals π Creating histograms & box plots π Working with "Marks" π Field formatting π Filters, Actions and using "Context" π Cumulative totals π Setting up a dashboard We are going to the sample HR data (download it here: https://chandoo.org/wp/wp-content/uploads/2023/09/hr-data-analysis.xlsx) and answer these 10 questions. 1) How many people are in each Job? 2) Gender distribution 3) Age spread of our staff 4) Which jobs pay more? 5) Top earners by job 6) Qualification vs. Salary 7) Staff growth trend in the last 5 years 8) Employee filter by starting letter 9) Leave balance analysis 10) Quick HR Dashboard β± Video topics & timestamps: 0:00 - Loading data into Tableau 0:30 - People by job (Q1) 1:45 - Adding labels & changing colors 2:20 - Gender distribution (Q2) 3:30 - Adding a job title filter for the pie chart 4:23 - Age spread of the staff (Q3) 5:02 - Bin customization for the histogram in Tableau 6:54 - Which jobs pay more (Q4) 8:26 - Adding tooltips 9:11 - Top earners by job (Q5) 10:36 - Context filters and fixing the top filter problem 12:23 - Qualification vs. Salary (Q6) 13:22 - Staff growth over time (Q7) 14:10 - Using "Quick Table Calculations" to get running total 14:46 - Employee filter by starting letter (Q8) 15:50 - Adding first letter calculated column 17:16 - Leave balance analysis (Q9) 17:40 - Staff with more than 20 days leave balance - Calculated Measure 18:42 - Quick HR Dashboard with Tableau (Q10) 20:39 - Dashboard actions and fixing context filter errors 22:54 - Adding titles with Textboxes π»Data & Final Result ================== Raw data (use this to practice) - https://chandoo.org/wp/wp-content/uploads/2023/09/hr-data-analysis.xlsx Final Result (published version of my HR dashboard) - https://public.tableau.com/views/Tableau-10tips/Q10 πΊ More on Tableau & Power BI ========================== Love Data Analysis with Tableau or Power BI? Check out these additional videos. Learn Tableau in 15 minutes https://youtu.be/tNLp_JVipoQ Learn Power BI in 10 minutes https://youtu.be/9tF1IrfLflg Learn Power Query in 15 minutes https://youtu.be/UAFExySaSPY Power BI - Beginner to PRO Dashboard https://youtu.be/uwe8C7K8fXY Excel Dashboard https://youtu.be/35VnP0Rz71I Tableau Playlist https://www.youtube.com/playlist?list=PLmejDGrsgFyALk7dA4ZPlUuFdclJEHLho Power BI Playlist https://www.youtube.com/playlist?list=PLmejDGrsgFyClheDmsfikqOt0no-TKArs Power BI FULL Course (50 videos, 20+ hours material) https://chandoo.org/wp/power-bi-course/ ~ #tableau #tableaufullcourse
Complete understanding of the topic
Hands-on practical knowledge
Real-world examples and use cases
Industry best practices
Take your learning to the next level with premium features