Create a HR Dashboard with Tableau - Full Tutorial
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: chandoo.org/wp...) 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) - chandoo.org/wp...
Final Result (published version of my HR dashboard) - public.tableau...
📺 More on Tableau & Power BI
==========================
Love Data Analysis with Tableau or Power BI? Check out these additional videos.
Learn Tableau in 15 minutes
• Learn Tableau in 15 mi...
Learn Power BI in 10 minutes
• Your first 10 minutes ...
Learn Power Query in 15 minutes
• Learn Power Query & Au...
Power BI - Beginner to PRO Dashboard
• Beginner to PRO Data A...
Excel Dashboard
• How to make an Interac...
Tableau Playlist
• Tableau
Power BI Playlist
• Power BI Examples, Dem...
Power BI FULL Course (50 videos, 20+ hours material)
chandoo.org/wp...
~
#tableau #tableaufullcourse
Пікірлер: 43
Thank you 🙏🙏🙏 for simple, short, straight to the point without wasting time and with lots of knowledge .
I found this video really helpful. If you are someone who just installed the software but have no clue where to start, I definitely recommend starting here to learn a lot without realising how!
I am your biggest fan and I have shared your videos to as many people who have asked me to give them videos to help their data analysis journey. You are the best. You don't waste time and you get the message across. Keep up the good work.👍👍👍👏👏👏🙌🙌🙌
Drag Salary and drop it in the tool tip then click on the salary drop down and choose measure. Then select minimum/ maximum.
Wonderful learnt new thing today. Almighty bless you.
So amazing. For the homework... drag and drop Salary into Label. Then right-click, drop-down > Measure > Minimum/Maximum
I was watching continuously 2 3 videos for practise tableau after watching your video but when in started from tht video i got confused thank god i find your another video for practice
Drag salary and drop it in the tool tip. Now right click and go to Measure and change it to Minimum. Similarly do it for Maximum.
Thanks Chandoo...we want more on this topic..Love you brother
Big Fan of your Work. Thank you for giving us all the knowledge. I just have one question. How do you specialize in a particular industry ?
Thank you for sharing your learnings and teaching us! I really love your contents!
More more tableau tutorials please ❤❤❤
Completed the homework. Feel more confident in Tableau now. Thanks!! :)
@anantharajbaskaran897
11 ай бұрын
I am new to this bro. Can you please tell me how to do it?
@shweta644
11 ай бұрын
@@anantharajbaskaran897 you need to add salary two times onto tooltip mark and change measure min and max respectively instead of default sum. Sometimes, you have to open tooltip box to insert these measures. But, above step will do the trick.
@Prathap013
6 ай бұрын
@@anantharajbaskaran897 Salary measure Drag to Tooltip and right click on the salary in marks ,go to measures select minimum and same select do another one select maximum .
Wow Sir, u r really great 💯
Really nice love
please tell me in =count ( data ) formula what "data " is representing or is it combined of all measures from excel data sheet ?
Did the homework!!
Home Work Done MY Brother, Thank you for Home Work. EX: Job Title: Product Manager Count of data:16 Avg Salary:$82.8K Max Salary:$85.0k Min Salary:$80.7k
Please sir make a video on realtime change in data automatically change a dashboard
Great Thank 😊
Give more videos like this
thank you
Sir I dragged the MIN and MAX Salary to the Tooltip.
Plzz any one tell me when i am doing drag down cound in label why graph changed in 3rd question
Sir, I can't see the tables. Nothing appears over there. You skipped the initial parts. Please start from the beginning!
Super Sir.❤
sir my laptop does not meet the minimum requirement >>Is their any way I can learn without downloading this software
Anna Nameste 😸
Is it possible to show the 2nd worksheet in order of highest female to male ratio??.. in other words.. can we arrange the filter, job-title in order of highest female to male ratio?
Hi sir Your explanation has nice variation Awesome job sir Am sandhya Done mba power bi from scratch would like to learn Pls guide me As applying business analyst role how it helps me
Hi! And what if we need the first letter of the Last name, not First name?
Very interesting, thanks Chandoo!
Hello please do videos on Power bi embedded in web applications
Sir can you please help me that In my excel there is so many names like 500 names and most of the names are repeated so all of total is around 5000 names including all duplicates, but i want to put only remarks for each person and it should reflect in other duplicate cells of each person name. How can i do? I am too much confused and searching alot about this but couldn't find any solution. Can you please help me in this situation please
Sir please provide the tableau tutorial for beginners
@chandoo_
11 ай бұрын
See this - kzread.info/dash/bejne/poKA0sGDhszWn7Q.html
Very nice explanation, thanks. but small info for all your videos, please go little slower while showing the video, as many are beginners. thanks
sir pls provide excel data link
sir tableau download nhii huu rhaa error arhaa ha. ma na uninstall kar ka again download kia thaa again error ajaataa ha. what i do.............?