#87 Messi / Inter Miami / Major League Soccer - Power BI dashboard
Now Messi went to the USA to play for Inter Miami in the Major League Soccer (MLS), I wanted to know more about this club and competition and decided to make Power BI dashboard for it, after having updated my Looker/Google Data Studio dashboard 'Messi Goal Tracker' to include his goals for Inter Miami (see this post)
I googled on MLS and API and found this nice API website:
https://sportsdata.io/developers
from which you can get data for free for a big part, although some data is scrambled and only available if you pay)
With the data of some of the API-endpoints of this site I was able to create this dashboard:
In this pic you can see 2 pages of the dashboard:
-1: the competitions Inter Miami plays in, so beside MLS also the League Cup (international competition with besides clubs from the USA also clubs from Mexico and Canada)
-2: bubble-chart with total number of US-clubs in MLS per US-state.
And here some pics of other pages in the dashboard:
This ArcGIS filled map shows the number of players from Inter Miami that come from that country (lighter color in map means higher value), which shows e.g. that there is one Dutch player, Nick Marsman (played before for Feyenoord), although this info looks to be outdated (Marsman already left Miami). And with a right-click on a country, you activate the drill-through feature that leads you to another page of the report, with player-info, that is pre-filtered with the country that you selected.
And here the full details of the MLS-teams and of the Inter Miami-players:
Some more details about the datasource of this dashboard, so the Sportsdata.io soccer API-endpoints:
https://sportsdata.io/developers/api-documentation/soccer
The API-endpoints I needed, I stored it API-tool Postman.
NB: for a Postman-tutorial, see e.g. this video
And this API-call information I then copied from Postman to Power BI, in datasources of type 'Web', including the parameters of the API-call, e.g. team Inter Miami = 2363:
NB:
For some more details on how to work with parameters in Power BI / Power Query, see e.g.:
https://learn.microsoft.com/en-us/power-query/power-query-query-parameters
https://msdynamicsworld.com/story/use-parameters-and-custom-functions-call-apis-power-bi
Messi shows he is still in a good shape, see e.g. his first goal for Inter Miami, and David Beckham's reaction:
https://www.tiktok.com/@_forca_barca/video/7258589957751655682
Here's the API-output (json-format) for that goal:
MLS soccer will be happy that Messi has chosen for the US to finish his career as earlier other soccer legends did, as Cruyff, Pele, Beckenbaur and more recently, Beckham, see:
https://en.prothomalo.com/sports/football/38nc6f2jmd
Embedded Power BI dashboard
NB: I also published it on the Power BI Data Stories Gallery:
Messi / Inter Miami / Major League Soccer - Power ... - Microsoft Fabric Community
Download
No comments:
Post a Comment