Blog

  • ChatGPT vs Claude: Which AI Should Your Business Be Using?

    feature image for blog on chatgpt vs claude

    ChatGPT vs Claude: Which AI Should Your Business Be Using? Two AI models dominate the conversation when businesses start seriously evaluating AI tools: ChatGPT from OpenAI and Claude from Anthropic. Both are capable, well-supported, and improving rapidly. But they have meaningfully different strengths, and choosing the wrong one for your workflows can cost you time and money. Here is an honest, detailed look at both. The Models ChatGPT runs on…

    » Read more
  • Fabric Toolbox: A Helpful Resource for Exploring Fabric

    Purple Frog Systems branded blog header featuring a team member standing in front of a purple background with hexagon graphics and a magnifying glass illustration, alongside the title “Fabric Toolbox: A Helpful Resource for Exploring Fabric.”

    As Microsoft Fabric adoption grows, many businesses are starting to move beyond experimentation and into building production analytics platforms. However, implementing and managing a modern data platform still involves more than simply enabling the technology. To help teams get started and explore best practices, Microsoft and the wider community have introduced Fabric Toolbox, a collection of open source resources designed to support Microsoft…

    » Read more
  • Wait, does ChatGPT actually think it’s 2024?

    A person wearing a black and purple Purple Frog branded polo shirt stands in front of a graphic background featuring a laptop screen and hexagon design elements. Text on the image reads: “Wait, does ChatGPT actually think it’s 2024?”

    Ever asked ChatGPT who won the Super Bowl last month, only for it to very over-confidently tell you about a game from two years ago? Or maybe you’ve asked Gemini for the latest update on the news, and it responded like it was still living in the glory days of 2024? It’s not that your AI has a bad memory, although it may seem that way, it’s actually what called: knowledge cutoffs. Welcome to the world of knowledge cutoffs. You could…

    » Read more
  • The Difference Between Using AI and Integrating It

    A person standing with arms crossed wearing a black and purple branded polo shirt, positioned in front of a digital-themed background featuring AI‑related graphics. To the right, large white text reads: “The Difference Between Using AI and Integrating It."

    Enter, The Conflation Problem There is a growing issue in the AI space. Many talks marketed as “AI strategy” are, in reality, basic training sessions on prompt writing, ChatGPT usage, or Copilot for Microsoft 365. There is no doubt that these are indeed useful skills as they improve productivity and increase confidence with new tools, but… they are not AI transformation. We are currently conflating three very different things:…

    » Read more
  • Microsoft Fabric Warehouse Case Insensitive: Workspace Setting Guide

    A person wearing a Purple Frog Systems polo shirt stands in front of a stylised tech-themed background with hexagonal patterns and server racks. To the right, bold white text reads: ‘Microsoft Fabric Warehouse Case Insensitive: Workspace Setting Guide.

    Making a Microsoft Fabric Warehouse case insensitive is a decision you can make before building your data platform. If Customers does not equal customers in your queries, your Warehouse is case sensitive. The solution is simple. You just need to configure the correct setting at the Workspace level. Why Configure a Microsoft Fabric Warehouse Case Insensitive? In a case sensitive Warehouse, capitalisation matters: Sales is different from sales…

    » Read more
  • Part 1: Using the Companies House API

    : A person wearing a Purple Frog-branded polo shirt stands with arms crossed in front of a modern curved glass building. The background features a purple geometric design with hexagons and circular tech-style graphics. Text on the right reads: ‘Part 1: Using the companies house API.’

    The .gov website hosts companies house and the companies house API. This is a comprehensive list of businesses across the UK, new and old, big and small, and their filings and info. You can interact with this information via code such as Python. The following blog post series will show you how to perform an advanced search of companies – using multiple different filters to get specific businesses – and then looping through these results to…

    » Read more
  • Why Guardrails Matter More Than Hype

    A person wearing a Purple Frog-branded polo shirt stands with arms crossed in front of a purple and blue abstract digital background featuring hexagonal shapes and circular tech-style graphics. White text on the right reads: ‘Why Guardrails Matter More Than Hype.

    AI has moved quickly from novelty to normality. Customer service bots, sales assistants, automated support agents, many organisations are now letting AI speak directly to customers under their brand. The capability is impressive. The governance often is not. A recent post on Reddit’s LegalAdviceUK forum highlights exactly why this matters. A business owner described how their AI chat assistant generated and offered an 80 percent discount code…

    » Read more
  • AWS European Sovereign Cloud: Real Sovereignty or Just Cloud Marketing?

    AWS-European-Sovereign-Cloud-Real-Sovereignty-or-Just-Cloud-Marketing

    In January 2026, Amazon Web Services launched its European Sovereign Cloud, a strategically independent cloud region designed to meet the strictest European data sovereignty, residency, and compliance requirements. But amid industry enthusiasm and regulatory scrutiny, critical questions remain. Is it truly sovereign, and how does it compare to similar offerings from Microsoft Azure and Google Cloud Platform? This article explores the technical…

    » Read more
  • Incremental Refresh in Power BI

    The aim of an incremental refresh is to reduce refresh time by avoiding unnecessary reprocessing of historical data. Rather than reloading an entire table on every refresh, Power BI refreshes only the most recent period where new or corrected records are likely to appear, while retaining older data that is unchanged. Incremental refresh is based on two time windows: Retention (historical data): how far back data is kept in the model. Refresh…

    » Read more
  • Using Synoptic Panel to Create Data-Driven Diagrams in Power BI

    Introduction Power BI is fantastic for visualising geological data, with the latest Azure Map visual providing some further enhancements on top of previous map visuals (pathing, traffic layers etc.) However, what if there was a need to drill-down a little further into a location. For example: What if we wanted to understand how product positioning within a store might be affecting sales. Or maybe, we own a vehicle maintenance workshop and wanted…

    » Read more