Answered step by step
Verified Expert Solution
Question
1 Approved Answer
INQUIRY ; If for example you are given a data set like this, with instructions as shown below. What are the steps to answer this
INQUIRY ; If for example you are given a data set like this, with instructions as shown below. What are the steps to answer this in Tableau? PLEASE INCLUDE HOW TO CALCULATE TOTAL EXPENSES BECAUSE I CANT FIGURE OUT HOW TO GET PAST THAT AND INCLUDE EVERY STEP. I get stuck as to how total expenses came about. DO I NEED TO CALCULATE IT BEFORE UPLAODING TO EXCEL????? PLEASE INCLUDE STEPS LIKE I HAVE NEVER DONE TABLEAU BEFORE.
THE ABOVE IS JUST THE FIRST FEW ROWS THE DATA SET IS MUCH LONGER. Please
Analytics Mindset:
BluePlanet Inc. Travel Expense Audit
Overview
You are an internal auditor for a corporation. The company reimburses employees when they travel for work purposes using their own vehicles. To receive this travel expense reimbursement, the employee submits paperwork that lists the addresses of their departure and arrival locations, the total mileage they traveled and the total mileage to be reimbursed. If the employee has traveled to multiple locations, the paperwork will indicate the legs they traveled for the trip. A trip leg is the distance traveled between two points. For example, if an employee leaves their home, travels to one business, then visits another business and then returns home, the trip has three legs: from their home to the first business, the first business to the second business and the second business back to their home.
Using this paperwork, an employee in the Payroll Department then calculates the reimbursement, calculated as miles traveled multiplied by the IRS reimbursement rate of $ per mile. Employees are expected to track the mileage traveled to the nearest tenth of a mile. The company pays the employee the computed reimbursement amount in their next paycheck.
The head of the Audit Committee recently reviewed the companys financial data and thought the amount of employee travel reimbursement might be excessive. She asked you to conduct an audit of the travel reimbursements to see if employees are following company policies.
In the past, when Internal Audit would audit travel reimbursement expenses, the internal auditor would take a sample of the trips made by employees. The internal auditor would then use a commercial mapping service Google Maps to measure the distance between the departure and arrival locations. The auditor would then look for patterns in the sample and make recommendations based on their findings. Because of the timeconsuming nature of gathering this data, the internal auditors were only able to look at a fraction of the nearly trip legs that were made by employees in a year.
Recently, however, the head of Internal Audit learned about robotic process automation RPA RPA allows a person to program a bot to automate tasks that a human would have performed. The head of Internal Audit assigned an internal auditor to design a bot that automatically calculates the distance traveled for every trip leg. Using RPA, the internal auditor was able to collect the data for every trip leg traveled by employees for the last year. The internal auditor has given you the output from this bot to analyze in preparing your report for the head of the Audit Committee.
The output file is a labeled Casestudydataset.xlsx and contains three sheets.
The first sheet is labeled TravelSheet This sheet has columns defined as follows:
LineId: is a unique identifier for each line in the data set.
BusinessTripID: is a unique identifier for each trip an employee takes. A trip includes all legs traveled by the employee.
LineItemID: is a unique identifier for each unique trip leg on a business trip.
EmployeeID: is a unique employee number assigned to each employee.
StartAddress, StartCity, StartZip, StartState: are the beginning address, city, ZIP and state for a travel leg, respectively.
EndAddress, EndCity, EndZip, EndState: are the ending address, city, ZIP and state for a travel leg, respectively.
ReportedDistance: is the distance that the employee reported traveling between the two locations.
ValidatedDistance: is the distance the RPA bot reports that was traveled between the two locations.
The sheet labeled EmployeeData contains the employee ID first name, last name, address, and office for each employee.
The sheet labeled CustomerData contains the customer ID name, and address for each customer.
Implementing an Analytics Mindset
As you perform this case, remember the value of using an analytics mindset. An analytics mindset is the ability to:
Ask the right questions
Extract, transform and load relevant data
Apply appropriate data analytics techniques
Interpret and share the results with stakeholders
Required
Conduct your analyses by preparing visualizations in Tableau. Your analyses should answer each of the following questions and your report should address the following requirements. Make sure that you clearly explain your process and how you arrive at your con
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started