Oracle Analytics Data Visualization Gallery

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Out of Policy Expense Analysis

Data Visualization
81
Views
3
Comments
Discussion thumbnail

I created this visualization using this OAC_TD_Expenses.xlsx dataset from this Oracle LiveLabs Workshop.

However, I did not follow the workshop and made my own scenario with the data:

You are an accountant for a company.
Management wants to better understand employee expenses.
The company has agreements with certain vendors to save money (in-policy vendors), but employees do not always have to use these vendors and may use out-of-policy vendors.
You are given access to the employee expense records of the past few months in Oracle Analytics.
Your mission is to analyze employee expenses and give management suggestions on what can be done to reduce employee expenses. If you see areas that have an opportunity for process improvement, point those out too.
You will use Oracle Analytics to perform this task.

With this visualization, I was able to conclude the following:

- Speak to the Sales department on why they are using out-of-policy hotels, such as "Porto City Center." Is it because the hotels are close to customers? Interviewing the department and the employees that stayed here may lead us to consider working out an discount agreement with the hotel to save money in the future.
- Suggest to the team that maintains the employee expense application that we should remove the "Other-Misc" option. Having this category as an option is inhibiting further analysis.

Editing to add a few helpful hints:
Select a template upon opening the workbook, and change the workbook theme.
Choose a color scheme before you start (versus after). Seeing a fresh color scheme helps me be more creative when mocking up these demos.

3
3 votes

Data Visualization · Last Updated

Default status for visualizations

Comments