Gen AI Data Guy

Part of my goal on this blog is to pit the different AI tools against each other. Being a data guy this will mostly come from python and SQL scripting, and perhaps data analysis if I can get it to do that. However I am also going to see how they compare with creativity. In the long term it would be cool to make some books using them and see how they turn out. Maybe a kids book and a super hero book. In making that Super Hero book, well in starting it, I thought of the idea of having a blog post to expand the world at the start of each chapter. From there I decided to create a blog for each of the Gen AI tools and to get them to create and blog about this fictional world and post these stories onto my YouTube channel. Will be interesting to see how the stories develop and if any of them get any view haha. Gemini  Co-Pilot ChatGPT

  Imagine a world where artificial intelligence can not only understand and respond to information, but also generate entirely new content, pushing the boundaries of creativity. This is the exciting realm of generative AI (Generative Artificial Intelligence) , and it's rapidly transforming diverse fields across the digital landscape. So, what exactly is Gen AI? In simple terms, it refers to a type of AI that uses machine learning algorithms to learn patterns and relationships within existing data. This data can be anything from text and images to audio and video. Once trained, these algorithms can then use their knowledge to generate entirely new content , mimicking and even surpassing the quality of human-produced materials. Here are some fascinating ways generative AI is being used today : Fuelling Creative Content:  Writers can use AI tools to generate story ideas, brainstorm outlines, or even craft unique dialogue. Artists can utilize AI algorithms to create new music styles, g

 Wanted to do some rebranding for YouTube if nothing else. Here is what it came up with.

So I wanted to see if I could test the different Gen AI models that are out there and get them to write a relatively simple SQL query. Basically select against my table, as detailed in the prompts to Gen AI, and produce a list of the fastest 1000 times at an event (that takes place weekly) and provide the times and names of the athletes that ran said times. Note that although I say view a lot I mean query because what are views if not stored queries anyway and I am using this in my DB as a view.  Winner : Copilot The original view can be seen below:  So it is a fairly simple view with some logic in it to through some spanners in the works. The question is with the table definition and some explanation can the Gen AI platforms recreate a working version of the above view?  The initial Prompt:  I can't find a good way to format and embed my whole chats with the AI tools so I will work with what I have. Here is my original prompt that I used to get a starting point.  Gemini:  O

So recently parkrun removed all their stats and as a keen running who is trying to work their way up the top 100 of their local parkrun I wanted to get some of these stats back and have a bit of "fun" at the same time. So here is a little "ETL" process that I developed with the help of Gen AI.  The steps of my ETL:  Copy and paste data into Google Sheets template where an AI produced formula extracts URLS from the text and puts them into a new field. This effectively allows me to extract the parkrun athlete id, the primary key, and use it in my analysis. I also have a column to autofill the data I am processing.  Use an Gen AI generated Google Apps script to process it into a processed sheet, this allows me to build up a backlog of events (I had over 500 to process).  This is then queried using a Gen AI Google sheets query to extract key information and columns / format times etc. I then ingest the fully processed sheet into Keboola directly from Google Sheets.  Wit