I have been looking for something like this for a long time. Simple explanation, slow in explanation, breaks to show you what he is actually doing. BES CHANNEL.
HR Analytics Dashboard Here's an explanation of the dashboard: 1. Employee Metrics: Employee Count: 1,470 employees are currently in the organization. Attrition Count: 237 employees have left the organization, leading to an attrition rate. Attrition Rate: The attrition rate is 16.12%, calculated as (Attrition Count / Employee Count) * 100. Active Employee: 1,233 employees are currently active, i.e., still working within the organization. Average Age: The average age of the employees is 37 years. 2. Attrition by Department: The dashboard shows a pie chart depicting the percentage of attrition across different departments: R&D: 133 employees (56.12%) have left, the highest attrition. HR: 92 employees (38.82%) have left. Sales: 12 employees (5.06%) have left. 3. Number of Employees by Age Group: A bar chart displays the distribution of employees across various age groups, indicating the count for each: The age group of 32-34 years has the highest number of employees (274). The chart shows a decline in employee count as age increases beyond 34 years. 4. Job Satisfaction Rating: This section is a table listing the Job Roles along with their corresponding Job Satisfaction Ratings (on a scale of 1-5). The table includes roles like Healthcare Representative, Human Resources, Laboratory Technician, Manager, etc., with the number of employees rating their satisfaction at each level. Grand Total sums up the number of employees across all job roles. 5. Education Field-wise Attrition: A bar chart shows attrition across various educational backgrounds: Life Sciences: 89 employees have left, the highest attrition in this category. Medical: 68 employees have left. Other fields like Marketing, Technical Degree, and Human Resources have lower attrition numbers. 6. Attrition Rate by Gender for Different Age Groups: This section shows doughnut charts for different age groups, indicating the gender distribution of attrition: Under 25: 38 females (8.44%) and 20 males (3.80%) have left. 25-34: 112 females (18.11%) and 69 males (29.11%) have left. 35-44: 51 females (15.61%) and 43 males (6.75%) have left. 45-54: 25 females (6.75%) and 18 males (1.27%) have left. Over 55: 11 females (3.80%) and 9 males (1.27%) have left. 7. Attrition by Gender: On the top right, a small section shows the gender distribution of attrition: Male: 150 males have left the organization. Female: 87 females have left the organization.
Thank you for this detailed project. understood every single thing you explained. crisp and precise. This is what i was looking for.🙏 And for the ppt templates too . I was struggling to do/align a proper dashboard. Wasted lot of time aligning. This has helped me in every other way to do portfolio projects. Thanks again.
You should also explain that why you are using these problem statements and what is purpose behind that and what is running in your mind behind it. So everyone will know why you are using this columns. Ye to bas pahle se kisi ne de diya problem statement to usko karna hua. Dashboard is awesome
Thank you @data Tutorials, really awesome video and I learned a lot from these videos of your part 1 and part 2. I would love to watch your videos in the future for my career enhancement. Thanks, a lot
00:01 Design and develop a HR analytics dashboard in Tableau Software. 02:05 The dashboard provides insights for the HR department. 06:16 Studying the data before designing a dashboard is crucial. 08:19 Understanding the metadata and sample data for the HR dashboard 12:25 Creating attrition calculation field in Tableau dashboard. 14:42 Creating attrition, active employees, and average age calculations. 18:48 Designing KPI card and applying default filter on data source level. 20:36 Creating dual axis chart and synchronizing axis in Tableau 24:08 Designing the dashboard layout 26:10 Creating custom backgrounds for Tableau dashboard design 30:09 Formatting the dashboard for visual appeal 31:55 Formatting and adjusting visual elements in Tableau for better dashboard appearance 36:29 Design the pie chart
Bro I subscribed because you are awesome! One can learn Tableau if the tutor shares an actual download data source and you are the only video I see that did that! Thanks!
Rtly Said sir reg.HRM.In my opinion it's the need of the time nd correction with all sectors.Data in Dashboard helps to get information with vry.frequenty nd it save the time.New technology is must in HRM nd everything on tips which is also effective in T&D where different Training Methodology , analysis, strategies, evaluation, well fare of workers matters etc.as a professional in my opinion.It is a vry.vast field nd continuous process.R&D can b on self basis nd thru grass root level to Top lavel position.Data analysis also important in all parameters for OD nd OB or PR.Datas store is a boon for any organization in my opinion in brief as a professional.Every day new technology r emerging bt.important fact is what ever is feeded in Data reg.HR shud b factual nd right other wise it will effect the organization in negative way nd thereby effective Development of Productivity of any Sector nd OD.Practical exposure is vry important rather than paper based Methodologies.In my view it provides Basic knowledge bt.external environment is totally different nd it comes with exposure nd experience.Than Dash board will b perfect in HR.since it's a Competitive world so there is no chance of mistakes.Useful nd informative vdo lecture overall.Thanx
Very nice tutorial thanks, I have noticed that your background is fixed size. I ve tried an alternative to use for background a blank scatter plot with background image ( map -> background image). That way the image will resize and can be viewed on different screens 🙂
Using automatic will also reshape the dashboard view to the screen size of any device it is viewed on. Using the fixed type will fix the screen on that particular device type he used to create this dashboard view. It is not recommended unless you're 100% sure your dashboard will be viewed using the same device and screen size.
You are amazing..Thank You for the tips and how you make us understand! I was struggling to understand how this works!! I still have to practice how to add the different backgrounds!!
Thanks for the video! Liked and subscribed! @27:18 - I hope you do create a video about how to design the background so I can learn it here instead of looking for another place for the tutorial haha
This background image has pixel size 1600 by 900 pixels. Use same size for dashboard as well. If you want different size then you need to change size of background as well
Sir, stackholder asking for make the dashboard automatic, so I have followed your video and prepared the bg for dashboard and presented to them, but their need is to fit the dashboard for any screen so if make screen automatic the bg is not fitting to it, is there any solution to resolve this issue,...🙏🙏
Hi, total newbie here. I have been following the steps but is there a reason as to you why my tableau is making the headings but not showing the numbers? Please help.
Hi! Can you tell me the name of the company? Or where you got the source for the HR data? I am using the spreadsheet to run SQL queries for a project, but the source has to be credible. Thanks in advance :) I loved your tutorial. I watched both parts and learned a lot!
Thank you so much for this video, I have just started learning tableau & this video really helped me immensely! I would like to know if there is custom visuals store is available for tableau like it is in power bi? Thank you!!
While formatting for KPI shading for the values shading is working while selecting NONE, But for the headers or measure names the shading is not changing to none, Please Somebody Help....
Thank you very much for this detailed project. You nailed it! Are you using Tableau desktop version? Shall i know how to use Tableau desktop after 14 day free trial. Paid version seems so costly for an unemployed person
Hello thanks for this video. I'm having problems formatting the KPI SHEET in dashboard window. When I right click, format options doesn't show. Please help
Nice experience and a lot of learning. Also tell how to select dashboard design in different domains, should we first create all sheets then dashboard deign or vice-versa. In upcoming videos
Bhai mene dashboard per attribution by vala data remove kar diya tha but jab me firse add kar raha hu dashboard per so full size me aaraha he please help what will i do
Wonderful dashboard I was waiting such kind of dashboard. Request you to please please make 3 year dashboard where we can see YTD quarterly and monthly headcount vs attrition rate.
Brothet please sales man ka monthly quarterly yearly dash board ka ek video banao na please, usmay employee ka attendance present, absent, uska performance grading kay saath, grooming ratings, visual merchandising rating, sales ranking, sales target vrs achievement ratings, percentage..msg bada hai par aapkay liye chutki ka kaam hi..
Hi, I really like the way you are explaining dashboard. Actually I am looking for Tableau training from start. if you have any please let me know in your channel.
Hi, Thanks for the video. I have created the dashboard as you have taught, but how did you add the dashboard name? When I tried to add a Dashboard title at the end, it disturbed the whole dashboard. Could you please let me know how to add a title and put it in the space you had In your dashboard without disturbing the dashboard? Thanks
Hi bro, can you give me advise to become data analyst job does really need to learn python if yes what level should be. Or pls confirm, I have 7y + sql job exp and basic tableau knowledge. Is it right time to start with this knowledge If i want to become a data analyst.