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

We are excited to announce the April 2024 release of the on-premises data gateway! This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-april-2024-release/. The author is Read More

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

Read More

Read More

We have some exciting announcements to share regarding Copilot in Microsoft Fabric. The information in this blog post has also been shared with Fabric tenant administrators. Below are the highlights of the changes. This post first appeared at https://powerbi.microsoft.com/en-us/blog/copilot-in-power-bi-soon-available-to-more-users-in-your-organization/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/copilot-in-power-bi-soon-available-to-more-users-in-your-organization/. The author is 

Read More

Read More

In the rapidly evolving world of business intelligence, the integration of AI tools like CoPilot with Microsoft Power BI has opened new avenues for data analysis and decision-making. However, unlocking the full potential of CoPilot demands a well-prepared data model—a task that often necessitates a deeper dive into Power BI expertise or working with a […]

This post first appeared at https://p3adaptive.com/getting-your-data-ready/. The author is Marketing

Read More

Read More

Microsoft Fabric helps you build scalable and robust applications, which is crucial in today’s data-driven landscape. It simplifies development work and, equipped with Microsoft Fabric Data Analytics, gives you the tools to create applications capable of analyzing and processing data in real-time. Mastering Microsoft Fabric Data Analytics is a vital step for those looking to […]

This post first appeared at https://p3adaptive.com/navigating-the-learning-curve-of-microsoft-fabric-a-comprehensive-guide/. The author is Marketing

Read More

Read More

In the current data-driven landscape, the capability to harness insightful analytics is more than a luxury—it’s a necessity. Microsoft Power BI stands out as a pivotal tool in this arena, with Power BI Consulting emerging as a critical ally for businesses aiming to transform vast data lakes into actionable insights. Amidst the many features Power […]

This post first appeared at https://p3adaptive.com/what-is-the-difference-between-power-bi-dashboards-and-reports/. The author is Kristi Cantor

Read More

Read More

There are a couple of nice new features to do with table joins (or merges as they are known in M) and query folding in Power Query in the April release of Power BI Desktop that I want to highlight. Anti Joins now fold This post first appeared at https://blog.crossjoin.co.uk/2024/04/14/new-semi-join-anti-join-and-query-folding-functionality-in-power-query/. The author is Chris WebbRead More

This post first appeared at https://blog.crossjoin.co.uk/2024/04/14/new-semi-join-anti-join-and-query-folding-functionality-in-power-query/. The author is Chris Webb

Read More

Read More

This is the blog on how to deliver Power BI and paginated report subscriptions to OneDrive and SharePoint. This post first appeared at https://powerbi.microsoft.com/en-us/blog/deliver-report-subscriptions-to-onedrive-sharepoint-preview/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/deliver-report-subscriptions-to-onedrive-sharepoint-preview/. The author is 

Read More

Read More

Last week we published a new version of our Mailchimp Power BI App: Analytics for Mailchimp (previously known as “Mailchimp Email Marketing”). The app is available on Microsoft AppSource. Install Analytics for Mailchimp on Power BI This post first appeared at https://datachant.com/2024/04/11/mailchimp-in-power-bi-new-version/. The author is DataChant TeamRead More

This post first appeared at https://datachant.com/2024/04/11/mailchimp-in-power-bi-new-version/. The author is DataChant Team

Read More

Read More

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

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

Read More

Read More

Earlier this year, we announced Copilot preview for all customers with Premium/Fabric capacity in Power BI web. We’re thrilled to share that the same Copilot experience for report creation is now available for preview in Power BI Desktop. This post first appeared at https://powerbi.microsoft.com/en-us/blog/introducing-copilot-pane-in-power-bi-desktop-preview/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/introducing-copilot-pane-in-power-bi-desktop-preview/. The author is 

Read More

Read More

PowerPoint lets you play a presentation continuously. This is handy when you want to show information on public screens without anyone having to control it. In this update, we added a new configuration to Storytelling add-in that ensures that you get the latest data from Power BI when running in a continuous slide show. When […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/supporting-continuous-slide-shows-in-power-bi-storytelling-add-in/. The author is 

Read More

Read More

The built-in mapping functionality in Power BI paginated reports is fairly basic. However the integration of Power Query into Power BI paginated reports gives you an interesting new way of creating maps in paginated reports: you can call the Azure Maps API using Power Query and display the image returned in an Image report item. […]

This post first appeared at https://blog.crossjoin.co.uk/2024/04/07/displaying-azure-maps-in-a-power-bi-paginated-report/. The author is Chris Webb

Read More

Read More

In the era of data-driven decision-making, having a robust analytics tool is not just an advantage; it’s a necessity. Power BI, Microsoft’s premiere business intelligence (BI) platform, stands out for its powerful dashboard capabilities, transforming raw data into actionable insights. Through Power BI Consulting, businesses can harness these capabilities to not only visualize their data […]

This post first appeared at https://p3adaptive.com/power-bi-dashboards-for-your-business/. The author is Kristi Cantor

Read More

Read More

In the ever-changing world of data analytics, Microsoft Fabric stands out as a pioneering technology that is reshaping how businesses approach data integration, analysis, and visualization. At its core, Microsoft Fabric Data Analytics represents a suite of tools and services designed to enhance and streamline the processing of vast amounts of data across various sources. […]

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

Read More

Read More

The digital grapevine is buzzing with news that could reshape the landscape of data analytics within your organization. Microsoft has announced the retirement of legacy Power BI apps, ushering in an era of apps tailored for audiences. If you’re wondering about the ripple effects this change might have on your current data tools—or if you’ve […]

This post first appeared at https://p3adaptive.com/have-you-heard-power-bis-legacy-apps-are-being-retired/. The author is Marketing

Read More

Read More

Boost your productivity in DAX query view with Copilot to write and explain DAX queries. This post first appeared at https://powerbi.microsoft.com/en-us/blog/deep-dive-into-dax-query-view-with-copilot/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/deep-dive-into-dax-query-view-with-copilot/. The author is 

Read More

Read More

By far the most exciting announcement for me this week was the new release of Power BI Report Builder that has Power Query built in, allowing you to connect to far more data sources in paginated reports than you ever could before. There’s a very detailed blog post and video showing you how this new […]

This post first appeared at https://blog.crossjoin.co.uk/2024/03/31/power-bi-paginated-reports-that-connect-to-web-services-and-excel/. The author is Chris Webb

Read More

Read More

In today’s data-driven business landscape, the ability to effectively analyze and communicate data insights is a highly sought-after skill. Power BI Consulting services have become increasingly valuable as organizations strive to leverage the power of data visualization and business intelligence tools to make informed decisions. Among the various certifications offered in the field of data […]

This post first appeared at https://p3adaptive.com/what-is-a-power-bi-data-analyst-certification/. The author is Marketing

Read More

Read More

In the ever-evolving world of data analytics, Power BI has emerged as a game-changer, empowering professionals to transform raw data into insightful visualizations and actionable insights. Power BI Consulting services have become increasingly valuable as organizations strive to leverage the power of data-driven decision-making. As the demand for skilled Power BI professionals continues to rise, […]

This post first appeared at https://p3adaptive.com/power-bi-online-course-with-certificate/. The author is Marketing

Read More

Read More

As the world of data continues to grow exponentially, organizations are increasingly relying on tools like Power BI to gain valuable insights and make informed decisions. Power BI Consulting services have become a crucial component of many businesses, helping them harness the power of data visualization and analysis. In the ever-evolving landscape of data analytics, […]

This post first appeared at https://p3adaptive.com/is-power-bi-certification-worth-it-in-2024/. The author is Marketing

Read More

Read More