CS9-Data Views (Tableau)- Answer Sheet

.pdf

School

University of Massachusetts, Amherst *

*We aren’t endorsed by this school

Course

350

Subject

Management

Date

Apr 3, 2024

Type

pdf

Pages

13

Uploaded by ritamdutta

BI&A, Spring 2022 Isenberg School of Management, UMass Amherst Page 1 of 13 Business Intelligence & Analytics C ASE S TUDY 9: D ATA V IEWS This assignment is to create a number of data views in Tableau Desktop and report your analytical findings based on the data views. Create data views in Tableau Desktop and report your analytical findings. Submit your answer sheet and Tableau workbook to the Blackboard Learn by 11:59PM on Friday, April 15 th . You will use the following Excel files for this assignment: Primary source: SuperStoreUS - Sales (2014-2017).xlsx Secondary source: SuperStoreUS- Target (2014-2017).xlsx PART 1: S HIPMENT A NALYSIS Data View 1 D1a: Use Snipping Tool to take a screenshot of your data view, and then copy and paste it to your answer sheet.
BI&A, Spring 2022 Isenberg School of Management, UMass Amherst Page 2 of 13 Q1a: Which of the regions had the highest percentage of the total orders that were delayed? Which of the regions had the highest number of orders that were delayed? Explain your conclusion based on the data view. East (27.62%) had the highest percentage of the total orders that were delayed. West (429) had the highest number of orders that were delayed. Both these values were higher compared to the other regions.
BI&A, Spring 2022 Isenberg School of Management, UMass Amherst Page 3 of 13 Q1b: Which of the regions had the best shipment records? How is the region different from the other three region in terms of the number of orders processed? Explain your conclusion based on the data view. South had the best shipment records as they had the lowest percentage of late shipments (25.43%) and the highest percentage of early shipments(50%) which clearly better than the 3 other regions. South did have significantly less numbers of orders processes compared to the other three regions. Data View 2 D2a: Use Snipping Tool to take a screenshot of your data view, and then copy and paste it to your answer sheet.
BI&A, Spring 2022 Isenberg School of Management, UMass Amherst Page 4 of 13 Q2a: Is there a particular shipping method that you would recommend customers of SuperStoreUS to use more frequently? Is there any shipping method that you would NOT recommend them to use? Explain your conclusion based on the dashboard. I would recommend Same Day shipping for customers of SuperStoreUS to use more frequently as it has the least variability and is on time around 95% of the time. I would not recommend customers of SuperStoreUS to use First Class as it has high variability and also ships late very often.
BI&A, Spring 2022 Isenberg School of Management, UMass Amherst Page 5 of 13 PART 2: S ALES P ERFORMANCE M ONITORING & F ORECASTING Data View 3 D3a: Use Snipping Tool to take a screenshot of your data view, and then copy and paste it to your answer sheet.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help