People Metrics

---

People Key Metrics

Denomas is a focused on supporting our team members, and just like other business stakeholders our People Group is data focused when it comes to creating an environment that allows team members to focus on the contribution they have at Denomas.

Many of the People KPIs can be found in our KPI Index.

The People Metrics Dashboard takes into account our KPIs, in addition to other metrics that help drive people data decisions.

Quick Links

Using the Dashboard People Metrics Dashboard

The people metrics dashboard allows users to come in and get a quick insight of where Denomas stands for the last month, the previous fiscal quarter end, and identifies how the company has been trending for the selected date range (defaulted to past 12 months).

The dashboard can be filtered down to 3 levels:

Dashboard View	Filter 1	Filter 2
Denomas Overall	Breakout = Company	Breakout_Division_Department = All Company
Denomas Overall	Breakout = Division	Breakout_Division_Department = Filter on the applicable division
Denomas Overall	Breakout = Department	Breakout_Division_Department = Filter on the applicable division-department

**Note: This only allows you select 1 division or 1 department at a time.

Some key tips while using this dashboard:

1. If you see the metric name in blue there is an accompanying dashboard that will allow you to explore the data deeper. Click on the link to head there!
2. If you need to see everything aggregated in a report –> head to the People Metrics Overview - Current Month. This is accessible within the dashboard.
   • This works in the same way as the drilldown report. For example, filtering on People_Metrics_View = ‘Division` will show the breakout of all kpis in a report with divisions across the top and Denomas Overall at the end to provide a quick comparision at the division level.
     • This is great for questions like which division has high attrition, or which divisions are we behind on hiring for?
   • By filtering on People_Metrics_View = ‘Department` it will allow the viewer to dive deeper into the above questions, and determine if there is an issue at the department level.

People Metrics Data Model

The majority of the dashboard is built off bamboohr_rpt_headcount_aggregation.

This data model aggregates all relevant people metrics at 4 levels on a monthly basis:

1. kpi_breakout – this shows all metrics aggregated up to the company level
2. division_breakout
3. department_breakout
4. eeoc_breakout – this shows metrics aggregated to understand diversity metrics (i.e gender, ethnicity, region)

The underlying data to create this model is accessible to team members with access to bamboohr_analytics role and then for more sensitive data (i.e. EEOC data and compensation) bamboohr role.

Create Your Own Report:

Looking to create a report yourself, check out the demo video that walks through how to use the discovery feature in Sisense. This allows users to drag and drop fields.

A preview of this feature can also be found on the People Data Discovery Feature Dashboard