CS10 Dashboards (Tableau)- Answer Sheet(3)
.docx
keyboard_arrow_up
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
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
Related Questions
Please create fishbone diagram for the given case, sample in is also in the photo attached.
arrow_forward
AutoSave Off H₂C= PDPMT_PL102_06 June 2023_1 No Label ✓
File Home Insert Draw Design Layout References
X
CA
W
Paste
Clipboard
Page 6 of 7
■
Arial
B|I U
U
12 of 956 words
Q Search
✓12
ab
ab x₂ x
Font
A A Aa A
A
x ADA
А
Α
English (South Africa)
9°
Review
Paragraph
interpret facts and events differently.
Question:
3.1
3.2
View
Mailings
Help
EE F✓ = = £↓¶
≡ ≡ ≡ ~
4
Text Predictions: On
Search
5
Adapted from Kloppenborg TJ, Anantatmula V and Wells KN (2019) Contemporary Project Management
4th edition Cengage
Accessibility: Unavailable
Normal
5
No Spacing
Explain what is meant by the notion that "some conflicts on projects are useful..."
Discuss the strategies a project manager can employ to discourage or minimise
'destructive' conflict in a project management environment.
W
Styles
Heading 1
5
A Thembi Mdepa TM
Editing
Focus
Comments Editing
Dictate
Voice
Sensitivity
Sensitivity Editor
ENG
US
Editor
4x
Share
Reuse
Files
Reuse Files
V
+ 100%
08:33
2023/06/06
&
arrow_forward
I need the number of rolls sold on the open market in 12 foot rolls. From the image
arrow_forward
explain thoroughly the table/diagram
arrow_forward
How to discuss summary.
arrow_forward
BSOP 588 Managing QualityAll Assignments Course Projects, Midterm and Final ExamWeek 2 Course Project:BSOP 588 Week 2 Project Proposal (Toyota Motor Corporation)Week 3 Assignments:Week 3 Paper; Measuring Customer Service – MCS (Jan 2013)Week 3 Paper; Measuring Customer Satisfaction (July 2014)Week 4 Midterm ExamSET 1Page 1Question (TCO A) Compare and contrast the evolution of quality and the role it played in the management of U.S. and Japanese business firms from the 1950s to the present.Question (TCO B) Compare and contrast the following definitions of quality. Definition 1: Quality is the totality of features and characteristics of a product or service that bears on its ability to satisfy given needs. Definition 2: Quality is meeting or exceeding customer expectations.Question (TCO A) Explain the three core principles of total quality.Question (TCO H) Identify and discuss five differences between service and manufacturing organizations.Question (TCO B) Cite two ways that the…
arrow_forward
At Jill's Custom Cakes, the shop includes different areas for mixing, baking, decorating, and packaging. This demonstrates the importance of ______. Question 11 options: A) methods planning B) location planning C) layout planning D) capacity planning E) quality planning
arrow_forward
Complaints have come to the department manager regarding timeliness of requests for patient information and a decision must be made.
Three months ago, Community Hospital opened a 24-hour urgent-care center 10 miles away in a rapidly growing community. Kent Jones, the health information services manager, took part in the planning that included the use of a combined record and one patient identification number. The decision was made to allow electronic sharing of patient records between the facilities; however, at present it is necessary to fax some portions of the record upon request. In the past month, Kent has received four complaints from the urgent care center that records were not faxed in a timely manner.
There are 26 employees in health information services. Three full-time employees care for record activity during the day, with one employee devoted to record activity during the evening shift, when a team leader and four other employees are usually in the department. During the…
arrow_forward
Complaints have come to the department manager regarding timeliness of requests for patient information and a decision must be made.
Three months ago, Community Hospital opened a 24-hour urgent-care center 10 miles away in a rapidly growing community. Kent Jones, the health information services manager, took part in the planning that included the use of a combined record and one patient identification number. The decision was made to allow electronic sharing of patient records between the facilities; however, at present it is necessary to fax some portions of the record upon request. In the past month, Kent has received four complaints from the urgent care center that records were not faxed in a timely manner.
There are 26 employees in health information services. Three full-time employees care for record activity during the day, with one employee devoted to record activity during the evening shift, when a team leader and four other employees are usually in the department. During the…
arrow_forward
oTB Midterm Exam Spring 2022 - Word (Unlicensed Product)
File
Home
Insert
Design
Layout
References
Mailings
Review
View
O Tell me what you want to do
A Share
Clipy
fomat Pter
AabbccDd AabbCeDd AaBbC AaBbCet AaB AabceD AatbceDd Aatbcod oro
I Normal 1 No Spac Heading 1 Heading 2
Pin
BIU
X, xA
Title
Subtitle Subtie Em Emphasis intense E
Cloboard
Fent
Paragraph
Shyles
O PRODUCT NOTICE Most.of the features of Word have been disabled becase it hasnbeen activated
Activate
18. What critical thinking mistake(s) are present in the following comment? "Our biggest
competitor is spending more on marketing than we are. They have a larger share of the
market. Therefore, we should spend more on marketing."
a. Non sequitur
b. False cause
c. Appeal to tra
d. None of these
(7)
Accessibity. Good to go
10:38 AM
P Type here to search
50'F Sunny A
BANG LOUS
arrow_forward
PROBLEM-3) The Sales&Operations (S&OP) process is designed to produce a plan that all departmentswithin the organization, as well as suppliers to the organization, can work. The process is also sometimes referred toas sales, inventory, and operations planning (SIOP) to emphasize the important role that inventory can play as abuffer between sales planning and operations planning. The S&OP department of the XYZ company, that producesKLM products, estimates the sales over the next six years in thousands of packages will be as follows:
Assume that each worker stays on the job for at least one year and XYZ currently has eight workers. XYZ estimatesthat they will have 600000 packages on hand at the end of the current year. Assume that, on average, eachworker is paid TL 60000 per year and is responsible for producing 80000 packages. Inventory costs have beenestimated to be 20 KRS per package per year, and shortages are not allowed. XYZ estimates that it costs TL 2500for each…
arrow_forward
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [Book1]Sheet7
Report Created: 9/26/2020 10:43:05 AM
Engine: Standard LP/Quadratic
Objective Cell (Min)
Cell
Name
Final Value
$B$13
Obj Func AN
4135000
Decision Variable Cells
Final
Reduced
Objective
Allowable
Allowable
Cell
Name
Value
Cost
Coefficient
Increase
Decrease
$B$11
variables AN
55000
0
33
7.0000001
41.0000001
$C$11
variables AO
0
7
48
1E+30
7
$D$11
variables BN
25000
0
27
8.0000001
7.0000001
$E$11
variables BO
47000
0
35
7.0000001
8.0000001
Constraints
Final
Shadow
Constraint
Allowable
Allowable
Cell
Name
Value
Price
R.H. Side
Increase
Decrease
$B$16
LHS
55000
41
55000
10500
47000
$B$17
LHS
72000
35
72000
10500
47000
$B$18
LHS
80000
-8
80000
47000
10500
$B$19
LHS
47000
0
57500
1E+30
10500
The answers to the questions…
arrow_forward
Canvas
$55
O $65
Question 7
What is a process?
O Only A & C
OB. Process helps accomplish specific objectives.
A&B&C
OC. Process represents the way the organization executes work.
OA. Process is a set of activities.
Question 8
What is the first step in the Theory of Constraints?
hould repeat the analysis process to look for other bottlenecks.
arrow_forward
Please do not give solution in image format thanku
arrow_forward
Please walk me step by step for these problems.
arrow_forward
16. Fill in the blanks considering appropriate delivery system.
In
causes the lack of constructability review.
owner with a single point of contact for Project responsibilities, eliminating dispute resolutions.
project delivery system, constructor not involved in design process which
project delivery system provides
arrow_forward
WBS Element
Planned Value(PV)
Earned Value(EV)
Actual Cost(AC)
2.01 Airframe
48000
48000
50000
2.02 Engines
22000
21000
23000
2.03 Avionics
80000
60000
45000
2.04 Communications
30000
30000
30000
2.05 Tech. Manuals
42000
42000
48000
2.06 Spares
40000
35000
42000
2.07 Training
80000
80000
86000
Project Total
342000
316000
324000
Figure 14.1 Drug Surveillance Aircraft Project - Monthly Performance Report (October 31, 20XX)
Consider the project performance report presented in figure 14.1. What valid conclusion can you draw regarding the project schedule performance as of October 31, 20XX?
Select one:
a. The project is $26,000 behind schedule.
b. The project is 18 days behind schedule.
c. The project is $26,000 ahead of schedule.
d. The project is $18,000 behind schedule.
arrow_forward
provide AOA and AON diagram
arrow_forward
W AutoSave Off H PGDPM AA Calendar JULY 2022 Final No Label ✓
File Home Insert Draw Design Layout
2
U
Undo
Page 29 of 32
■
Paste
X
CA
Clipboard
Arial
Q Search
BIU
U
32 of 5102 words
12
References
A A Aa A
x² A
ab x₂
D✓ Av
ab
Font
Mailings
6
QUESTION THREE
QUESTION FOUR
Review
Search
English (South Africa) Text Predictions: On
17°
View Help
←
= = = 三
H↓¶
Paragraph
POSTGRADUATE DIPLOMA IN PROJECT MANAGEMENT - ACADEMIC AND ASSESSMENT CALENDAR
Normal
No Spacing
3.1 List and discuss at least 5 critical success factors for project quality management
3.2 Provide a diagram that best represents the quality management process and explain why this
process is important.
List and provide an overview of the processes in Quality Management
Styles
Accessibility: Unavailable
W
END OF PROJECT QUALITY MANAGEMENT
Heading 1
5
Thembi Mdepa TM
Comments
Editing Dictate
Focus
Voice
Sensitivity
Sensitivity
A
ENG
US
Editing
Editor
Reuse
Files
Editor Reuse Files
Share
4) b
V
+ 100%
14:01
2023/04/10
arrow_forward
One case is missing. 5 cases are req
arrow_forward
Solve All
arrow_forward
HPS3704 ASSESSMENT 2 FOR 2024 (HOSPITALITY PROJECT)
arrow_forward
full hand written plz otherwise skip..i'll give you multipke uovote
arrow_forward
%24
W WA 6.4 custom - Mat x
C The Willingnes
Zoom
Xb The daily demand for X
A clemson canvcas - Bin X
Cohnect to Canvas at X
https://www.webassign.net/web/Student/Assignment-Responses/submit?pos=D2&dep=27166051&tags=autosave#question4697815 2
->
The willingness of saddle-producers to supply saddles can be modeled as
for p < 5
= (d)s
2.194(1.295P)
for p 2 5
where S(p) is measured in thousand saddles and saddles are sold for p thousand dollars per saddle.
(a) How many saddles will producers supply when the market price is $2000?
thousand saddles
How many saddles will producers supply when the market price is $9000? (Round your answer to three decimal places.)
thousand saddles
(b) At what price will producers supply 10 thousand saddles? (Round your answer to three decimal places.)
thousand per saddle
(c) Calculate the producer revenue when the market price is $6500. (Round your answer to three decimal places.)
x million
24
(d) Calculate the producer surplus when the market price is $6500.…
arrow_forward
Create a Overview Diagram of a mock Crime Scene in the Room you are in. Your Diagram must include the following:
A Room with 4 walls, a Door, and a Window
5 Pieces of Furniture
A Person (Victim)
At Least 3 Items of Evidence of Your Choosing
A Header; which includes you name and class information (CJ 1350 Spring), and the date (Use Text Box)
A Legend (List of Evidence) (Use Text Box)
A North Arrow
arrow_forward
1. Review the attached business-focused visualization
How does the author of the visualization address the audience?
How is the purpose of the visualization conveyed?
How does the visualization use color, ordering, layout, and hierarchy to prioritize information?
arrow_forward
No written by hand solution
limitations to new cafe in a shopping centre
arrow_forward
System Analysis and Design
Q1. Amazon has its own Customer Relationship Management system (CRM). a. Describe the organization and the information system? b. Develop a preliminary problem statement
arrow_forward
Discuss the various uses for break-even analysis. (paragraph)
arrow_forward
What are the possible Market analysis and Potential Customers of a Smart Construction Vest (innovative) that has a features of Fall detection system, Health Monitoring system, Heat stress detection system, Communication system, and Location Tracking system
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Understanding Business
Management
ISBN:9781259929434
Author:William Nickels
Publisher:McGraw-Hill Education
Management (14th Edition)
Management
ISBN:9780134527604
Author:Stephen P. Robbins, Mary A. Coulter
Publisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...
Management
ISBN:9781305947412
Author:Cliff Ragsdale
Publisher:Cengage Learning
Management Information Systems: Managing The Digi...
Management
ISBN:9780135191798
Author:Kenneth C. Laudon, Jane P. Laudon
Publisher:PEARSON
Business Essentials (12th Edition) (What's New in...
Management
ISBN:9780134728391
Author:Ronald J. Ebert, Ricky W. Griffin
Publisher:PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:9780134237473
Author:Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:PEARSON
Related Questions
- Please create fishbone diagram for the given case, sample in is also in the photo attached.arrow_forwardAutoSave Off H₂C= PDPMT_PL102_06 June 2023_1 No Label ✓ File Home Insert Draw Design Layout References X CA W Paste Clipboard Page 6 of 7 ■ Arial B|I U U 12 of 956 words Q Search ✓12 ab ab x₂ x Font A A Aa A A x ADA А Α English (South Africa) 9° Review Paragraph interpret facts and events differently. Question: 3.1 3.2 View Mailings Help EE F✓ = = £↓¶ ≡ ≡ ≡ ~ 4 Text Predictions: On Search 5 Adapted from Kloppenborg TJ, Anantatmula V and Wells KN (2019) Contemporary Project Management 4th edition Cengage Accessibility: Unavailable Normal 5 No Spacing Explain what is meant by the notion that "some conflicts on projects are useful..." Discuss the strategies a project manager can employ to discourage or minimise 'destructive' conflict in a project management environment. W Styles Heading 1 5 A Thembi Mdepa TM Editing Focus Comments Editing Dictate Voice Sensitivity Sensitivity Editor ENG US Editor 4x Share Reuse Files Reuse Files V + 100% 08:33 2023/06/06 &arrow_forwardI need the number of rolls sold on the open market in 12 foot rolls. From the imagearrow_forward
- explain thoroughly the table/diagramarrow_forwardHow to discuss summary.arrow_forwardBSOP 588 Managing QualityAll Assignments Course Projects, Midterm and Final ExamWeek 2 Course Project:BSOP 588 Week 2 Project Proposal (Toyota Motor Corporation)Week 3 Assignments:Week 3 Paper; Measuring Customer Service – MCS (Jan 2013)Week 3 Paper; Measuring Customer Satisfaction (July 2014)Week 4 Midterm ExamSET 1Page 1Question (TCO A) Compare and contrast the evolution of quality and the role it played in the management of U.S. and Japanese business firms from the 1950s to the present.Question (TCO B) Compare and contrast the following definitions of quality. Definition 1: Quality is the totality of features and characteristics of a product or service that bears on its ability to satisfy given needs. Definition 2: Quality is meeting or exceeding customer expectations.Question (TCO A) Explain the three core principles of total quality.Question (TCO H) Identify and discuss five differences between service and manufacturing organizations.Question (TCO B) Cite two ways that the…arrow_forward
- At Jill's Custom Cakes, the shop includes different areas for mixing, baking, decorating, and packaging. This demonstrates the importance of ______. Question 11 options: A) methods planning B) location planning C) layout planning D) capacity planning E) quality planningarrow_forwardComplaints have come to the department manager regarding timeliness of requests for patient information and a decision must be made. Three months ago, Community Hospital opened a 24-hour urgent-care center 10 miles away in a rapidly growing community. Kent Jones, the health information services manager, took part in the planning that included the use of a combined record and one patient identification number. The decision was made to allow electronic sharing of patient records between the facilities; however, at present it is necessary to fax some portions of the record upon request. In the past month, Kent has received four complaints from the urgent care center that records were not faxed in a timely manner. There are 26 employees in health information services. Three full-time employees care for record activity during the day, with one employee devoted to record activity during the evening shift, when a team leader and four other employees are usually in the department. During the…arrow_forwardComplaints have come to the department manager regarding timeliness of requests for patient information and a decision must be made. Three months ago, Community Hospital opened a 24-hour urgent-care center 10 miles away in a rapidly growing community. Kent Jones, the health information services manager, took part in the planning that included the use of a combined record and one patient identification number. The decision was made to allow electronic sharing of patient records between the facilities; however, at present it is necessary to fax some portions of the record upon request. In the past month, Kent has received four complaints from the urgent care center that records were not faxed in a timely manner. There are 26 employees in health information services. Three full-time employees care for record activity during the day, with one employee devoted to record activity during the evening shift, when a team leader and four other employees are usually in the department. During the…arrow_forward
- oTB Midterm Exam Spring 2022 - Word (Unlicensed Product) File Home Insert Design Layout References Mailings Review View O Tell me what you want to do A Share Clipy fomat Pter AabbccDd AabbCeDd AaBbC AaBbCet AaB AabceD AatbceDd Aatbcod oro I Normal 1 No Spac Heading 1 Heading 2 Pin BIU X, xA Title Subtitle Subtie Em Emphasis intense E Cloboard Fent Paragraph Shyles O PRODUCT NOTICE Most.of the features of Word have been disabled becase it hasnbeen activated Activate 18. What critical thinking mistake(s) are present in the following comment? "Our biggest competitor is spending more on marketing than we are. They have a larger share of the market. Therefore, we should spend more on marketing." a. Non sequitur b. False cause c. Appeal to tra d. None of these (7) Accessibity. Good to go 10:38 AM P Type here to search 50'F Sunny A BANG LOUSarrow_forwardPROBLEM-3) The Sales&Operations (S&OP) process is designed to produce a plan that all departmentswithin the organization, as well as suppliers to the organization, can work. The process is also sometimes referred toas sales, inventory, and operations planning (SIOP) to emphasize the important role that inventory can play as abuffer between sales planning and operations planning. The S&OP department of the XYZ company, that producesKLM products, estimates the sales over the next six years in thousands of packages will be as follows: Assume that each worker stays on the job for at least one year and XYZ currently has eight workers. XYZ estimatesthat they will have 600000 packages on hand at the end of the current year. Assume that, on average, eachworker is paid TL 60000 per year and is responsible for producing 80000 packages. Inventory costs have beenestimated to be 20 KRS per package per year, and shortages are not allowed. XYZ estimates that it costs TL 2500for each…arrow_forwardMicrosoft Excel 16.0 Sensitivity Report Worksheet: [Book1]Sheet7 Report Created: 9/26/2020 10:43:05 AM Engine: Standard LP/Quadratic Objective Cell (Min) Cell Name Final Value $B$13 Obj Func AN 4135000 Decision Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$11 variables AN 55000 0 33 7.0000001 41.0000001 $C$11 variables AO 0 7 48 1E+30 7 $D$11 variables BN 25000 0 27 8.0000001 7.0000001 $E$11 variables BO 47000 0 35 7.0000001 8.0000001 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$16 LHS 55000 41 55000 10500 47000 $B$17 LHS 72000 35 72000 10500 47000 $B$18 LHS 80000 -8 80000 47000 10500 $B$19 LHS 47000 0 57500 1E+30 10500 The answers to the questions…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Understanding BusinessManagementISBN:9781259929434Author:William NickelsPublisher:McGraw-Hill EducationManagement (14th Edition)ManagementISBN:9780134527604Author:Stephen P. Robbins, Mary A. CoulterPublisher:PEARSONSpreadsheet Modeling & Decision Analysis: A Pract...ManagementISBN:9781305947412Author:Cliff RagsdalePublisher:Cengage Learning
- Management Information Systems: Managing The Digi...ManagementISBN:9780135191798Author:Kenneth C. Laudon, Jane P. LaudonPublisher:PEARSONBusiness Essentials (12th Edition) (What's New in...ManagementISBN:9780134728391Author:Ronald J. Ebert, Ricky W. GriffinPublisher:PEARSONFundamentals of Management (10th Edition)ManagementISBN:9780134237473Author:Stephen P. Robbins, Mary A. Coulter, David A. De CenzoPublisher:PEARSON
Understanding Business
Management
ISBN:9781259929434
Author:William Nickels
Publisher:McGraw-Hill Education
Management (14th Edition)
Management
ISBN:9780134527604
Author:Stephen P. Robbins, Mary A. Coulter
Publisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...
Management
ISBN:9781305947412
Author:Cliff Ragsdale
Publisher:Cengage Learning
Management Information Systems: Managing The Digi...
Management
ISBN:9780135191798
Author:Kenneth C. Laudon, Jane P. Laudon
Publisher:PEARSON
Business Essentials (12th Edition) (What's New in...
Management
ISBN:9780134728391
Author:Ronald J. Ebert, Ricky W. Griffin
Publisher:PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:9780134237473
Author:Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:PEARSON