Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started