Gen AI Data Guy

Here are some recent developments in the field of General AI (Gen AI) : Google Considers Charging for AI Services Google is contemplating charging users for certain AI-related services, which would be a significant shift in its commercial model. Core products that were previously free might now have a paywall 1 . Nextcloud’s ‘AI as a Service’ Collaboration Nextcloud has partnered with major European cloud storage providers to leverage their upcoming on-premise ‘artificial intelligence (AI) as a service’ features. The collaboration aims to ensure GDPR compliance in a privacy-conscious industry 2 . Wolters Kluwer Launches AI-Powered Regtech Service Wolters Kluwer Compliance Solutions has introduced OneSumX® Reg Manager, assisting U.S. community banks and credit unions in enhancing their regulatory change management efforts using AI 3 . Stay informed about these exciting advancements in the world of Gen AI! 🌟 For more in-depth coverage, you can explore TechCrunch’s AI section or other r...

I have been exploring the variety of options that are available with Gen AI. Not just the different AI tools but the differ things they can be used for. In my day job they can be great for rewriting bits of code or looking up how to do specific tasks in python but the data I work with means I could never ask for anything specific. I am still looking for an interesting home coding project to do but in the meantime I have gotten creative.  Working with my daughter I have started to create some books for kids. Probably best aimed at around the 6-10 year old mark, they are just fun books with a bit of a laugh in them. The great thing is that it is fairly easy to make the bulk of these books using GenAI which I have also used for cover art and for a bunch of logos and banners for a websites.  The Website is here and the first book is here  (only £0.99 from Amazon).  The writing process : Prompt 1 : I have idea xyz for a children's book aimed at 6-8 year olds, here is an ...

Google’s Beta AI Content Rewriting Tool : Google is testing an AI tool that finds and rewrites quality content. However, some critics argue that it may incentivize the production of AI-generated low-quality content 1 . The New York Times and OpenAI Controversy : A court filing alleges that The New York Times paid someone to hack OpenAI’s products using deceptive prompts. The situation raises questions about the ethical use of AI 1 . Optimizing GPTs for Online Visibility : Learn how to increase online visibility and click-through rates for your GPT models in the GPT Store and Google Search with six practical tips 1 . AI Democratizing SEO or Amplifying Incompetence? : Understand what AI can realistically do for SEO and manage expectations regarding results 1 . Google’s “Help Me Write” AI Assistant : Google has launched an AI writing assistant called “Help Me Write” for the Chrome browser. It suggests text based on website context 1 . Google’s Gemini: Laptop-Friendly Open Language Model :...

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

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....

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. ...