Call today 0845 643 6463

Data analytics

  • There Is More Than One Way to Query Your Data: Have You Tried DAX?

    June 12th, 2026 in Blog, Data analytics, DAX

    Power BI is fantastic for building reports, but sometimes you just need to get data out of a semantic model quickly, without building a full report page to do it. However, what if you need to dig further into a specific snapshot of your data? For example: What if you wanted to pull a precise slice of data into Excel for a one-off analysis? Or maybe you’re building a bespoke report and want to make sure it’s using the same agreed…

    » 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.’February 13th, 2026 in Blog, Business Intelligence, CSV, Data analytics, Export, Fabric, Jupyter, Python, Visual Studio

    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

  • Is ETL now a Circular Process?

    December 24th, 2025 in Blog, Business Intelligence, Data analytics, Microsoft Fabric, Power BI, PowerBI

    Traditionally, ETL (Extract, Transform, Load) has been a one-way journey. Data is extracted from operational systems, it’s transformed into a clean, structured format and then it’s loaded into a data store (typically a warehouse or lakehouse), rinse and repeat. But what’s after that? Business users build reports and dashboards and make a decisions from their insights, but the data itself never flows back into the systems where the work…

    » Read more