1 Reply Latest reply on Apr 21, 2019 8:44 PM by Rodrigo Calloni

    la liga soccer data

    o russell
    o russell Apr 21, 2019 6:07 PM

      Hi All,

       

      Firstly, thanks for reading my post. Secondly, I don't play soccer neither do I under anything about the game. I want to recreate the dashboard (attached) but I don't understand how to lay out the data to be able to achieve that and how would this play out in Tableau because, unlike regular sales or other corporation data, I don't have a primary key to play with. This is a new paradigm for me. Any input/suggestion would be appreciated.

       

      Thanks in advance,

       

      Russell

       

      Details:

      Assumptions:  
      - Every win game gives 3 points.
      - Every draw game gives 1 point.
      - Every lost game gives 0 points.  

      At the end of every year the teams can go to European competition by this order:  
      - Position 1-4 Champions League 
      - Position 5-7 Europa League 
      - Position 8-17 No competition 
      - Position 18-20 Lose category

      Column Headers:
      puntos totales - total points
      partidos jugados - played games
      Goles en contra - Goals against
      Partidos empatados - Tied matches
      partidos ganados - won matches
      partidos perdidos - lost matches
      Goles a favor - Goals in favor
      • 62 Views
      • Categories: Calculations, Data Sources & Connections, Formatting & Display, Views & Dashboards
      • Tags:
        • 1. Re: la liga soccer data
          Rodrigo Calloni
          Rodrigo Calloni Apr 21, 2019 8:44 PM (in response to o russell)

          Hello Russell

           

          I pivoted the data in Tableau and build some extra fields to:

           

          1 - Get a proper Round number (the number that comes in ( ) next to the team name

          2 - Define the Home and Away teams

          3 - Define the point logistic that you mention (3 points win, 1 draw, 0 lost)

          4 - Define the final classification table sections.

           

          I also built some charts to show you how you can use the dataset to build ranks or follow the growth in points by each round (2 table calculations).

           

          I hope these helps

          Rodrigo