Call today 0845 643 6463

Tag Archive: Business Intelligence

  • Part 2: Using the Companies House API

    Part 2: Using the companies house API, by CallumJune 26th, 2026 in Blog, Business Intelligence, Jupyter, Python

    Part 2: Using the Companies House API Welcome back following part 1… Getting a list of companies via Python – Advanced Filtering. This example will look at the transport sector, leveraging the SIC codes in companies house. This can be altered accordingly to suit the business nature you are looking for. The libraries allows you to do more with Python, in this example that will included API calls, referencing the current date time and…

    » 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

  • Predictive Analytics for Small and Medium Enterprises

    Lewis standing with arms crossed in front of a graphic background featuring hexagonal patterns and business charts, wearing a black and purple Purple Frog Systems polo shirt. Text on the image reads: “Predictive Analytics for Small and Medium Enterprises.November 3rd, 2025 in AI, Azure, Big Data, Blog, Business, Fabric

    For many years, predictive analytics was a luxury reserved for large enterprises with deep pockets and advanced infrastructure. Today, thanks to the power of cloud computing, AI-driven tools, and accessible business intelligence platforms like Power BI, small and medium enterprises (SMEs) can tap into predictive analytics to transform how they plan and grow. At Purple Frog Systems, we’ve seen firsthand how even modest-sized organisations can…

    » Read more

  • Fill Blank Rows With Previous Non-Blank Values – DAX

    Fill Blank Rows With Previous Non-Blank Values - DAXSeptember 5th, 2025 in Blog, Business Intelligence, Dashboarding and Reporting, DAX, Power BI, PowerBI

    Fill Blank Rows With Previous Non-Blank Values – DAX I want to see a value for everyday, whether a new value exists or not – lets call it tracking the members of a golf club. If there are no changes to the member numbers, I would have no movement figure on that day. If someone joined or left, the figure would be updated. Just because there are no changes, it doesn’t mean that there are no members on that date and therefore this day is…

    » Read more

  • Metric Sets in Power BI

    Metric Sets In Power biDecember 24th, 2024 in Blog, Power BI

    Metric Sets in Power BI: Transforming Data Management Having reliable and consistent metrics is crucial for making informed decisions. Microsoft Power BI has introduced an enhancement with the launch of Metric Sets, now available in public preview. This innovative feature is designed to help you define, discover, and reuse trusted metrics across your organisation. It enhances your data experience and empowers you with the tools you need to…

    » Read more

  • Unlocking the Power of AI in the Retail Sector

    Unlocking the Power of AI in the Retail SectorSeptember 11th, 2024 in AI, Artificial Intelligence, Blog, Machine Learning

    In today’s fast-paced retail environment, businesses are constantly seeking innovative ways to stay ahead of the competition. One of the most transformative technologies in recent years has been Artificial Intelligence (AI). By leveraging AI, retailers can gain valuable insights into their operations, enhance customer experiences, and drive sales growth. In this blog, we’ll explore two key AI use cases in the retail sector: sales…

    » Read more

  • Power BI Dataset Gives Mashup Timeout Error While Refreshing

    July 26th, 2024 in Blog, Data Warehouse, Power BI, PowerBI, SQL, SQL Server, Uncategorised

    Help – my Power BI dataset is giving mashup timeout error on refresh The mashup timeout error Incremental refreshes are a great benefit to have in order to reduce refresh times – but not when they give a mashup timeout error. Although they are meant to be a performance enhancement, they aren’t always the best approach as they fire parallel queries to the source and apply date time filters. Despite the default timeout being 2 hours, or 5…

    » Read more

  • Power BI – Visual to show filters that have been applied to a report

    March 13th, 2023 in Blog, Business Intelligence, DAX, Power BI

      Most PowerBi reports will use slicers to allow the user to filter and interact with the visuals they have. But in practice, users may forget what slicers have been applied. It’s inconvenient to have to look through each slicer, potentially across multiple pages, to see what filters are being used on the report. Therefore, it is not user friendly. We need to show every filter that has been applied in one convenient place. Thankfully,…

    » Read more

  • How to create a toggle button in Power BI

    November 8th, 2021 in Blog, Uncategorized

    In this blog post I will be showing you how to use a toggle button in Power BI. A toggle button in Power BI allows users to quickly switch between two options. Our first step is to create a toggle button as Power BI doesn’t have one by default. You can import one but by creating it yourself, it gives you more control. Our toggle button is created by having two images of identical size over the top of each other and using bookmarks to flip…

    » Read more

  • Creating calendar tables with DAX using Power BI

    April 6th, 2020 in Blog, Business Intelligence, Dashboarding and Reporting, Power BI

    By Nick Edwards In this blog post we’ll take a quick look at creating a self-generating calendar table using DAX. Dates are important if we want to perform time intelligence reporting on our data i.e. yearly sales, monthly sales, weekly sales, year to date sales or previous year sales. We’ll be using the calendar function to create our date table, but there are other methods to do this such as CALENDARAUTO or GENERATESERIES. Here is the…

    » Read more