Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

Q5

file attached. 

Building a Baseball Statistics Data Dashboard. The Springfield Spiders, a baseball team in the All American Baseball Association, wants to create a data dashboard for its fans. Spiders management would like the fans to be able to review the runs scored and allowed by game, and review the number of wins and losses and the average per game attendance by opponent and by day of the week. They would also like for the fans to be able to filter each of these displays by home and away games.

The Spiders have collected data on the date, opponent, whether the game was played at home or away, how many runs the Spiders scored, how many runs the Spiders allowed their opponent to score, whether the Spiders won or lost, and the attendance for each game of the previous season. They also added a field for the day of the week, and have created the following charts for inclusion in its data dashboard.

A line chart of runs scored and runs allowed by game (in the Chart1 worksheet)

A clustered column chart of number of wins and losses by month (in the Chart2 worksheet)

A clustered bar chart of average per game attendance across months for home and away games (in the Chart3 worksheet)

A clustered bar chart of average per game attendance across days of the week for home and away games (in the Chart4 worksheet)

1. Create a data dashboard for the Spiders by creating a new worksheet and naming it Dashboard; moving the charts from the Chart1, Chart2, Chart3, and Chart4 worksheets to the Dashboard worksheet; and repositioning the charts on the Dashboard worksheet, adding a title to the dashboard, and doing whatever formatting and editing is necessary to make the dashboard functional and visually appealing.

2. Amend the data dashboard you created in part b in the following ways.

i. Create a slicer to filter day of the week for the charts created in the Chart1, Chart2, Chart3, and Chart4 worksheets

ii. Create a slicer to filter opponent for the charts created in the Chart1, Chart2, Chart3, and Chart4 worksheets

iii. Create a slicer to filter month for the charts created in the Chart1, Chart2, Chart3, and Chart4 worksheets

iv. Create a slicer to filter home and away games for the charts created in the Chart1, Chart2, Chart3, and Chart4 worksheets

Once you have amended the data dashboard, rearrange the charts and slicers to create an effective and visually appealing dashboard. Test each slicer to ensure it works on the appropriate charts

3. Create an alternative display of the Runs Scored and Runs Allowed by game through the following steps.


STEP 1

Create the new field Run Differential in Column I of the SpidersData table by subtracting Runs Allowed from Runs Scored for each game

Refresh all PivotTables and PivotCharts


STEP 2

Create a new worksheet and rename the worksheet Chart1A

Create a new pivot table and pivot chart in the Chart1A worksheet

Drag the Date field to the Rows area and the Run Differential field to the Values area in the PivotFields Table pane to create a column chart

Right click the horizontal axis and click Format Axis… to open the Format Axis pane, click the Axis Options button and click Labels, then select Low from the Label Position dropdown menu to position the horizontal axis at the bottom of the chart

While still in the Format Axis task pane, click the Axis Options button and click Fill & Line, then in the Line area change the color of the axis to black and increase its width to 2 pt

Click any bar in the chart and click Format Data Series, click the Fill & Line button, and in the Fill area click the Invert if Negative box and select the colors to be applied to the positive and negative bars


STEP 3

Replace the line chart on the dashboard that was originally created in the Chart1 worksheet with the chart you created in the Chart1A worksheet.

Comment on differences between the resulting dashboard and the dashboard from part b.

4. Protect the data dashboard in part c from being revised by users. Ensure that the slicers cannot be resized or moved, password protect the Dashboard worksheet (use the password Problem823), and hide all worksheets except the Dashboard worksheet.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

4/6pg

Your company Acme Logistics has recently been experiencing some thefts of equipment during the business day. All employees have been asked about the thefts and no one is claiming that they are responsible. Your facilities has three doors that are not locked during business hours and currently have no identification

Computer program

Kenya Forestry College [email protected] P.O. BOX 8 -20203, Londiani Tel .No.0202349901, 07232262 APPLICATION FOR TRAINING PROGRAMMES 2019/2020 Applications are invited for the following training programmes to be offered at Kenya Forestry College, Londiani commencing on the given dates. S/ n Programme Entry Requirements Duration Commencement Date Total Cost (Ksh) 1

