Building the English Premier League Table with Power BI 

Very welcome

Hi Laio, Glad you enjoyed it. - Mark

My pleasure! Thanks Rafael.

Glad you enjoyed it

HI Nara, Thanks for watching! - Mark

Hi Nara, These links may be useful. EPL Football Resources and Links League Tables www.bbc.co.uk/sport/football/tables www.premierleague.com/tables EPL Match Data from www.football-data.co.uk/englandm.php www.premierleague.com/results www.bbc.co.uk/sport/football/premier-league/scores-fixtures/2019-09 Other EPL stats available at footystats.org/england/premier-league

Glad you enjoy it!

Muchas Gracias

@@LondonBusinessAnalyticsGroup Sería bueno incluir un Rank by Points DG en GF

Thanks Jefferson, please do share the link. - Mark

Jefferson Ramos Where did You get data for Seria A?Can you send me that so i can practice? Where do you put your projects?Thanks in advance

Hi Aslan, to summarise over two separate tables, perhaps use a DAX measure to do this? - Mark

@@LondonBusinessAnalyticsGroup Where is the raw data , Sir? How we pull it ? Thanks

Hi Steve, We're going to do this on the LBAG sessions on 1st & 2nd June probably (and also in SQL, R and DAX) and we'll have a video out a few days after that. It's a harder challenge, we have to add an index to list *each* team in reverse date order, filter that less than or equal to 5 for the last 5 matches, pivot the remaining rows then append the resultant 5 columns. And we can't use the Query Editor UI for all of it. So too much to do in the session last week but we are devoting another session to it soon. - Mark

Hi Keegan, we post details of our upcoming live sessions on our meetup page at www.meetup.com/London-Business-Analytics-Group/- Mark

Hi A J, In short, use the DAX RANKX() function, or sort the teams in the query editor then add an Index column. We will be covering ranking in a future video. - Mark

Hi Nicolae, Great footy data at www.football-data.co.uk/

Hi Dave, I don't know the exact rules but it sounds like you need to use DAX to calculate a ratio of [Total Points] / [Total Number of Games]. - Mark

Hi Pieter, the original match record states if teams are home and away so you can do this. Interestingly, my analysis showed that there is home advantage - apart from the 20-21 season when most matches were played without the spectators. The fans do help the team win!

@@LondonBusinessAnalyticsGroup thank you and take care. All the best from Holland

If I have a table with 2 colums (player and team) and in the match stats the first, second etc goal scorer home and away. Is it possible to create a relation between player and first goal scorer and so on for the second goal scorer etc. Or is this not a good approach ?

Three time suggests you are getting a row for win, draw and lost. Check your merge.

Same here. Could someone explain what he did for Drawn??

Hi inquisitiveYT, Angel, to do the summation, I used Group By Transform in the Query Editor. OOn suggestion - download the PBIX - link to the file in the video description - and open it up and look inside to see how it all works. Mark

@@LondonBusinessAnalyticsGroup Thank you.

Hi Валентин , You will need a DAX measure like this Average Goals For Over Last 5 Matches = SUMX( FILTER( 'Team Stats', 'Team Stats'[ReverseDateIndex]

HI Jackson, I'm not quite sue what you mean by goal week. In theory, yes it is possible to make dynamic tables, but if you were to give more details or a sketch, I could be more specific. - Mark

@@LondonBusinessAnalyticsGroup Yes I have dynamic tables but most of them are bar graphs .I want a graph like a cricket scoreboard where teams score increase with overs .like wise every week the pts of each team in different colour and a symbol .so you get the idea of different top position for each week .

@@jacksonk7362 Yes, you should be able to do a cricket-scorecard - you may need to use a combination of three visuals: cards; tables and matrixes.

Hi Violeta. Go to bit.ly/33zWQtp​ then navigate to the "Football" folder.. This folder contains the Excel data and also a link to the original source data if you want up-to-date data. Mark

@@LondonBusinessAnalyticsGroup And since the file is read-only, how can I unlock it to put my Spanish league data? Thanks again.