Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please complete the ETL process of 2018 through 2022 NFL data provided in the links below, appending the queries such that you have one

image text in transcribedimage text in transcribedimage text in transcribed

Please complete the ETL process of 2018 through 2022 NFL data provided in the links below, appending the queries such that you have one cleaned and compiled set of data to analyze. Using the 2018 thrugh 2022 season data, please answer the questions below and build a dashboard of the analysis on the Dashboard worksheet. The dashboard should include connected slicers (to all of the visualizations) including team, week, Home/Away, season and a timeline. Please be sure that your analysis includes the most recent 2022 data. Data can be imported from Pro Football Reference: https://www.pro-football-reference.com/years/2018/games.htm https://www.pro-football-reference.com/years/2019/games.htm https://www.pro-football-reference.com/years/2020/games.htm https://www.pro-football-reference.com/years/2021/games.htm https://www.pro-football-reference.com/years/2022/games.htm Note: All answers must reference the analysis. All references should refer to a single cell (not an array) as spill values cannot be read by the grader. Teams that have changed cities or names should be considered the same team. Please analyze the top 5 Teams (in descending order) for the following: average points, average turnovers, average yards. Please create a pivot row chart for each of these and include it in the dashboard. 1) (10 Points) What are top 5 teams with average points per game over the 2018 through 2022 seasons? Please order descending by average points per game. 1 2 3 4 5 Please use data validation for these answers. 2) (10 Points) What are top 5 teams with average turnovers per game over the 2018 through 2022 seasons? Please order descending by turnovers per game. 1 2 3 4 5 Please use data validation for these answers. 3) (10 Points) What are top 5 teams with average yards per game over the 2018 through 2022 seasons? Please order descending by average yards per game. 1 2 3 Please use data validation for these answers. 4 5 Please analyze average points, average turnovers, average yards by week over the 2018 through 2022 seasons. Ensure that the data are ordered in the appropriate sequence. Please create a pivot line chart for each of these and include it in the dashboard. 4) (30 Points) What are average points, turnovers and yards over the 2018 through 2022 seasons? Please order by week of the season. 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 WildCard Division Average Points Average Turnovers Average Yards ConfChamp SuperBowl Let's analyze the number of wins, ties, and losses in the regular season (excluding playoff data) of the Minnesota Vikings from 2018 through 2022. 5) (20 Points) Please complete the following table with the number of regular season wins, ties and losses for the Minnesota Vikings from 2018 through 2022. Win Tie Loss 2018 2018 2019 2020 2022 Let's analyze the number points for each win, tie, and loss in the regular season (excluding playoff data) of the Minnesota Vikings from 2018 through 2022. Group the number of points in seven point intervals and calculate the frequency (count) for each group. Please provide a column chart of the analysis. 6) (20 Points) Please complete the following table with the frequency of points in regular season wins, ties and losses for the Minnesota Vikings from 2018 through 2022. 0-6 7-13 Win Tie Loss 14-20 21-27 28-34 35-41 42-48

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

Effective small business management An Entrepreneurial Approach

Authors: Norman M. Scarborough

10th Edition

132157462, 978-0132157469

More Books

Students also viewed these General Management questions

Question

Propose a reasonable mechanism for the following reaction. OH

Answered: 1 week ago

Question

Spend less time in group decision making

Answered: 1 week ago

Question

Emphasize opportunities and choices

Answered: 1 week ago

Question

Discuss individual rewards and goals

Answered: 1 week ago