Welcome HR pro!

Here’s the scenario: While traveling, your CHRO receives an alert that employee attrition has risen.

Next

She can see attrition has risen by 9%

Next
Show me the attrition by department

She asks in natural language what the attrition rate is by department.

Next

She immediately receives the results and tasks you with a mission to figure out:

  1. Who is leaving the company?
  2. Where are they located?
  3. Which department is most affected?

So that you can take action to reverse the trend.

Start Quick Tour

Using Oracle Autonomous Data Warehouse and Oracle Analytics you will complete 3 objectives:

  • Load your Autonomous Database and prepare data for analysis
  • Analyze attrition and employee sentiment across multiple dimensions
  • Analyze the impact on revenue and take action by identifying highest risk employees

You are now autonomous. Let’s go!

Start Objective 1

Start by loading a new dataset into your Autonomous Data Warehouse.

Click Create

Click Data Flow

Select Open to upload the “Employee” dataset.

Click the + symbol to join your newly uploaded “Employee” dataset to the already existing “Revenue” and “Survey” datasets.

Click Join to connect them.

Click the + symbol to complete the dataflow.

Click Save Data to save your dataset.

Objective 1 Complete

Nice work! You have successfully uploaded a new dataset to Autonomous Data Warehouse and joined it with two others to create a new multi-dimensional dataset for your analysis.

Now let’s analyze attrition and employee sentiment across multiple dimensions.

Start Objective 2

Let’s create your first visualization.

Click Create

Click Project

Click Add to Project to add your new multi-dimensional dataset.

To examine the relationship between “Employee Count”, “Department”, and “Work Life Balance”, drag them to the visualization canvas.

Now let’s add “Performance” to the canvas.

Select Performance Rating

Select Pick Visualization

Choose Bar Graph

Add to Selected Visualization
Create Best Visualization
Pick Visualization
Create Filters

Next add “Attrition” to the canvas.

Select Attrition

Choose Create Best Visualization

Add to Selected Visualization
Create Best Visualization
Pick Visualization
Create Filters

Now let’s take a look at “Job Satisfaction”.

Select it and drag to the canvas

We already know that the sales department is the most impacted by the attrition, so let’s refine these results to sales department only.

Drag Department to the filter area

Select Sales

Repeating this process, you can make countless visualizations to tell the full story and answer questions.

Let’s analyze examples to shed light on attrition and employee sentiment within the company.

Click Attrition Analysis tab

Performance ratings are distributed as expected, and we see no difference in satisfaction by gender, location or management hierarchy.

Next

Key Insight

However, satisfaction and work-life balance scores are low for high-performing employees that have not been promoted nor had a salary increase in the past 3 years. This group is represented in 80% of those that have left the company voluntarily.

Next

To drill deeper, click on the Employee Sentiment tab.

Key Insight

Thanks to the natural language processing capabilities within Oracle Analytics and Autonomous Data Warehouse, we now clearly understand overall employee sentiment, and have identified the most likely drivers of attrition:

  1. Compensation
  2. Career progression
  3. Work-life balance
Next

Objective 2 Complete

Nice work! Using Autonomous Data Warehouse you analyzed attrition and employee sentiment across multiple dimensions.

Let’s move on to Objective 3 and analyze the impact on revenue and take action by identifying highest risk employees.

Start Objective 3

Now that we know who is leaving and why, it’s time to figure out the potential financial impact it could have on the organization.

Click Attrition Impact tab

Key Insight

We immediately see a sharp drop in sales revenue in France, correlated with lower satisfaction scores for the region.

Next

Take Action!

By combining finance data and HR data, we can see the reasons for the attrition and the impact that it has had on the business. Now we can bring the France sales manager into the conversation and create a plan to reverse the trend.

Click Turnover Prediction tab

Using predictive capabilities in Oracle Analytics and Autonomous Data Warehouse, let’s drill into a scatter plot of individual sales employees to visualize the top performers at risk of leaving.

Click Predictive Turnover chart

Your Recommended Action

Now we know who is at risk, we can take action to retain them. Your suggestion to management is:

  1. An ad-hoc tactical campaign in France to identify and retain top performers
  2. A strategic initiative to improve work-life balance, career progression and compensation
  3. Development programs targeted at high performing employees with 2-3 years tenure
Finish!

Mission accomplished!

HR

Thanks to the ease of use and power of Oracle Autonomous Data Warehouse you have successfully discovered who is leaving, from where, why they are leaving, and have put in place measures to reverse the attrition trend. All without needing to involve IT.
You are autonomous.

Next step:

This simulator is only the beginning. Uncover the full potential of Oracle Autonomous Data Warehouse by signing up for a free trial.

Access the free trial
/31
© Oracle | Terms of Use and Privacy |
| Ad Choices