For the month of February, in observation of Black History Month, we’re working on creating a Diversity Dashboard.
Requirements
Business Statement:
The Executive Team believes diversity is essential to creating an environment that fosters creativity and productivity and creating a space where everyone is respected and valued. To support this effort, we are launching a Diversity Dashboard that will provide us with insights into our current employee data to help ensure we are hiring and retaining diverse talent at all levels of the organization, and determine areas for improvement.
Key Questions to Answer:
- How diverse is our organization? What percent of employees overall are diverse?
- How does this break out into diversity sub-groups (eg. women, race groups)
- What percent of employees in high-level positions are diverse?
- Are any job levels over or under-represented by diverse employees?
- Are there any trends in tenure of diverse employees?
- How satisfied are our diverse employees, and how does that compare to the overall satisfaction?
- What is the performance rating for our diverse employees and how does that compare to the overall performance rating on average?
- Would like to be able to drill in by diverse (women and PoC), PoC only, and by race group
- Are there trends in hiring of diverse employees?
- Are diverse groups over/under-represented in attrition
The Data Set:
The data set can be found here on data.world
- Attrition: Yes/No field, where yes means the person is no longer employed with the organization
- Business Travel: Openness to business travel
- Hire Date: Date employee was onboarded
- Department: Department the employee works/ed in
- Diverse: Indicates employee is a woman and/or Person of Color
- Education: Highest level of education of the employhee
- Education Field: College major, or other specialization of education
- Employee ID: Unique identifier for the employee
- Gender: Female, or Male & N/A
- Job Role: Employee’s job title
- Marital Status: Employee’s marital status
- Performance Score: String field indicating the employee’s performance rating
- Perf Score: Numerical rating of Performance Score, 1-4, with 4 being highest
- POC or POC NA: Indicates whether employee is a Person of Color
- Position: Employee’s level in the organization
- Position ID: Numerical indicator of position level, 1-6, with 1 being highest
- Race Desc: String field indicating the employee’s race
- Age: Employee’s current age
- Emp Satisfaction: Employee satisfaction score, 1-5 with 5 being highest
Inspiration:
Check out the HR Diversity Dashboard accelerator on the Tableau Exchange
merci