The HR department has the same reporting model across different companies, even when they differ by industry or size. This sample looks at new hires, active employees, and employees who left and tries to uncover any trends in the hiring strategy. Our main objectives are to understand:
This sample is part of a series that illustrates how you can use Power BI with business-oriented data, reports, and dashboards. This is real data from obviEnce (www.obvience.com) that has been anonymized.
Want to follow along? In the Power BI service, go to Get Data > Samples > Human Resources Sample > Connect to get your own copy of the sample.
You can also download just the dataset (Excel workbook) for this sample.
Let’s explore new hires first.
Select the New Hire Count, New Hires Same Period Last Year, Actives YoY % Change By Month tile.
The Human Resources Sample report opens to the New Hires page.
Notice the following:
The New Hire Count, New Hires SPLY and Actives YoY % Change by Month combo chart shows we hired more people every month this year compared to last year significantly more people in some months.
In the combo chart New Hire Count and Active Employee Count by Region and Ethnicity, notice we’re hiring fewer people in the East region.
The New Hires YoY Var by Age Group waterfall chart shows we’re hiring mainly younger people. This may be due to the mainly part-time nature of the jobs.
The New Hire Count by Gender pie chart shows a pretty even split.
Can you find more insights for example, a region where the gender split is not even? Select different age groups and genders in the charts to explore the relationships between age, gender, region, and ethnicity group.
Select Power BI in the top navigation bar to return to the dashboard.
Let’s explore data for current active employees and employees who no longer work for the company.
On the dashboard, select the Active Employee Count by Age Group tile.
The Human Resources Sample report opens to the Active Employees vs. Separations page.
Items of interest:
Combo charts on the left show year-over-year change for active employees and separates. We have more actives this year due to rapid hiring, but also more separates than last year.
In August we had more separates compared to other months. Select the different age groups, genders, or regions to see if you can find any outliers.
Looking at the pie charts, we notice we have a pretty even split in our active employees by gender and age groups. Select different age groups to see the gender split differs by age. Do we have an even split by gender in every age group?
Let’s look at the report in Editing View. Select Edit report in the upper-left corner.
Change the pie charts to show Separates data instead of Actives.
Select the Active Employee Count by Age Group pie chart.
In Fields, select the arrow next to Employees to expand the Employees table. Clear the check box next to Active Employee Count to remove that field.
Select the check box next to Separation Count in the Employees table to add it to the Values box in the field well.
Select the Voluntary bar in the Separation Count by Separation Reason bar chart. This highlights those who left voluntarily in the other visuals in the report.
Click the 50+ slice of the Separation Count by Age Group pie chart.
Look at the Separations by Reason line chart in the lower-right corner. This chart is filtered to show voluntary separations.
Notice the trend in the 50+ age group? During the latter part of the year more employees over age 50 are leaving voluntarily. This would be an area to investigate further with more data.
You can follow the same steps for the Active Employee Count by Gender pie chart too, changing it to separations instead of active employees. Look at the voluntary separation data by gender to see if you find any other insights.
Click Power BI in the top navigation bar to return to the dashboard. You can save the changes you’ve made to the report or not.
The last area to explore is bad hires. Bad hires are defined as employees who didn’t last for more than 60 days. We’re hiring rapidly. Are we hiring good candidates?
Select the Bad Hires as % of Actives by Age Group dashboard tile. This opens the report to page 3, “Bad Hires”.
Select the Northwest check box in the Region slicer on the left and the Male slice in the Bad Hire Count by Gender donut chart. Look at other charts on the “Bad Hires” page. More male bad hires than females and lot of Group A bad hires.
Looking at the Bad Hires by Gender donut chart and clicking through the Region slicer we notice that East is the only region with more female than male bad hires.
Click Power BI in the top navigation bar to return to the dashboard.
The Q&A question box is where you type a question using natural language. Q&A recognizes the words you type and figures out where in your dataset to find the answer.
Click in the Q&A question box. Notice before you even start typing, the Q&A box contains suggestions:
You can pick one of those suggestions, or type:
show age group, gender and bad hires where region is east.
Notice most of the female bad hires are under 30.
This is a safe environment to play in. You can always choose not to save your changes. If you do save them, you can always go to Get Data for a new copy of this sample.
We hope this tour has shown how Power BI dashboards, Q&A, and reports can provide insights into human resources data. Now it is your turn — connect to your own data. With Power BI you can connect to a wide variety of data sources. Learn more about getting started with Power BI.