Scenario: You work in HR and want to investigate an increase in employees leaving the company.
Using Oracle Analytics Server, you can do a quick Natural Language search for more information.
First you need to check attrition to show current employee turnover rate.
Click on Attrition Count
Next you add Location to the search.
Click on Location_City
Finally you add Job Role.
Click on Job Role
Mission: Use Oracle Analytics to discover why employees are leaving at an increased rate.
Click on the bar chart
Mission: Use Oracle Analytics to discover why employees are leaving at an increased rate.
Click on Open in Data Visualization
Mission: Use Oracle Analytics to discover why employees are leaving at an increased rate.
Let’s change the visualization to clarify which jobs are most affected by turnover and why.
Click on the visualization icon
Key Takeaway
Technicians have the highest turnover with the primary reason listed as no promotion/advancement.
How is performance rating impacting turnover rate?
Filter for Performance Rating
Select Performance Rating
Select levels 4 and 5, the higher performing employees
Location_CitySeattle
Location_StateWashington
Career Training0.28
Turnover Count105
Seattle and Chicago have the largest circles (higher turnover) resulting from lower employee training (lighter blue color).
Select Seattle to see more detail
Let's confirm with a more detailed visualization.
Click on the visualization icon
Change chart format to a Treemap.
Oracle Analytics provides many different visualization options and color customizations.
Let's select the Sunburst visualization
To identify the key reasons affecting employee turnover,
1. Select Reason Code
2. Click on Explain Reason Code
Key Takeaway
Technicians that have the highest performance rating have the highest turnover rate.
The high performing Technicians are leaving because they are not getting promoted to Senior Technicians.
Mission 1 complete!
Let's start by looking at forecasted turnover for the next few quarters.
Click on the + sign to open a new canvas
Filter by Date and Turnover Count.
Drag the selected Data Elements and drop onto the canvas
We see that turnover was high for the last two quarters. Now let's forecast the next few quarters.
Click on Menu icon
Forecast the next few quarters.
Select Forecast
See an increase in turnover forecasted over the next few quarters.
Click on Menu icon to add a Trend Line
Add a trend line to see overall turnover trend.
Select Trend Line
Key Takeaway
Employee turnover is forecasted to increase over the next few months unless corrective action is started.
Mission 2 complete!
To start, add Employee Training data to the canvas to see relationship between training and turnover.
1. Select the + sign
2. Click Add Data Set...
With Employee Training data added, we can enrich the data.
Click on Employee Turnover Data
Let’s enrich the state and zip code data with city data.
Select Location
Select Enrich Location with City
Click on Visualize
Drag the selected Data Elements to the canvas
- Location City
- Location State
- Turnover Count
- Career Training
Key Takeaway
There is more employee turnover in Seattle and Chicago partially due to less employee training.
Mission 3 complete!
Mission accomplished!
Key information has been identified to help reduce employee turnover rate:
Focus on promoting high performing technicians and other job roles
Focus on completing employee training, specifically in Seattle and Chicago
Next steps:
Video: Oracle Analytics Cloud: Augmented Analytics with AI and ML
Find out how you can bring the power of Oracle Analytics to your business.
Visit WebsiteThis simulator is only the beginning. Experience Oracle Analytics for yourself and access the free trial.
Access the free trial
