No video

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

  • @prasad1686
    @prasad16866 күн бұрын

    Thank you 🙏🙏🙏 for simple, short, straight to the point without wasting time and with lots of knowledge .

  • @spandanaspandy8502
    @spandanaspandy8502Ай бұрын

    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!

  • @veronicaeyo3616
    @veronicaeyo36168 ай бұрын

    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.👍👍👍👏👏👏🙌🙌🙌

  • @ankitamajumdar9510
    @ankitamajumdar95103 ай бұрын

    Drag Salary and drop it in the tool tip then click on the salary drop down and choose measure. Then select minimum/ maximum.

  • @MAH8897
    @MAH889711 ай бұрын

    Wonderful learnt new thing today. Almighty bless you.

  • @jianitoh5409
    @jianitoh54092 ай бұрын

    So amazing. For the homework... drag and drop Salary into Label. Then right-click, drop-down > Measure > Minimum/Maximum

  • @pragyakumari6138
    @pragyakumari613817 күн бұрын

    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

  • @priyadharshinibalasubraman7981
    @priyadharshinibalasubraman79813 ай бұрын

    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.

  • @samilchhantyal4158
    @samilchhantyal415811 ай бұрын

    Thanks Chandoo...we want more on this topic..Love you brother

  • @nash_life
    @nash_life11 ай бұрын

    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 ?

  • @janellamarie6427
    @janellamarie64275 ай бұрын

    Thank you for sharing your learnings and teaching us! I really love your contents!

  • @jessicamaraganas6592
    @jessicamaraganas65929 ай бұрын

    More more tableau tutorials please ❤❤❤

  • @shweta644
    @shweta64411 ай бұрын

    Completed the homework. Feel more confident in Tableau now. Thanks!! :)

  • @anantharajbaskaran897

    @anantharajbaskaran897

    11 ай бұрын

    I am new to this bro. Can you please tell me how to do it?

  • @shweta644

    @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

    @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 .

  • @techysuman2126
    @techysuman21265 ай бұрын

    Wow Sir, u r really great 💯

  • @vikassharma-ug6dn
    @vikassharma-ug6dn4 ай бұрын

    Really nice love

  • @vhegde5016
    @vhegde50166 күн бұрын

    please tell me in =count ( data ) formula what "data " is representing or is it combined of all measures from excel data sheet ?

  • @balamira297
    @balamira2976 ай бұрын

    Did the homework!!

  • @Prathap013
    @Prathap0136 ай бұрын

    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

  • @preetshah3793
    @preetshah37939 ай бұрын

    Please sir make a video on realtime change in data automatically change a dashboard

  • @tnssajivasudevan1601
    @tnssajivasudevan160111 ай бұрын

    Great Thank 😊

  • @mazharmohammed4682
    @mazharmohammed468211 ай бұрын

    Give more videos like this

  • @theprivatespeaker
    @theprivatespeaker4 ай бұрын

    thank you

  • @kollisairithvik4556
    @kollisairithvik45565 ай бұрын

    Sir I dragged the MIN and MAX Salary to the Tooltip.

  • @pragyakumari6138
    @pragyakumari613817 күн бұрын

    Plzz any one tell me when i am doing drag down cound in label why graph changed in 3rd question

  • @hasanalam5808
    @hasanalam58082 ай бұрын

    Sir, I can't see the tables. Nothing appears over there. You skipped the initial parts. Please start from the beginning!

  • @Tony_Montana659
    @Tony_Montana65911 ай бұрын

    Super Sir.❤

  • @pushkardiwakar9740
    @pushkardiwakar974011 ай бұрын

    sir my laptop does not meet the minimum requirement >>Is their any way I can learn without downloading this software

  • @Hyderabad.Anime.edits_106
    @Hyderabad.Anime.edits_10611 ай бұрын

    Anna Nameste 😸

  • @sayantaniguha8519
    @sayantaniguha85198 ай бұрын

    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?

  • @sandhyajalagam8128
    @sandhyajalagam812811 ай бұрын

    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

  • @ivanko-nebo
    @ivanko-nebo11 ай бұрын

    Hi! And what if we need the first letter of the Last name, not First name?

  • @chrism9037
    @chrism903711 ай бұрын

    Very interesting, thanks Chandoo!

  • @harid1320
    @harid132011 ай бұрын

    Hello please do videos on Power bi embedded in web applications

  • @SalmanKhan-ww9wp
    @SalmanKhan-ww9wp11 ай бұрын

    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

  • @ampajalapusivaramakrishna9071
    @ampajalapusivaramakrishna907111 ай бұрын

    Sir please provide the tableau tutorial for beginners

  • @chandoo_

    @chandoo_

    11 ай бұрын

    See this - kzread.info/dash/bejne/poKA0sGDhszWn7Q.html

  • @CareConHelps
    @CareConHelps8 ай бұрын

    Very nice explanation, thanks. but small info for all your videos, please go little slower while showing the video, as many are beginners. thanks

  • @Kanhaiya-dp5kp
    @Kanhaiya-dp5kp4 ай бұрын

    sir pls provide excel data link

  • @user-bg7nc3ep6j
    @user-bg7nc3ep6j5 ай бұрын

    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.............?