Skip to main content

Olympics Series - Mens 100M - According to Gemini

 Here I am going to try and work on a project to use GenAI to create some content for the upcoming Olympics. I am hoping to integrate some data project as well, exactly what that will be remains to be seen. 

So the Mens 100M. My preview will cover a bit on a legend of the event, who cannot be repeated in another event and then a preview of the event for the upcoming games. 

Legend Profile: Usain Bolt *According to Google Gemini

Usain Bolt: The Lightning Bolt Leaves a Legacy

Usain Bolt, the retired Jamaican sprinter, isn't just a legend in track and field, he's widely considered the greatest sprinter of all time. Here's a glimpse into his phenomenal career:

Early Life and Transition to Track:

  • Born in Sherwood Content, Jamaica on August 21, 1986.
  • Initially excelled in cricket and football, but his exceptional speed was undeniable.
  • Encouraged by his school coach to pursue athletics, he began training seriously in his teens.

Dominating Rise to Stardom:

  • Established himself as a prodigy by winning the 2002 World Junior Championships.
  • By 2007, he became the fastest man alive, setting his first 100m world record.
  • The 2008 Beijing Olympics marked his global explosion. He shattered world records in the 100m, 200m, and as part of the 4x100m relay team – all in record times.

Solidifying the Legend:

  • Bolt achieved the unprecedented feat of "triple-doubles" at three consecutive Olympics (2008, 2012, 2016), winning gold in the 100m, 200m, and 4x100m relay at each.
  • His flamboyant personality and signature lightning bolt pose made him a global icon.
  • Throughout his career, he collected numerous accolades, including eight Olympic gold medals, eleven World Championship gold medals, and multiple Laureus World Sportsman of the Year awards.
And according to Ideogram.ai this is an image create in the likeness of Usain Bolt: 


Beyond the Track:

  • Bolt retired in 2017, leaving an unmatched legacy in sprinting.
  • He has pursued various ventures, including endorsements, business interests, and even attempting professional football trials.
  • Bolt's charisma and dedication to the sport continue to inspire athletes and fans worldwide.

His impact goes beyond the times he clocked. Usain Bolt redefined sprinting, captivating audiences with his speed and showmanship. He remains a true legend in the world of athletics.

Gemini Race Preview: 

"The 2024 Olympics are coming up in Paris, and the men's 100m is shaping up to be an exciting race! Here are some of the top contenders:

  • Fred Kerley (USA): The reigning World Champion (as of August 2023) and a sub-10 second runner.
  • Marcell Jacobs (Italy): The surprise winner of the 2021 Tokyo Olympics, though injuries have hampered him recently.
  • Noah Lyles (USA): A talented young sprinter known for his showmanship, and the reigning World Champion in the 200m.
  • Ferdinand Omanyala (Kenya): A rising star who pushed Lyles in the 2023 World Championships.
  • Christian Coleman (USA): A former World Champion with a personal best that puts him in contention, but has faced doping suspensions.
  • Zharnel Hughes (Great Britain): A favourite of Usain Bolt, known for his strong starts.

These are just a few of the athletes to watch. It's always possible for someone unexpected to challenge for the gold medal too! Keep an eye out for the qualifying races and other major competitions leading up to Paris 2024.

For a fun guess, based purely on randomness and with no insider knowledge, I'll say the winner will be... Ferdinand Omanyala (Kenya).

Remember, this is just a random pick! The beauty of the 100m is that any of these top contenders could pull off a win on the day."

Comments

Popular posts from this blog

Keboola Flows

Really finding Keboola was the thing that kickstarted this project otherwise I would be trying to build custom code on a python cloud server and building everything from scratch.  In Keboola you build you data sources and destinations using connection details which is fairly simple and something I will likely cover in another post, same goes for transformations etc. Here though I am going to discuss Flows, this is where you bring everything together. On my free account there are some limitations.  My easiest flow is very basic:  Pull parkrun results e-mail from Gmail to Google Sheets (actually done by Zap not Keboola).  Keboola will, as often as I like, in this case once a week, pull the data from the sheet into its storage.  It will then transfer this to the target database. Currently I have this setup to be MySQL database but I can and might expand that to the Snowflake instance within Keboola.  I then, outside of Keboola, connect to the MySQL database f...

Zoho Analytics

Have I finally found my BI Tool, one that lets me import data from Snowflake and share it for free? I know, no sooner have I posted about how hard it was to find a tool that could do anything from Snowflake than I come across Zoho. You can check out my dashboard on the following page . Below is a diagram that outlines the processes I have used to obtain this data. In summary my parkrun e-mail is pushed to Google Sheets every week by Zapier and Forms I submit every day are used to track the strength training I do. Keboola is then used to ingest this data into MySQL and or Snowflake where I then use views or the built in transformation processes in Keboola to shift the data into a format for reporting. Google Data Studio then connects to MySQL and Zoho to Snowflake to visualise the data. 

Creating a date dimension in dbt and Snowflake

A lot of the data that I am working with doesn't lend itself to creating complex star schemas (more on data modelling in a later post) however I want to try and at least want to go to some effort. The one thing that pretty much all my tables have in common is date, so I want to build a date dimension. My strength training happens on a day, my running and walking, parkrun and hopefully the weather data I intend to integrate will have a date on it. This means if I have a date dimension and I aggregate my various facts at date level I can use them together in a single visualisation.  There are various methods I could have used to create the date dimension and I went with using the dbt spine, this was really simple using the utilities:  Used the date functions in Snowflake to extract relevant fields such as year, month, day in words and year month etc.