This is really nice. A little concerned about your attrition rates but the dashboard is lovely. Would only look into maybe improving the source (like SQL database). More on reddit.com

After your question has been solved u/Fun_Leadership_8162 , please reply to the helpful user's comment with the phrase "Solution verified". This will not only award a point to the contributor for their assistance but also update the post's flair to "Solved". I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns. More on reddit.com

Without more information about what fields you had available, and specifically what the positions table is measuring, it really hard to say. My assumption is that you’d likely have access to information like: department, manager, start date and end date, role class/level, job title, maybe demographic data? That said - you don’t sound like the subject matter expert who should determine KPIs here. Does your team have goals? Is this data aligned to/responsive to those goals? If you really have to start from scratch, the main KPI in hr is probably retention/turnover. I’d start there. Use your org’s definition to visualize monthly turnover rates over time. Typically this is done by looking at the average headcount over the last twelve months and dividing that into the number of exits in a given month. Then create breakdowns by other dimensions to look for differences in turnover (By Department, By Role, By Job Title, By race/ethnicity, by gender, etc…) The other main kpi I see is around staff composition/diversity. Summarize breakdowns by various demographic groups and then provide cuts by role, salary band, job title, etc… Once you’ve figured that out, you might want to start looking at promotions/demotions, transfers, compensation equity, re-hire rates. Then maybe merge on other data - staff surveys and satisfaction, benefit usage, recruiting and hiring funnels. The bottom line though is that you shouldn’t start with a dataset and say “what should I visualize?” You should start with questions, check that your data can answer those, and then get to work. I’d go back to your manager and ask for more direction - start with org or team goals and see if your data can answer those. More on reddit.com

Comment I have: You really gonna wake up in the morning when you see the color scheme. I would suggest to have a little bit subtle of pink usage and to that you can use a palet of colors for the charts that will match the pink. Ask Google or chat GPT for generators. Overall it is a fine dashboard to see what is going on. My personal interest will be the next step. Now you know what’s going on but why do you need the numbers? And what are the next steps? More on reddit.com