Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Assignment Details: As an Information Technologgrr professional, much of your decisions are derived by Information Technology {IT}. IT provides knowledge based on data that help

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
Assignment Details: As an Information Technologgrr professional, much of your decisions are derived by Information Technology {IT}. IT provides knowledge based on data that help business professionals and IT managers to take better and more informed decisions. In this project. you are to utilize one of the most 1widely used business analytics tool. Tableau software package. to make a mmtber of visualizations that will help to make some specic managerial decisions. The focus of this assignment is the creation of visualization presentation and not to become an expert 1with 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, coloringrlrighlighting. etc. as you see t to best communicate your message}. Task 1: Using the Customer Service Call dataset provided with this assignment, you are to design four di'erent Tableau dashboards with the follmving specications: 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 1with the above four worksheets and name it Call-Time Analysis. Dashboard 3: Efficiency Recommendation Review the data and create a dashboard with visualization(s) that support downsizing the company for efficiency. Feel free to create as many visualization worksheets as needed to support your recommendation. Dashboard 4: Best Employee Recommendation Review the data and create a dashboard with visualization(s) that support recommending one best performing employee. Feel free to create as many visualization worksheets as needed to support your recommendation. Task 2: For your output, please post your resulting worksheets and dashboards to Tableau Public web space. You will need to make a tableau public login. Once your Tableau dashboards are uploaded on public web space, include the URL of your work on the Tableau Public web space into your report. Task 3: Write a report supporting all of your analyses. Your report must discuss each of your dashboards with adequate explanation for someone with very little to no technical knowledge to retrieve useful information for making informed decisions. Your report also must include the URL of your Tableau work.X Tableau - Book1 File Data Worksheet Dashboard Story Analysis Map Format Server Window Help Show Me X Dashboard Layout Call Type Performance Analysis Incoming Default Outgoing Phone 1(a) 1 (b) Device Preview Call Type Rep ID Rep ID Incoming E Outgoing Amanda Size Alice Xander Amanda Todd Desktop Browser (1000 x 8... . Andy Alice Brent Sharon Sheets Cam Brent In 1(a) Duke Karl [17 1(b) Eric Josh [ 1(c) George Joe [ 1(d) Andy Helga Kate ill 2(a) Joe Josh Helga 10 15 20 Objects 0 10 20 30 0 10 20 30 0 5 Calls Calls Rank of Calls 00 Horizontal Container 8 Vertical Container A Text 1(c) 1(d) Extension Rep ID Rep ID = Ask Data Cam Brent [ Data Story Andy Eric Image Susan Sandy Blank Alice Randy 8: Workflow Duke Lilly A W.LD... Data Source 1(a) 1(b) 1(c) 1(d) # Dashboard 1 2(a) 2(b) 2(c) 2(d) # Dashboard 2 Dashboard 3 1(a) (2) 2(c) (2) 2(d) (2) 2(b) (2) Sheet 13 Sheet 14X Tableau - Book1 File Data Worksheet Dashboard Story Analysis Map Format Server Window Help Show Me Dashboard Layout

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Foodservice Management Principles And Practices

Authors: June Payne Palacio, Monica Theis

13th Edition

0133801101, 9780133801101

More Books

Students also viewed these General Management questions