19 Jun 2024

PowerBI-report UEFA Champions League Titles by Team, history (seasons 1955-56 to 2023-24, winner: Real Madrid)

#89 PowerBI-report UEFA Champions League Titles by Team, history (seasons 1955-56 to 2023-24, winner: Real Madrid)


On 1/6/2024, Real Madrid won the UEFA Champions League (UCL) final from Borussia Dortmund, and with this its 15th UCL-title (!).

I made a Power BI dashboard with all teams that won the UCL (before 1992 called European Cup), from the first season, 1955-56 until now (season 2023-24), here some screenshots.
NB: at the bottom of this blog-post I included the dashboard (embedded, interactive version) + download-URL.




With filter on Country = Netherlands (country #4 in ranking #UCL-victories per country):


 

You can do a drill-through for Real Madrid (-bar) to see the details of all Real Madrid's UCL-victories:







To see how Real Madrid got to these 15 UCL-titles over time, I made a chart with the cumulative # titles.
In this chart you can see e.g. that Real Madrid won the first 5 UCL-finales in a row (with Real Madrid -legend Di Stefano).





NB: The DAX-formula for measure cumulative # titles, I got with help from ChatGPT:


 

 

 

With this decomposition tree chart, you can see a breakdown of the 15 UCL-titles, where I chose the path:  Country (Spain) > Team (Real Madrid) > Coach (Ancelotti, trainer with most UCL-victories, total 5, 3 with Real Madrid and 2 with AC Milan) and Season/Year (2023-24)



To make a Power BI dashboard as this, normally I'd search for the dataset on internet, e.g. Wikipedia, and then transform the dataset for my reporting-needs (e.g. in Power Query). But now there are generative AI tools/chatbots as OpenAI's ChatGPT,  which I used, that can create the dataset you want, or close to it.
For the dataset that ChatGPT generated for me, it missed data for UCL season 2023-24, because ChatGPT has a cutoff date of Jan.2022, so the data for that season I had to add manually.
ChatGPT created some Python-code for the dataset, which can be loaded in Power BI (as it also told me):




 

 

I also asked ChatGPT which visual it would recommend for this data, and it even draw the chart itself (something that was not possible with ChatGPT 3.5, but now with ChatGPT 4o it is):




So these new AI-tools can make the life of a data-analyst and data-journalism work as I did for this post much easier, until one day we are not needed anymore..


If you enjoyed this post and want to make a small donation, you can do this with the Paypal Donate button (at the top right of this post) or via BuyMeAcoffee .

Follow me on LinkedIn


References / Youtube-videos UEFA Champions League (European Cup) history (season 1955-56 to 2023-24)

ALL Champions League goals 2023/24 | Real Madrid

Best Champions League Goals In Football History (2000-2024)

European Cup final 1960 | Real Madrid 7-3 Eintracht Frankfurt

Feyenoord - Celtic 2-1 Europa Cup I Milaan, 6 mei 1970

Ajax wins 1972 European Cup Final

Borussia Dortmund 0-2 Real Madrid | HIGHLIGHTS | Champions League final 2023/24


Downloads

PowerBI report with Champions League history until season 2023/24


Power BI dashboard (embedded)

https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/PowerBI-report-UEFA-Champions-League-Winners-history-seasons/m-p/4000701#M12714


 


 


1 comment:

Google2Office said...

The level of detail and precision as always is fantastic. Thanks!!