© Oracle Terms of Use and Privacy
Ad Choices
0
Back

Scenario: You work in HR and want to investigate an increase in employees leaving the company.

Start your Oracle Analytics Server Simulation

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.

Accept your first mission

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!

Get your badge

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!

Get your badge!

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!

Get your badge!