Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Task 1: Using the lCustomer Service C all dataset provided with this assignment. you are to design four different Tableau dashboards with the following specifications:

image text in transcribedimage text in transcribedimage text in transcribed
image text in transcribedimage text in transcribedimage text in transcribed
Task 1: Using the lCustomer Service C all 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 iunnber oil 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: CallTime 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. 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. What to Submit? a) Upload all of your visualization worksheets and dashboards on Tableau web space and include a link to the URL into your report. b) Submit your project report as a single PDF file format via Canvas prior to the due date.E13 X v fx C A B C D E F G H K M N Branch Call Purpose Time Block Call Type Queue Rep ID Sale Lost Call Abandoned Busy Minutes Not Ready Minutes Incoming Wait Time During Call Wait Time Calls 2 North Complaint 9:00 AM Incoming B Brent NO 1 4 South Sales Support 10:00 AM Incoming D Kate NO South Sales Support 10:00 AM Incoming Eric NO 5 South Sales Support 10:00 AM Incoming Susan NO 6 South Sales Support 10:00 AM Incoming Alice NO North Sales Support 11:00 AM Incoming A Cam NO 8 North Sales Support 11:00 AM Incoming CO Todd NO South Sales Support 12:00 PM Incoming C Sandy NO 10 South Sales Support 1:00 PM Incoming Karl NO 11 North Sales Support 4:00 PM Incoming B Brent NC W A W W A N D W N D D W WW WARN 12 South Product Support 11:00 AM Incoming Sandy NO 13 South Product Support 12:00 PM Incoming C Sandy NO 14 North Product Support 12:00 PM Incoming B Brent NO 00 00 00 00 15 North Product Support 2:00 PM Incoming B Duke NO 16 South Product Support 2:00 PM Incoming O Randy NO 17 North Product Support 2:00 PM Incoming A Joe NO 18 North Product Support 2:00 PM Incoming B Lilly NO 19 South Product Support 3:00 PM Incoming D George NO LD 00 20 South Product Support 3:00 PM Incoming D Helga NO CustomerService

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

Question

What research background do you have?

Answered: 1 week ago

Question

Be straight in the back without blowing out the chest

Answered: 1 week ago

Question

Wear as little as possible

Answered: 1 week ago

Question

Be relaxed at the hips

Answered: 1 week ago