CS10 Dashboards (Tableau)- Answer Sheet(3)

.docx

School

University of Massachusetts, Amherst *

*We aren’t endorsed by this school

Course

10

Subject

Management

Date

Apr 3, 2024

Type

docx

Pages

3

Uploaded by ritamdutta

Report
BI&A, Spring 2022 Isenberg School of Management, UMass Amherst Business Intelligence & Analytics C ASE S TUDY 10: DASHBOARDS This assignment is to create dashboards in Tableau Desktop and report your analytical findings based on the dashboards. Please submit your answer sheet and Tableau Packaged workbook to our course website on the Blackboard Learn by 11:59PM on Friday, Apr. 22 nd . To save a Tableau Packaged Workbook for this submission, please click on the File menu | Save As and choose Tableau Packaged Workbook (*.twbx) . P ART 1 E XECUTIVE D ASHBOARD D1a: Use Snipping Tool to take a screenshot of your dashboard, and then copy and paste it to your answer sheet. Q1a: In the region with the most sales, are there any states with negative profit ratios? If so, report the state(s) and their respective profit ratios. Q1b: In the region with the fewest sales, are there any states with negative profit ratios? If so, report the state(s) and their respective profit ratios. Q1c: Are there any noticeable differences between the two regions identified in Q1a and Q1b in terms of the key measures for sales performance and profit. If so, report the differences. Page 1 of 3
BI&A, Spring 2022 Isenberg School of Management, UMass Amherst P ART 2 P RODUCT A NALYSIS D2a: Use Snipping Tool to take a screenshot of your dashboard, and then copy and paste it to your answer sheet. D2b. For each of the four data views, report the dimensions (e.g., Category) and measures (e.g., Discount) used, the chart type(s) (e.g., pie chart) and the analysis type(s) (e.g., trend analysis). Complete the following table. Data View Dimension(s) Measure(s) Chart Type(s) Analysis Type(s) Data View 1 Data View 2 Data View 3 Report your analytical findings in terms of the following questions. Q2a: Are the 5 most popular products profitable? Explain your conclusion based on the dashboard. Q2b. Use the filter Category to slice the data and examine the impact of discount on sales and profit. For each product category, report 1) whether sales always increase as discounts increase; and 2) whether profit always decrease as the discounts increase. Report your conclusions based on the dashboard. Page 2 of 3
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