Question: You are a manager in a large information systems consulting company, managing 10 employees in Reno, who each worked 50 weeks, 40 hours per week,
You are a manager in a large information systems consulting company, managing 10 employees in Reno, who each worked 50 weeks, 40 hours per week, (or a total of 2000 hours) in 2021. You want to better understand how your employees spent their time in the calendar year 1/1/21-12/31/21. Specifically, you want to be able to calculate the following: how many hours each employee spent on a series of 3 special projects during 2021. what percentage of hours worked on special projects vs total hours worked in 2021 for each employee how many years they have worked for the company You request a report from the Project Management Office, which keeps track of employee information and hour worked. You immediately receive back the following report: Screen Shot 2022-08-20 at 10.59.43 AM.png Here is the Google sheets file for this report: HANDS-ON Activity 1 Data ReportLinks to an external site. Your job is to review the report and determine how good the data is. Please do the following for this assignment: Identify ALL potentially questionable data in the table, and indicate exactly what it is about the piece of data that is questionable . Be as SPECIFIC as possible. Here is an example: Instead of saying "some data seems wrong", you might say "the value "941310" is listed as a zip code, but zip codes consist of 5 digits, whereas this value has 6 digits. For each data integrity characteristics (accuracy, timeliness, relevance, sufficient, worth it) describe whether the data in the table satisfies that data integrity characteristic. In your assessment of the characteristics, indicate if there are any desired calculations that you will not be able to perform because of the state of the data, and explain why.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
