make a visualization worksheet showing which sales reps have the largest number of outgoing calls.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

As an Information Technology professional, much of your decisions are derived by Information Technology (IT). IT provides knowledge based on data that help business professionals to take better and more informed decisions. In this project, you are to utilize one of the most widely used business analytics tool, Tableau software package, to make a number of visualizations that will help to make some specific managerial decisions. The focus of this assignment is the creation of visualization presentation and not to become an expert with Tableau visualization tool. Feel free to utilize online resources and explore Tableau website for instructional videos and demonstrations. It is important that your visualization dashboards show presentations nicely by adding the necessary elements (i.e., include title, annotations, sorting, coloring/highlighting, etc. as you see fit to best communicate your message).

Task 1: Using the Customer Service Call dataset provided with this assignment, you are to design four different Tableau dashboards with the following specifications:

Dashboard 1: Performance Analysis

a) Make a visualization worksheet showing total number of calls separated by incoming and outgoing serviced by each sales representative (Rep ID).

b) Make a visualization worksheet showing which sales reps have the largest number of income calls.

c) Make a visualization worksheet showing which sales reps have the largest number of outgoing calls.

d) Make a visualization worksheet showing which sales reps spent the busiest time (Busy Minutes) (including both incoming and outgoing calls).

e) Create a dashboard with the above four worksheets and name it Performance Analysis.

Dashboard 2: Call-Time Analysis

a) Make a visualization worksheet showing the average wait time (incoming wait and during call wait) for each of the two branches.

b) Make a visualization worksheet showing the average wait time (incoming wait and during call wait) for each of the three call purposes.

c) Make a visualization worksheet showing call volume over each of the time periods (hours) break out by two branches.

d) Make a scatter visualization worksheet showing the relationship between incoming wait time and during call wait time with time blocks as the individual data points.

e) Create a dashboard with the above four worksheets and name it Call-Time Analysis.

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme