Tableau Problem #2 – Use the following information to answer…
Tableau Problem #2 – Use the following information to answer questions 46 through 50. Your company has outsourced its IT Help Desk function to a third-party provider. You have been asked to analyze not only whether the third-party provider has been addressing Help Desk tickets in accordance with stated service level agreements but also how your company personnel have been using the IT Help Desk department. To aid in your analysis, IT Help Desk ticketing data has been extracted into the Excel spreadsheet linked below. After briefly reviewing the data you notice that the data includes fields such as ticket number, requestor name, severity, satisfaction score, ticket creation date, etc.. The data set you receive is broken out as follows: Help Desk worksheet with the following data fields: Ticket Number: number that uniquely identifies a help desk ticket (e.g., 411-8513-9) Requestor Name: name of the employee in last name, first name order who is requesting help (e.g., Price, Joe) Ticket Group: classification of the help desk ticket (e.g., Hardware, Software, etc.) Issue Category: category classification of the help desk ticket (e.g., Access/Login, Software, etc.) Severity: classification of the ticket severity level (e.g., 0-Unassigned, 1-Low, etc.) Days Open: number of days the help desk ticket was/is open (e.g., 15) Requestor Satisfaction Score: classification of the requestor’s satisfaction with help desk ticket resolution (e.g., 0-Unknown, 2-Satisfied, etc.) Date Created: date the help desk ticket was created in month/day/year format (e.g., 03/1/2022) Specifically, you are to: download and save the following data ‘IT Help Desk Ticket Data.xlsx’; look through the data in Excel – this will help you become familiar with the data connect Tableau to the data and then drag the Help Desk worksheet onto the Tableau canvas; The data has 8 fields with 9,863 rows. Before beginning, please double check the ‘Data Source’ tab in Tableau states 8 fields with 9,863 rows to ensure all data has been loaded. In addition, in order to perform distinct counts you’ll need to convert the ‘Ticket Number’ dimension into a measure. using Tableau, answer the questions that follow; and delete the data file once finished.
Read Details