The Campeonato Nacional de Liga de Primera Divisin, commonly known simply as Primera Divisin in Spain, and as La Liga in English-speaking countries, is the men\'s top professional football division of the Spanish football league system. Administered by the Liga Nacional de Ftbol Profesional, it is contested by 20 teams, with the three lowest-placed teams at the end of each season being relegated to the Segunda Divisin and replaced by the top two teams and a play-off winner in that division. Since its inception, a total of 62 teams have competed in La Liga. Nine teams have been crowned champions, with Barcelona winning the inaugural La Liga and Real Madrid winning the title a record 35 times. According to UEFA\'s league coefficient rankings, La Liga has been the top league in Europe in each of the seven years from 2013 to 2019 (calculated using accumulated figures from five preceding seasons) and has led Europe for 22 of the 60 ranked years up to 2019, more than any other country. It has also produced the continent\'s top-rated club more times (22) than any other league in that period. The competition format follows the usual double round-robin format. During the course of a season, which lasts from August to May, each club plays every other club twice, once at home and once away, for 38 matches. Teams receive three points for a win, one point for a draw, and no points for a loss. Teams are ranked by total points, with the highest-ranked club crowned champion at the end of the season. You are a Management Consulting Company who has recently been hired by the Liga Nacional de Ftbol Profesional, Management Team, and you have been asked to help the La Liga analyze the data from the website and help the Management Team in their decision-making Process. The data can be found from the following website links (you will have to navigate for respective years to get 2019, 2020 and 2021 data): ?The League Standings: https://www.espn.com/soccer/standings/_/league/ESP.1/season/2021 ?League Statistics: https://www.espn.com/soccer/stats/_/league/ESP.1/season/2021 ?Stats (Discipline Points): https://www.espn.com/soccer/stats/_/league/ESP.1/season/2021/view/discipline Questions: For the 1st Part of your Group Project Submission due on Week 5, you will need to submit an excel file answering the Questions 1,2, 3 & 4. For the Final Submission you will need to submit a Powerpoint deck answering all the questions below and any additional insights that you can provide, along with the full excel working file As a management consultant, here are your objectives. 1.Copy the following data from the Website links (given above) onto an excel file for the years 2019, 2020 and 2021: (While doing so, please create separate tabs in the excel file called Raw Data where you are copying or creating the original data from the Website) a.Top Assists b.Top Scorers c.Discipline d.League Tables 2.Create a professional looking data table from the information that you can copy from the ESPN Website. Name these input data professionally as separate tabs in the working excel file. 3.Create a Cleaned-up Master League Table for Each Year for 2019, 2020 and 2021. (Hint: The master league table should look like the following) a.Shows the Club Name, the Club Abbreviation if any, the League Rank for each year, the details of the points table. (The Table below is shown for representational purpose only and does not show club names participating in La Liga) 4.Bring over the Discipline Points from Disciple Points Tables for each year into the master table corresponding to each Team. (e.g., any Yellow Cards, Red Cards, Discipline points). The Table for each year should now look like the following: (There will be three tables each for 2019, 2020 and 2021). Please note the table below is shown for representational purpose only and does not show club names participating in La Liga 5.Create a Master League Table for 3 years, use the combined league points and discipline points for the La Liga clubs to create trends for the Top 5 clubs for 2019, 2020 and 2021. a.Hint 1. If a certain club did not qualify for the La Liga in a Year, please keep the corresponding cells vacant for that year b.Hint 2. Use the three tables created in Step 4 to create the Master table with 3 year totals 6.In the Master League Trend Table, create the following columns a.Three Year Total League Points b.Three Year Goals Scored c.Three Year Goals Against Plot the Three Year Total League Points, Goals Scored and Goals Against on three separate Column Charts. Answer the following questions: ?Which is the best performing club in the last three years in terms of League Points ?Which is the best performing club in terms of Goals Scored ?Which is the worst performing club in terms of Discipline Points (Note, that higher discipline points means a worse position for the club) 7.Using the Top Scores and Top Assists Tables, create the total goals scored, and total assists by each team and sort them in descending order for each year. (Hint. Use pivot tables). What is the trend for each team for three years? (Show the trend of the top 5 teams by goals scored, using a trendline on a column chart) 8.Can you think of creating any other performance indicator (Metric) which you can compare between these clubs. Think creatively and use the data from the tables

Attachments:

group-project....docx