Wk5_492

Need help with a question. Imagine that you are hired as an Ethical Hacking Consultant by your organization. You are asked by the top management to compare two object-oriented programming languages and create a presentation about your findings and suggestions. Use your problem-solving skills and  integrate your knowledge of web application testing

Computer Science

What is computer science  Science? what is the benefit of computer science?

6/8p

Running head: GUIDED IMAGERY AND PROGRESSIVE MUSCLE RELAXATION 2 Research Paper Topic: · Legal and legislative issues associated with biometric industry Instructions: · Prepare a 6-8 page paper in Microsoft Word using approved APA format. · The minimum page count cannot not include your Title page and Reference list. ·

week 7 Discussion and Replies

Please review the instructions for the assignment     WK7 Discussion Instructions: Database Failures and Timestamp Protocol  250 words total, answer the questions below with 4 evidence base scholarly articles. APA format, due 19 Dec 24.  1. Discuss the different types of failures. What is meant by catastrophic failure? 2.

Capstone B

Assessment 1 & 4 This file is too large to display.View in new window

hrmt

  how can organizations address change management in the workplace such that healthy stress is created? Be creative in your answer! You may find appropriate articles at the end of each chapter, and/or identify articles through the APUS online Library. Finally, be sure that all discussions are answered in full,

help

can u build a project for me based on the description given  below

help

can u build a project for me based on the description given  below

apple vs fbi

read this article Explain, based on the article and additional research, whether you agree with the FBI or Apple and why. Describe a possible compromise to the issue for future cases that would allow the investigation to continue. Take a position on whether technology is moving too fast for the

excel module 3

who can complete homework  assignment  by 4pm today  excel module 3 Documentation Shelly Cashman Excel 2019 | Module 3: SAM Project 1a Raybridge Recruiting CREATE A SALES REPORT Author: Theresa Cobb Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new

excel module2

who can complete this assignment by 4pm today  Documentation Shelly Cashman Excel 2019 | Module 2: SAM Project 1a Roadrunner Online FORMAT WORKSHEETS Author: Theresa Cobb Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from

Excel module 1

can anyone complete this ASAP or by tomorrow Documentation Shelly Cashman Excel 2019 | Module 1: SAM Project 1a New Era Medical COMPLETE A BUDGET SUMMARY WORKSHEET Author: Theresa Cobb Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy

bcis

IfSuccessful_Status GA_Status_Icon SAM_Logo true false ID FirstName LastName AssignmentGUID UserID false rohan maharjan {308B14B0-E32E-42D1-BE7D-54EE2E09B8CD} {308B14B0-E32E-42D1-BE7D-54EE2E09B8CD} ID FirstName LastName ProjectName SubmissionNum MaxScore Score EngineVersion ID StepNumber Description IfSuccessful StepScore StepMaxScore ErrorText ActionName StepActionOrder ConsultantID FirstName Last 110345 Jenette Masterson 110347 Victorina Hogg 110349 Marguerite Hathcock 110351 Sid Ortiz 110352 Glenn Testani

WK6 Discussion

Please see attachment instructions to complete the assignment.     WK6 Discussion Instructions: Cost Functions and Record Lengths    250 words total, answer the questions below with 4 evidence base scholarly articles. APA format, due 15 Nov 24.  1. Discuss the different types of parameters that are used in cost

Enterprise Networking

ICT3051 Enterprise Networking Week-8 Laboratory Practicum 1 Configuring Quality of Service Task Use the following video to configure your own packet tracer file. Make sure everything in it works. Name the file with your name and student id. Reflect on the configuration experience by explaining what kind of problems you

Scott Tyree (2002)

You have been asked to conduct research on a past forensic case to analyze how digital data was used to solve the case Scott Tyree (2002). Summarize the case, pertinent actors, evidence, and facts. Outline the specific digital evidence used in the case. Describe the procedures and tools used to