Category: Business Intelligence

  • Single Date Picker in Power BI

    Single Date Picker in Power BI

    In the sphere of data analysis and visualization, Power BI emerges as a leading tool, adept at turning raw data into comprehensive reports and dashboards. Despite its strengths, we’ve found it lacking a specific, commonly used feature: the integration of a single date picker within a report. This feature, surprisingly not included by default, is…

  • Automated Power BI Testing with Selenium

    Automated Power BI Testing with Selenium

    Working with Power BI can become challenging as the size and complexity of your workspaces increase. Initially, managing a few reports linked to your dataset is straightforward. However, as the number of reports and their dependencies grow, keeping track of everything becomes more difficult. Power BI offers the option to see, what artefacts in your…

  • Analyse bexio Data with Power BI

    Analyse bexio Data with Power BI

    Like many other SME in Switzerland, we are using bexio as our administration and accounting tool. bexio allows for some limited standardized reporting within the service but we needed more flexibility. So we created our own report with Power BI, focusing mainly on two points: Our report allows to compare liquid assets year over year…

  • MS Fabric Data Activator: A big step towards actionable insights

    MS Fabric Data Activator: A big step towards actionable insights

    While Microsoft Fabric still has its quirks and might not be the go-to recommendation for customers as off right now (though this will change soon concerning the pace of improvements), I can’t help but get excited about one particular feature. Everyone’s been talking about its cool new stuff built on a modern Deltalake setup, all…

  • Cultivating Intelligence: The Data-Backed Future of Vertical Farming

    Cultivating Intelligence: The Data-Backed Future of Vertical Farming

    Introduction: Data-Driven Cultivation – Where Science Meets Innovation In the realm of modern agriculture, a profound shift is underway — a harmonious blend of science and innovation that’s shaping the future of farming. Imagine a world where plant growth is deciphered through data, where technology orchestrates a seamless partnership with nature. In this blog, we…

  • Why Enterprises using Power BI should be excited about MS Fabric

    Why Enterprises using Power BI should be excited about MS Fabric

    Admittedly this blog is a little late to the party. A few months ago, everybody jumped on the hype train surrounding Microsoft’s latest innovation, Microsoft Fabric. But perhaps, in this case, tardiness is a virtue, since it has allowed me the time to look beyond the initial wave of excitement and truly understand what makes…

  • Dynamic Axis in Power BI

    Dynamic Axis in Power BI

    Welcome to my blog on how to create dynamic axes for visuals in Power BI using field parameters. If you’re familiar with creating visuals in Power BI, you may have come across the challenge of displaying data over time in a way that remains visually appealing and informative when the time period under consideration changes.…

  • Static and dynamic Row-level-Security in Power BI

    Static and dynamic Row-level-Security in Power BI

    Power BI enables developers to implement Row-level-security (RLS) in their reports, which is a powerful feature that allows you to restrict data access at the row level. With RLS, you can ensure that users only see the data that they are authorized to see. This feature is particularly useful in situations where you have sensitive…

  • Incorrect Power BI Report Data After Refresh

    Incorrect Power BI Report Data After Refresh

    You just spent a lot of time designing your report and now it’s time to upload it to the Power BI Service. After setting up the credentials for the data source, you hit refresh to make sure the data can be pulled from the source. The refresh completes without error and you switch over to…

  • Impact of renaming columns in Power BI

    Impact of renaming columns in Power BI

    Renaming columns in Power BI can have a severe impact on your reports. Initially, renaming columns in Power BI ensures that your end users don’t have to deal with cryptic system names from your source system. Over time, you may need to change a name of a column because of new terminology or to standardize…