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.

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

Next add “Attrition” to the canvas.

Select Attrition

Choose Create Best Visualization

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.

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.

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

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.

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