For those eager to improve their report design skills in Power BI, the Samples section in the sidebar features a link to the weekly Power BI challenge hosted by Workout Wednesday , a free resource that offers a variety of challenges ranging from beginner to expert levels. These challenges are not only a test of skill but also an opportunity to learn and grow. By participating, you can dive into tasks such as creating custom visuals, employing DAX functions, and much more, all designed to sharpen your Power BI expertise. 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

I'd also like to hear what others use. I'm a department of one and also run the front office. For the past three years iv built my own dashboard in excel that's updated daily and can run some basic numbers. We are growing so definitely looking for something more built out and user friendly. More on reddit.com

Check spelling 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