Blog

Tableau Problem #2 – Use the following information to answer questions 46 through 50. Assume you have been doing a departmental rotation for the past year at your company and have just rotated into the Internal Audit department.  A Senior Internal Auditor has asked for your help in evaluating employee expense reimbursements for potential violations of Human Resources (HR) and Payroll policies such as employees approving their own expense reports, or purchases from prohibited vendors, etc.. As a result, employee expense data has been extracted into the Excel spreadsheet linked below.  The data you receive is broken out as follows: Expense Reimbursement Data worksheet with the following data fields: Expense Report Tracking Number: number that uniquely identifies the expense report an expense is associated with (SC246062) Approver Employee Number: employee number of the employee that approved the expense report (EE070464) Approver Name: name of the employee that approved the expense report in last name, first name format (Cooper, Mary) Expense Approved Date: the date the expense report was approved in month/day/year format (03/12/25) Reimbursement Paid Date: the date the expense was reimbursed to the employee in month/day/year format (03/12/25) Expense Category: name of the expense category such as ‘hotels’ or ‘meals’ or ‘air’ Airline Ticket Number: number that uniquely identifies airline ticket numbers Transaction Date: date the expense was incurred in month/day/year format (03/12/25) Vendor: name of the vendor where the expense was incurred Employee Number: employee number of the employee that incurred the expense (EE070464) Employee Name: name of the employee that incurred the expense (EE070464) Department: name of the department of the employee that incurred the expense (Sales) Transaction Amount: dollar amount of the incurred expense Specifically, you are to: download and save the following data ‘Expense Reimbursement Data.xlsx’;  look through the data in Excel – this will help you become familiar with the data connect Tableau to the data; there are 13 fields with 9,176 rows in the data – before beginning, please double check the ‘Data Source’ tab in Tableau to ensure all data has been loaded. In addition, in order to perform certain distinct counts you will need to duplicate the ‘Expense Report Tracking Number’ dimension and convert that duplicate into a measure.   using Tableau, answer the questions that follow; and delete the data file once finished.

Your company has identified the following risk regarding its pricing process: “Collusion between a pricing employee and a purchaser to award contracts via insider information or kick-backs may result in financial loss.” Choose from the list below the control activity that would not help mitigate this pricing-related risk. 

Suppose you have two tables: Employees which can be considered the ‘left’ table and Departments which can be considered the ‘right’ table.  The Employees table contains information about employees, including their employee_id, employee_name, and department_id.  The Departments table contains information about departments, including their department_id and department_name. You want to retrieve a list of all employees and their corresponding department names, including employees who are not assigned to any department.  Which of the following join(s) should you use for this purpose?

Which of the following statements about the preparation and use of a Level 0 data flow diagram (DFD) is false?  

A digital factory (often using digital twins in its processes) that is connected, networked, and fully integrated creates opportunities to minimize costs of downtime and underperformance in production and to enable the best output from factory assets and employees. Which of the following is not an advantage and/or opportunity that companies see by using digital manufacturing?  

Another common red flag of fraud is journal entries that have been posted and approved by the same person which violates the segregation of duties concept.  Your client informs you that a calculation of [Posted By]=[Approved By] can be a helpful way of addressing this question.   What was the total dollar amount of journal entries posted and approved by the same employee(s)? (Round answer to the nearest whole number, e.g., 437.70 would be rounded to 438)

You’ve been asked to analyze some Human Resource and Payroll data that is stored in two different tables.  To start your analysis you join the data tables in such a way so that only matches across both tables remain (i.e., records or values that do not have a match are dropped entirely). What type of join have you performed?  

I have read and reviewed the Honorlock proctoring guidelines provided by my instructor. I understand that I am only to utilize my own knowledge at the time of this testing. I know that I am not allowed to utilize books, notes, internet or other people to help me answer questions on this exam. I further understand that my instructor will review the Honorlock videos to ensure all testing procedures are followed. I also understand that using other materials or not following Honorlock proctoring guidelines could result in academic consequences and referral for academic discipline. Furthermore, I understand that following the guidelines established is an issue of fairness to my fellow classmates and I agree that I will not violate any of the guidelines provided.

Consider the following quadratic equation: Using the standard form of the given quadratic equation, factor the left-hand side of the equation into two linear factors.

Completely factor the expression, if possible.