Excel Dashboard from start to end (Part 2) | HR Analytics Dashboard | Start to End Design

[@izzieblue-ry8bo]

I have looked at dozens of videos and this video really brought it home for me. I was recently laid off and decided that I would learn a new skill during the holiday break. Dashboards (check)

[@ThePlaceUncovered]

wow.... many thanks. I have fully mastered pivot tables for advance excel

[@magdalenekimani8549]

Your KZbin channel is the best for data analysis. Keep teach us more 👏

[@solomonguesh2869]

Thank you for the detaile and complete package. I have learnt alot on how smart dashboard created.

[@rozitahsoniah5697]

Thanks for this. It's the best I have come across. Be blessed

[@datatutorials1]

Glad you enjoy it!

[@user-wq2sr2wp4x]

Thank you very much for a good demonstration of excel dashboard

[@shubhamaraj915]

Thank you boss. I have prepared my first dashboard due to your help. God bless

[@hakunamatata8464]

Thank you so much ! You provided the video with detailed explanation keep it up !

[@norhayatiyusoff6211]

Excellent sharing that includes everything... from cant do to can do now! Awesome.

[@aruniindika2409]

Thanks a lot for this amazing detailed lesson on the dashboard preparation!!:) Has been an incredible help for my uni studies.

[@kunalkumaraiml2365]

Very insightful video of yours and also make an project of it. Thank you so much.

[@tesfayehailemariam7763]

Thank you for well explained dashboard tutorial, easy to understand and well explained.

[@YKA621]

excellent video...learned a lot from both the videos

[@datatutorials1]

Thanks for watching

[@isaacokweere]

Please can you share some data with me for practice

[@subashlingden9883]

Thank you Data Tutorials!!!

[@anthonyrajarumaidass7504]

Amazing video and content. Thank you so much for sharing this.

[@Chiomyvlog]

Honestly i like all your videos very well explain

[@afeezoloko3423]

Thank you so much sir, you really impacted me with so much knowlegde in this video...

[@datatutorials1]

Glad you liked it ✨

[@nikitakadam6584]

Thank you for the amazing dashboard , please share a separate video for KPI background

[@suchisekhar5460]

Thank you for this amazing dashboard, learned a lot as a beginner

[@abhiamit22]

Excellent...thank you mitra...yet another well explained..step by step procedure of making dashboards and new learnings for me...

[@SubhashreeBaliarsingh-s8w]

a big thanks to you for your efforts and amazing video for dashboard..

[@santhoshignatius9751]

Thank you so much. It is explained so simply and precisely

[@Gurpreet-t6k]

Gr8 video but just one problem rating in donut chart of technical field under R&D showing 3.9 , but under stars it shows 1.3?

[@samhakim6130]

1000 likes, thanks for this wonderful effort.

[@ankitjaiswal9411]

Can you please provide sample copy of your table data. When I apply slicer to role wise they show two name for same department

[@ShwetaBadge-x1j]

Thanks a lot! The video was really informative and helpful:)

[@INNERPUNJAB]

Bro, your videos are amazing. Specially this is very helpful for me and other HR perosn.

[@datatutorials1]

Video on how to create background already available on my channel

[@INNERPUNJAB]

@@datatutorials1 Got it. Thank you so much

[@sathyampesu]

Hi bro, very very detailed and complete package,thank you

[@sidthsingha9710]

thanks alot buddy, love it man. Just one doubt When I am trying to connecting all the report to the slicer, I am unable to find the rating sheet for connecting .Kindly guide me on this

[@marielledivineguttan9788]

Why aren't all the pivot I created not showing when I report connections?

[@mdshahbaz4766]

Awesome 👍 best of best god bless you ❤❤❤

[@noahhungwa7741]

This is very beautiful, please how can I make a DASHBOAD to be updated on a monthly basis by adding to it new data.

[@Tipsshamsamanzoor5172]

Excellent Sir.

[@macacademy1819]

Thank you so much learn a lot from this video

[@orwacaleb7185]

which version of excel is this; I dont have icons on my desktop version

[@babyforevryrhing]

Hi amazing video apperciate your effort and your explanation is clean and neat. I tried everything workse except slicer. The slicer is not working for all the graphs its working only for one graph rest of the graphs remaining same. I have created multiple sheet for different pivot tables please help me

[@datatutorials1]

Try bringing all the pivot tables in single sheet, and then create and slicer report the slicer connection to all pivot again

[@vetrip7153]

Its very Helpful ...Thank you

[@datatutorials1]

You are most welcome

[@mohammedarshad6256]

How to download the dashboard template?

[@julianoronha7056]

You are awesome! Thank you so much!

[@peterrandu7666]

God bless you.

[@datatutorials1]

Thanks

[@peterrandu7666]

@@datatutorials1 Do we have to prepare everything in the same way again or just update when we have information updated in the next month?

[@datatutorials1]

Just update the data and refresh dashboard

[@peterrandu7666]

@@datatutorials1 Many Thanks

[@niveditabisht8426]

I am a bit confused as to why you took Sum of Attrition Count for Job Role and not Count of Attrition. Also, after I cleaned my data and prepared my pivot tables it kept showing blank as a category even though there are not blank rows in my data (I double checked)

[@satyamkumar1534]

re-download the data then it will not show u blank.

[@arijeetkumarsharma226]

Awesome video

[@AbdisalamMohamed-x9b]

Logical functions of Gender(Male & Female) are given me same number when ever I choose one of them so how could i solve that challenge?

[@EtharEthar-u9f]

how to calculat Job satisfaction rating ?

[@datatutorials1]

You already have that field in data

[@EtharEthar-u9f]

@@datatutorials1 Nooooo

[@KarthikeyanV-z2r]

Once completing all the process from the video i am facing a issue like if i click one slicer filter the chart changes automatically but if i clear the whole filter i am not able to get the orginal over all chart back in the dashboard the algorithm gets changed tell me how to fix this

[@datatutorials1]

Send me your worksheet on my email

[@nafeesahmed-zb1kj]

superb man............ thums up.........

[@manikkoshal6]

Can someone please send me the completed version of the excel file? Thanks!

[@truptiekhande1025]

Hello I have done with everything but when at the last i m applying slicer the data of education wise attrition and total employees by gender is not getting change Please help to solve this

[@datatutorials1]

Did you report all the sheet connections to slicer?

[@TaraDevi-t3g]

Hi, Thanks for the video. It was helpful. I have one query, once the data and dashboard created,can we use this same dashboard template for monthly data where we can change data according to month and the dashboard will automatically update with latest month data. Can we integrate dashboard with latest data.

[@datatutorials1]

Yes but you have to design first according to month and then whenever data changes just hit refresh button and charts will be updated

[@VictoriaAlaverdyan]

Thank You so much !!!

[@banidas6703]

very nice sir

[@powerunique-mb2qv]

Very good but attrition by Martial Status not correct

[@datatutorials1]

Ok, can you mention whats wrong with

[@meetupanda]

Hellow Data tutorial- Attrition by Marital status number is wrong- you have taken entire head count for the same insted of attrition

[@dheeraj27793]

In marital vs attrition we should take "cf attrition count " U took only "attrition" column Correct me if I am wrong

[@avinashmajhi2510]

Same Doubts ??

[@priya_1864_]

average hourly rate of malr research scientist attrition rate vs monthly income status average working years for each department job role vs worklife balance attrition rate vs year since last promotion relation

[@datasets-rv7jf]

Thank you so much!