Create a HR Dashboard with Tableau - Full Tutorial
Вставка
- Опубліковано 22 лип 2024
- 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/wp-content/upl...) 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/wp-content/upl...
Final Result (published version of my HR dashboard) - public.tableau.com/views/Tabl...
📺 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/power-bi-course/
~
#tableau #tableaufullcourse - Наука та технологія
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.👍👍👍👏👏👏🙌🙌🙌
Thanks Chandoo...we want more on this topic..Love you brother
Thank you for sharing your learnings and teaching us! I really love your contents!
So amazing. For the homework... drag and drop Salary into Label. Then right-click, drop-down > Measure > Minimum/Maximum
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.
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.
More more tableau tutorials please ❤❤❤
Great Thank 😊
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 ?
Wow
Sir, u r really great 💯
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
Really nice love
Completed the homework. Feel more confident in Tableau now. Thanks!! :)
I am new to this bro. Can you please tell me how to do it?
@@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.
@@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 .
thank you
Super Sir.❤
Did the homework!!
Very interesting, thanks Chandoo!
Give more videos like this
Hi! And what if we need the first letter of the Last name, not First name?
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?
Please sir make a video on realtime change in data automatically change a dashboard
sir my laptop does not meet the minimum requirement >>Is their any way I can learn without downloading this software
Anna Nameste 😸
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, I can't see the tables. Nothing appears over there. You skipped the initial parts. Please start from the beginning!
Sir I dragged the MIN and MAX Salary to the Tooltip.
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
Hello please do videos on Power bi embedded in web applications
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.............?
Sir please provide the tableau tutorial for beginners
See this - ua-cam.com/video/tNLp_JVipoQ/v-deo.html
sir pls provide excel data link
Very nice explanation, thanks. but small info for all your videos, please go little slower while showing the video, as many are beginners. thanks