Call today 0845 643 6463

Blog

  • Narrate Your Data: Implementing Dynamic Alt-Text for Inclusive Reporting

    August 21st, 2025 in Blog, DAX, Power BI

    As Power BI Developers our aim is to make data insights accessible universally, so that everyone can make full use of their data and the insights it holds. Therefore it is critical to step out of our own shoes during the design process to ensure that what we build is inclusive to as many audiences as possible. In this blog I will explore how you can implement dynamic alt-text using DAX measures, which help people who are blind or have low…

    » Read more

  • Why DuckDB Is the Data Engineer’s New Secret Weapon

    August 6th, 2025 in Blog, Data Warehouse, Python, SQL, Uncategorised

          Most databases need a server. DuckDB doesn’t. It’s a zero‑config, in‑process OLAP database you can run directly using Python. It’s fast, SQL‑friendly, and speaks Parquet like a native language — no clusters, no heavyweight setup, no waiting for provisioning. Think of DuckDB as SQLite for analytics — but faster, more column‑aware, and built for modern data engineering.   What Makes DuckDB Special DuckDB…

    » Read more

  • Marketing in a data-driven world: My take on the AI discovery morning

    August 6th, 2025 in Artificial Intelligence, Blog, Community, Uncategorised

    On 3rd July, I had the amazing opportunity to support and represent Purple Frog Systems at our AI and Data Analytics Discovery Morning in Telford, and what a day it was! As the Marketing Associate, I’m usually found behind the scenes taking photos, managing our branding, and creating content. But this event gave me the chance to do so much more. Not only did I get to capture the day through my lens, but I also got involved in the conversations…

    » Read more

  • ChatGPT’s New Study Mode: Turning AI into Your Learning Coach

    ChatGPT’s New Study Mode: Turning AI into Your Learning CoachJuly 30th, 2025 in AI, Artificial Intelligence, Blog, ChatGPT, school engagement

    Today, OpenAI launched its new “Study Mode” in ChatGPT, a feature designed not to give you the answers on a silver platter, but to guide you through the thinking process step by step. With Study Mode turned on, ChatGPT shifts from being a quick answer service into an interactive tutor. Instead of handing over solutions, it nudges learners with questions, prompts for self-reflection, structured lessons, and quizzes. This prompts deeper…

    » Read more

  • Reset Row Number within a Window in SQL

    July 24th, 2025 in Blog, SQL, SQL Server

    In this blog I will show you how to reset the row number within a partition window when using the ROW_NUMBER() function in SQL. The following is a sample dataset showing customer subscriptions with start/end dates, the RenewedSubscriptionID represents the subscription that was renewed to start a new subscription, for example SubscriptionID 101 was renewed to create SubscriptionID 102. The goal is to identify the sequence of renewals by customer.…

    » Read more

  • What Is Agentic AI?

    What Is Agentic AI?July 22nd, 2025 in AI, Artificial Intelligence, Blog, Copilot

    The field of artificial intelligence is evolving rapidly, and one of the most exciting and often misunderstood developments is Agentic AI. But what exactly does “agentic” mean in this context? Is it just another buzzword, or does it signal a meaningful shift in how AI systems operate? In this blog, we will break down the concept of Agentic Artificial Intelligence, why it matters, and where it is headed. Defining Agentic AI At its…

    » Read more

  • Python Lists – What do I need to know?

    Python Lists – What Do I Need to Know?July 21st, 2025 in Blog, Python

    When you’re learning Python, lists are one of the first data structures you’ll encounter. They’re simple, powerful, and flexible. But what should you really know to use them effectively? In this post, we’ll cover everything you need to know about Python lists: what they are, how they work, and how to use them efficiently. What is a Python List? A list is a mutable, ordered, heterogeneous collection of items. Think of it as a…

    » Read more

  • SQLBits 2025: The year you couldn’t escape AI

    SQLBits 2025: The year you couldn't escape AIJuly 1st, 2025 in AI, Artificial Intelligence, Blog, Community, Machine Learning, Python, Spark

    As an AI engineer immersed in the ever-evolving world of data and machine learning, conferences offer more than just networking opportunities; they’re essential refuelling stations for inspiration, learning and innovation. To be frank, SQLBits usually doesn’t fully fit the bill for me as an AI engineer, but as the lines between AI and data engineering have become increasingly blurred, the content of the talks has evolved to reflect…

    » Read more

  • How to Run T-SQL in Microsoft Fabric Python Notebooks

    June 26th, 2025 in Blog, Python, SQL

    Here at Purple Frog Systems, I’ve been experimenting with pure Python Notebooks rather than PySpark Notebooks for small to medium datasets, due to their super quick start up time and reduced CU consumption for customers with smaller F-SKUs. https://learn.microsoft.com/en-us/fabric/data-engineering/fabric-notebook-selection-guide When scrolling through LinkedIn I came across a Microsoft Blog which allows you to combine T-SQL and Python within…

    » Read more

  • 10 Ways Small Businesses Can Use AI Today

    June 16th, 2025 in Artificial Intelligence, Blog, Business, Business Intelligence

    Artificial Intelligence (AI) isn’t just for big tech companies anymore. In 2025, AI tools are more accessible, affordable, and practical than ever—especially for small businesses. Whether you’re running a local coffee shop or managing an online store, there are powerful ways to use AI to save time, cut costs, and grow smarter. Here are 10 practical ways small businesses can harness AI right now: 1.Automated Customer Support with…

    » Read more