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., 3/1/2025) 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 may need to duplicate the ‘Ticket Number’ dimension and convert that duplicate into a measure.  To duplicate, right click the dimension, select ‘Duplicate’.  To convert into a measure, drag the duplicate into measures. using Tableau, answer the questions that follow; and delete the data file once finished.

Assuming the cross-product style, which of the following is the correct WHERE clause restricting the list of bookings to those in the first half of 2029 for male customers over the age of 40?

To restrict the output to rows where values in a column exist, you need to use which of the following after the column name?

List the names of customers and the names of guides taking them on hiking tours. Which tables must appear in the FROM clause of the query, assuming ‘Hiking Tours’ is used in the WHERE clause?

Which of the following statements about keys in the Booking table is true?

Which of the following completes the CREATE TABLE statement for the Booking table? CREATE TABLE Booking (   BookingID INTEGER,   ________________,   GuideID INTEGER,   BookingDate DATE,   Hours DOUBLE,   CONSTRAINT PKBooking PRIMARY KEY (BookingID)   CONSTRAINT FKCustomer FOREIGN KEY (________) REFERENCES Customer(CustomerID)   CONSTRAINT FKGuide FOREIGN KEY (GuideID) _______(______))

Which of the following are typically referred to as relational operators?

Which theorist proposed that adults move through a series of stages and potential crises, but emphasized that they also pass through seven stages associated with specific age periods? 

If a student is killed or commits suicide, is it common for schools to provide _________ education.

Which term refers to prejudice and discrimination directed as older people?