Call today 0845 643 6463

Tag Archive: Microsoft Power BI

  • 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

  • Underutilised Power BI Visuals (and When to Use Them)

    James wearing a black and purple Purple Frog Systems polo shirt, standing in front of a graphic background with hexagonal patterns and an image of hands working on a tablet. Text on the image reads: “Underutilised Power BI Visuals (and When to Use Them).October 3rd, 2025 in Blog, Microsoft Fabric, Power BI

    Introduction Power BI provides many built-in visuals, plus custom options from the marketplace. Yet many reports still rely heavily on bar, column, and line charts. While those are effective, a few underutilised visuals can help tell richer stories and surface deeper insights. This post highlights some of them, explains when they add value, and offers guidance on using them thoughtfully. Decomposition Tree What it does: Lets you dynamically…

    » Read more

  • Replacing Nested IFs with SWITCH() functions in DAX

    April 17th, 2025 in Blog, DAX, Power BI

    When solving problems and requirements for reports in Power BI, there eventually comes a need for nested IF() statements in your DAX. They work just fine, until they don’t. The more conditions you add, the harder they become to read, maintain and debug. There’s a cleaner way to handle this kind of logic and it’s one that often gets overlooked: SWITCH(). Let’s take a look at why it’s worth getting familiar with and how it can make your…

    » Read more

  • Celebrating certification success: Congratulations to Laura and Nathan!

    Celebrating certification success: Congratulations to Laura and Nathan!March 12th, 2025 in Business Intelligence, Microsoft Fabric, News

    At Purple Frog, we are always proud to celebrate the achievements of our team members as they continue to grow and excel in their fields. Today, we extend our congratulations to Laura and Nathan on their recent Microsoft certifications! Laura has successfully renewed her DP-600 Microsoft certification, which validates her expertise in designing and implementing analytics solutions using Microsoft Fabric. This achievement demonstrates her…

    » Read more

  • Alex Presented at Bristol Fabric & Power BI User Group

    December 24th, 2024 in Community, Microsoft Fabric, News, Power BI

    On December 19th, Alex travelled from The Frogplex to Bristol to present a session at the Bristol Fabric & Power BI User Group. The focus of his presentation was on Power BI Composite and Advanced Models . The session explored how to effectively leverage these advanced techniques to handle large datasets within the Power BI environment. This includes combining diverse datasets into a single report through composite models, directly querying…

    » 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