MicroStrategy ONE

HR Summary Dashboard

This dashboard provides an overview of important human resource activities, employee attrition data, compensation data, and recruitment trends. The dashboard is organized into four tabs; each tab contains an individual scorecard for a particular user group or for a particular area of human resources. Click any of the tabs to view a scorecard. The scorecard details are as follows:

HR Summary: This scorecard provides an overview of important human resources activities and performance, including a summary of headcounts, projected attrition rates, and vacant positions.
Attrition: This scorecard summarizes employee attrition data from the general level of employee information, such as attrition trends and geographic distributions, to a detailed level, such as which employees leave and why.
Compensation: This scorecard displays an overview of compensation data from the general level, showing annual trends and the relative distribution of compensation items by division, to a detailed level, such as salary statistics by employee level, employee profile, and market salary differences.
Recruitment: This scorecard summarizes hiring data from a general level of employee-related information, such as recruitment trends and geographic distributions, to a detailed level, such as the major hiring sources and who was hired.

Dashboard layout and display

The datasets included in this dashboard are:

Headcount and Average Tenure by Department
Attrition, Hire, and Turnover Rate
Headcount and Average Tenure by Quarter
Attrition by Department
Reasons for Departure
Departed Employees
Employee Attrition - Quarterly Trend
Average Attrition Rate
Department with Maximum Attrition Rate
Salary by Employee Level
Top Performers' Salary to Industry Mode
Compensation Items - Quarterly Trend
Compensation Distribution by Division
Hires by Department
Hiring Rate - Quarterly Trend
Recruiting Sources
Q4 Hires

Usage scenarios

Use this interactive dashboard to view data related to human resources activities, attrition levels in each department, employee compensation comparison, and general recruitment scenarios. Click any of the tabs at the top to view the relevant data. For example, on the HR Summary tab, managers can get a general overview of important human resource activities.

Dashboard details

This document includes a static filter on the last year of data in the sample data warehouse.