Cycling through Data to Unveil 110th Tour de France 2K23

In this Power BI report, I've compiled & visualized a wealth of data, including historical race characteristics, results, duration, participation, individual rider statistics. The interactive dashboards provide an engaging & dynamic way to explore the Tour's rich history & gain insights into the fascinating world of competitive cycling.

The goal of challenge was to make an infographic-style visual to educate new viewers with aim to increase the race's popularity around the world, highlight the magnitude of the event, and build anticipation for this year's race.

The dataset was far from optimal, so I had to conduct a lot of data cleaning. It was difficult to format the text-based numerical data and time & date information properly. However, it gave me the chance to delve deeply into the power query's strengths & to master the M-language. Additionally, since Excel & Power Query cannot handle dates before 1900, figuring out the age of riders with DOBs prior to 1900 was a task in and of itself.

🚀 Key Features of the Power BI Report:

📌 Overall Race Analysis: Get an overview of each Tour de France edition, including race length, duration, total participation & finishers.

📌 Winner's Performance: Discover the characteristics of winners with statistics on stage wins, age, height, weight, stages won & total pedaling time.

📌 Country-wise Trophies: Explore the diversity of participants from various nations & how different countries have contributed to the Tour's success.

📌 Speed of Riders: Riders average speed & time to finish race over the course of 120 years.

Whether you're a sports enthusiast, a data analyst, or just curious about the Tour de France, this Power BI report has something for everyone. It's an excellent resource for understanding the nuances of this epic race & drawing meaningful insights from the vast amount of historical data.