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