Select Page
In The Trenches

The Best Articles and Tutorials About Cloud Analytics, BI and Management 

Hi! I’m Paul. I’m a data nerd from the beautiful suburb of Durbanville, Cape Town.
I’m available for short term BI / data engineering projects and Cloud data migrations on Azure, AWS or Google Cloud.

To view my resume, please access it here:
Paul Hansen – Business Intelligence Professional 2023

Contact Me

Business Intelligence and Analytics Blog

Power BI May 2024 Feature Summary This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-may-2024-feature-summary/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-may-2024-feature-summary/. The author is 

Read More

Read More

One of the biggest opportunities we’re seeing is in accelerating the path to a data-rich culture by enhancing the productivity of your data teams and making analytics more accessible to every user. That’s why we’ve invested heavily in bringing to life Copilot in Fabric—an AI experience embedded directly into Microsoft Fabric that can help every […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/copilot-in-microsoft-fabric-is-now-generally-available-in-the-power-bi-experience/. The author is 

Read More

Read More

In today’s data-driven business environment, understanding the categories of data analytics is essential for organizations aiming to harness the full potential of their data. Data analytics is not just about examining numbers; it’s about interpreting what those numbers mean for a business’s strategy, operations, and future decisions. The three common categories of data analytics—descriptive, predictive, […]

This post first appeared at https://p3adaptive.com/what-are-the-3-common-categories-of-data-analytics/. The author is Kristi Cantor

Read More

Read More

In today’s fiercely competitive market, mastering the different types of data analytics is crucial for businesses looking to leverage big data effectively. These analytics types represent various stages and approaches to data processing, each playing a unique role in transforming raw data into actionable insights. As businesses continue to navigate the complexities of big data, […]

This post first appeared at https://p3adaptive.com/what-are-the-4-types-of-data-analytics/. The author is Kristi Cantor

Read More

Read More

In the digital age, a well-crafted data strategy is essential for businesses looking to leverage their data as a strategic asset. It provides a comprehensive blueprint that outlines how data will be collected, managed, protected, and transformed into actionable insights. This strategy is central to enhancing decision-making, optimizing operations, and maintaining competitive advantage in rapidly […]

This post first appeared at https://p3adaptive.com/five-essential-components-of-a-data-strategy/. The author is Kristi Cantor

Read More

Read More

In the dynamic world of data analytics consulting, establishing a well-defined data analytics strategy is paramount for any organization aiming to succeed. Whether you’re at the helm of a burgeoning startup or steering an established company, the ability to harness data effectively is transformative—streamlining decision-making, enhancing operational efficiency, and boosting customer engagement. This introduction will […]

This post first appeared at https://p3adaptive.com/data-analytics-strategy-why-it-matters-and-how-to-start/. The author is Kristi Cantor

Read More

Read More

A few months ago I blogged about the new limits available for the Maximum Connections Per Data Source property in Premium and why the number of connections that a DirectQuery semantic model can open to a data source is so important for report performance. At that time, however, there was no way for you to […]

This post first appeared at https://blog.crossjoin.co.uk/2024/05/19/diagnosing-power-bi-directquery-connection-limit-performance-problems-with-execution-metrics/. The author is Chris Webb

Read More

Read More

We are proud to announce the May 2024 version of the on-premises data gateway. Please continue to send us feedback for what new capabilities you’d like to see in the future at ideas.powerbi.com/ideas. This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-may-2024-release/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-may-2024-release/. The author is 

Read More

Read More

Since the announcement in March that Power BI Premium P-SKUs are being retired and that customers will need to migrate to F-SKU capacities intead I have been asked the same question several times: Why are you forcing me to migrate to Fabric??? This post first appeared at https://blog.crossjoin.co.uk/2024/05/15/migrating-from-power-bi-p-sku-premium-capacities-to-f-sku-capacities-is-not-the-same-thing-as-enabling-fabric/. The author is Chris WebbRead More

This post first appeared at https://blog.crossjoin.co.uk/2024/05/15/migrating-from-power-bi-p-sku-premium-capacities-to-f-sku-capacities-is-not-the-same-thing-as-enabling-fabric/. The author is Chris Webb

Read More

Read More

In March we hosted over 4,200 data professionals in Las Vegas for the first-ever Microsoft Fabric Community Conference. When we set out to host this event, we knew there was a hunger in the community, but we had no idea the level of interest, and need, for connection amongst our Fabric users. It was an […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-microsoft-fabric-community-conference-europe/. The author is 

Read More

Read More

The Power BI integration with Azure Log Analytics has been enhanced through the introduction of a new event known as ‘ExecutionMetrics’. This addition will improve customers ability to obtain more details about their semantic model activities. This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-executionmetrics-event-in-azure-log-analytics-for-power-bi-semantic-models/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-executionmetrics-event-in-azure-log-analytics-for-power-bi-semantic-models/. The author is 

Read More

Read More

In the dynamic realm of analytics, understanding the distinct roles within the data analytics field is crucial for leveraging data effectively. Whether you’re working with top data analytics consulting firms or navigating internal data challenges, knowing the difference between a data analyst and an analytics consultant can significantly impact your strategic outcomes. Data analysts and […]

This post first appeared at https://p3adaptive.com/data-analyst-vs-analytics-consultant/. The author is Kristi Cantor

Read More

Read More

In today’s data-driven business landscape, data and advanced analytics consulting stands out as an essential service for organizations aiming to leverage vast amounts of information for strategic advantage. This specialized field of consulting provides the expertise and tools necessary to transform complex data into actionable insights, empowering businesses to make informed decisions, streamline operations, and […]

This post first appeared at https://p3adaptive.com/what-is-data-and-analytics-consulting/. The author is Kristi Cantor

Read More

Read More

I have always wondered what the partialBatch option for the commitMode parameter in the Enhanced Refresh API does exactly. There is some documentation here and here but I was curious to find out more as part of the research I’m doing for my ongoing series on Power BI refresh memory errors, in case it was […]

This post first appeared at https://blog.crossjoin.co.uk/2024/05/12/the-partialbatch-commit-mode-in-the-power-bi-enhanced-refresh-api/. The author is Chris Webb

Read More

Read More

Last May, we announced the integration between Power BI and OneDrive and SharePoint (ODSP) that allows you to view Power BI reports directly in a OneDrive or SharePoint document library. Previously, this capability was limited only to reports with data in import mode. We’re excited to announce that you can now view Power BI reports […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-live-connect-for-power-bi-report-integration-with-onedrive-and-sharepoint/. The author is 

Read More

Read More

In today’s dynamic business world, the need for data analytics consulting is becoming increasingly crucial. Companies from all sectors are looking to make smarter, data-driven decisions, and they need the right guidance to do so effectively. Data analytics consulting isn’t just about looking at numbers; it’s about transforming these numbers into actionable insights that can […]

This post first appeared at https://p3adaptive.com/data-analytics-consulting/. The author is Kristi Cantor

Read More

Read More

In the Power BI Service, Import mode models are stored offline and paged into memory only when they are needed – for example because someone runs a report that uses the model as its source. As discussed in my last post, though, there’s a limit on the amount of memory that a model can use […]

This post first appeared at https://blog.crossjoin.co.uk/2024/05/05/power-bi-semantic-model-memory-errors-part-2-max-offline-semantic-model-size/. The author is Chris Webb

Read More

Read More

Git Integration

Apr 28, 2024

In the dynamic realm of Microsoft Fabric Data Analytics, mastering development workflows and refining data analytics processes are pivotal for organizational success. One essential tool in this landscape is Git integration—a powerful solution that enhances collaboration and version control within Microsoft Fabric and Power BI. Git integration serves as the backbone for streamlined collaboration and […]

This post first appeared at https://p3adaptive.com/git-integration/. The author is Kristi Cantor

Read More

Read More

In today’s ever-evolving tech landscape, mastering development workflows and refining data analytics processes are crucial for organizational success. That’s where Git integration with Fabric comes into play—an innovative solution that transforms collaboration and version control within Microsoft Fabric data analytics and Power BI. This integration not only enhances project management but also underscores the importance […]

This post first appeared at https://p3adaptive.com/git-integration-with-fabric/. The author is Kristi Cantor

Read More

Read More

Power BI Features

Apr 28, 2024

Navigating the complex world of data doesn’t have to be a daunting task. Power BI, Microsoft’s premier analytics platform, offers a suite of tools that simplify data analysis and visualization, empowering businesses to unlock valuable insights with ease. This guide will introduce you to the extensive features of Power BI, highlighting how it stands as […]

This post first appeared at https://p3adaptive.com/power-bi-features/. The author is Kristi Cantor

Read More

Read More