Select Page
In The Trenches

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

Paul Hansen is an experienced Analytics Engineer and Senior BI Developer, skilled in data architecture, ETL processes, and data visualization. He has a strong background in SQL, Python, and cloud platforms like AWS and Azure. Paul has led teams to create integrated data solutions, leveraging tools such as dbt, SSIS, and Power BI. His recent roles have ranged from Senior BI Developer to BI Team Lead, demonstrating his ability to manage complex projects and deliver insightful business intelligence solutions. Paul values a collaborative work environment that fosters innovation and professional growth.

Please access his resume here:
Paul Hansen – Business Intelligence Professional 2023
LinkedIn Profile: https://www.linkedin.com/in/paulhansenza/

Contact Me

Business Intelligence and Analytics Blog

Last summer, Sanofi launched an exciting data viz challenge on the topic of the Paris Olympics.   This post first appeared at https://powerbi.microsoft.com/en-us/blog/sanofis-power-bi-data-visualization-competition-an-inspiring-initiative-focused-on-the-paris-olympic-games/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/sanofis-power-bi-data-visualization-competition-an-inspiring-initiative-focused-on-the-paris-olympic-games/. The author is 

Read More

Read More

Read on to learn about the Power BI DataViz World Championship, an event that spanned 6 weeks and culminated in Jon Sandmann taking the title live on stage in Las Vegas at the Microsoft Fabric Community Conference. This post first appeared at https://powerbi.microsoft.com/en-us/blog/congratulations-to-jon-sandmann-the-first-power-bi-dataviz-world-champion/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/congratulations-to-jon-sandmann-the-first-power-bi-dataviz-world-champion/. The author is 

Read More

Read More

Now that Fabric Data Agents (what used to be called AI Skills) can use Power BI semantic models as a data source I’ve been spending some time playing around with them, and while I was doing that I realised something – maybe something obvious, but I think still worth writing about. It’s that there are […]

This post first appeared at https://blog.crossjoin.co.uk/2025/04/06/fabric-data-agents-unlocking-the-full-power-of-dax-for-data-analysis/?utm_source=rss&utm_medium=rss&utm_campaign=fabric-data-agents-unlocking-the-full-power-of-dax-for-data-analysis. The author is Chris Webb

Read More

Read More

In this blog post find overview of the latest updates and future plans for org apps (preview) in Power BI. Highlighting new customization options, Git support, and deployment pipelines that enhance the development and deployment of org apps. Additionally, this post outlines upcoming features such as support for Pro workspaces, paginated reports, mobile app viewing, […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/updates-to-org-apps-preview-more-customization-deployment-pipelines-and-git-plus-whats-next-like-new-license-support-and-audiences/. The author is 

Read More

Read More

We are excited to introduce one-click experiences that make it easier than ever to start using Fabric notebooks and semantic link to analyze your semantic models on the web! With pre-configured notebooks, you can effortlessly run Best practice analyzer and Memory analyzer to improve design, performance, and memory optimization of your semantic models. Additionally, explore […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/deep-dive-into-using-notebooks-with-your-semantic-model-preview/. The author is 

Read More

Read More

Transform data storytelling with data point annotations added to Power BI visuals in PowerPoint. The new Annotations feature enables you to communicate insights with greater efficacy and enhance the engagement and informativeness of your presentation. By adding data point annotations to visuals in your slides, you can provide contextual explanations or highlights attached to the […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/uplift-your-storytelling-by-using-annotations-on-your-power-bi-visualization-in-powerpoint-preview/. The author is 

Read More

Read More

This month, we’re thrilled to bring you a host of new features and improvements designed to enhance your data analysis and visualization experience. We’ve made significant strides in performance and usability, ensuring that Power BI continues to be a powerful tool for your data needs. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-march-2025-feature-summary/. The author is Read More

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

Read More

Read More

Although it was announced in this blog post on the Microsoft 365 Insider blog recently, you might have missed the news that Excel Copilot can now generate Power Query queries. There are limitations for now: it can only be used to connect to other Excel files stored in OneDrive or SharePoint and it can’t do […]

This post first appeared at https://blog.crossjoin.co.uk/2025/03/30/using-excel-copilot-to-import-data-with-power-query/?utm_source=rss&utm_medium=rss&utm_campaign=using-excel-copilot-to-import-data-with-power-query. The author is Chris Webb

Read More

Read More

Starting from the next Power BI Mobile app update, the apps will no longer be able to connect to Report Server using the OAuth protocol through AD FS configured on Windows Server 2016. Using AD FS 2019 or newer will continue to be supported by the apps. This post first appeared at https://powerbi.microsoft.com/en-us/blog/upcoming-changes-to-power-bi-mobile-app-support-for-adfs-2016/. The author is Read […]

This post first appeared at https://powerbi.microsoft.com/en-us/blog/upcoming-changes-to-power-bi-mobile-app-support-for-adfs-2016/. The author is 

Read More

Read More

With the exciting release of Microsoft Fabric and the Fabric capacity products, we announced last May we are consolidating purchase options and retiring the Microsoft Power BI Premium per capacity products. This post first appeared at https://powerbi.microsoft.com/en-us/blog/grace-period-for-transitioning-from-power-bi-premium-to-microsoft-fabric/. The author is Read More

This post first appeared at https://powerbi.microsoft.com/en-us/blog/grace-period-for-transitioning-from-power-bi-premium-to-microsoft-fabric/. The author is 

Read More

Read More

As a BI leader or a Power BI expert you know how hard it is to collect user feedback from your BI audience. It is even harder to measure the ROI of your reports and make informed decisions on future investments. Today I can share that this challenge can be solved with March update of […]

This post first appeared at https://datachant.com/2025/03/24/embedded-surveys-in-power-bi/. The author is Gil Raviv

Read More

Read More

Data Strategy Consulting The Executive’s Guide to Data Strategy: Aligning Data with Business Goals This post first appeared at https://p3adaptive.com/blog_executive-data-strategy-guide/?utm_source=google&utm_medium=cpc&utm_term=p3%20adaptive&utm_content=US_Awareness_BrandP3Brand_Malificent&utm_campaign=US_Brand_BrandRecBrandRec_TheOne&gclid=CjwKCAjwrIixBhBbEiwACEqDJek7yJFN180C-vRI3ZEQ8c9NkbwiLLMUOzbWbKSgrp3clSdDJUefVBoCoBcQAvD_BwE. The author is Kristi CantorRead More

This post first appeared at https://p3adaptive.com/blog_executive-data-strategy-guide/?utm_source=google&utm_medium=cpc&utm_term=p3%20adaptive&utm_content=US_Awareness_BrandP3Brand_Malificent&utm_campaign=US_Brand_BrandRecBrandRec_TheOne&gclid=CjwKCAjwrIixBhBbEiwACEqDJek7yJFN180C-vRI3ZEQ8c9NkbwiLLMUOzbWbKSgrp3clSdDJUefVBoCoBcQAvD_BwE. The author is Kristi Cantor

Read More

Read More

Power BI Consulting Power BI Consulting For C-Suite Power BI For Project Management This post first appeared at https://p3adaptive.com/blog-power-bi-for-project-management/?utm_source=google&utm_medium=cpc&utm_term=p3%20adaptive&utm_content=US_Awareness_BrandP3Brand_Malificent&utm_campaign=US_Brand_BrandRecBrandRec_TheOne&gclid=CjwKCAjwrIixBhBbEiwACEqDJek7yJFN180C-vRI3ZEQ8c9NkbwiLLMUOzbWbKSgrp3clSdDJUefVBoCoBcQAvD_BwE. The author is Kristi CantorRead More

This post first appeared at https://p3adaptive.com/blog-power-bi-for-project-management/?utm_source=google&utm_medium=cpc&utm_term=p3%20adaptive&utm_content=US_Awareness_BrandP3Brand_Malificent&utm_campaign=US_Brand_BrandRecBrandRec_TheOne&gclid=CjwKCAjwrIixBhBbEiwACEqDJek7yJFN180C-vRI3ZEQ8c9NkbwiLLMUOzbWbKSgrp3clSdDJUefVBoCoBcQAvD_BwE. The author is Kristi Cantor

Read More

Read More

Power BI Consulting Power BI Consulting For C-Suite BI Consulting For Corporate Innovation This post first appeared at https://p3adaptive.com/blog-bi-consulting-for-corporate-innovation/?utm_source=google&utm_medium=cpc&utm_term=p3%20adaptive&utm_content=US_Awareness_BrandP3Brand_Malificent&utm_campaign=US_Brand_BrandRecBrandRec_TheOne&gclid=CjwKCAjwrIixBhBbEiwACEqDJek7yJFN180C-vRI3ZEQ8c9NkbwiLLMUOzbWbKSgrp3clSdDJUefVBoCoBcQAvD_BwE. The author is Kristi CantorRead More

This post first appeared at https://p3adaptive.com/blog-bi-consulting-for-corporate-innovation/?utm_source=google&utm_medium=cpc&utm_term=p3%20adaptive&utm_content=US_Awareness_BrandP3Brand_Malificent&utm_campaign=US_Brand_BrandRecBrandRec_TheOne&gclid=CjwKCAjwrIixBhBbEiwACEqDJek7yJFN180C-vRI3ZEQ8c9NkbwiLLMUOzbWbKSgrp3clSdDJUefVBoCoBcQAvD_BwE. The author is Kristi Cantor

Read More

Read More

If you’re working with slow data sources in Power BI/Fabric dataflows then you’re probably aware that validation (for Gen1 dataflows) or publishing (for Gen2 dataflows) them can sometimes take a long time. If you’re working with very slow data sources then you may run into the 10 minute timeout on validation/publishing that is documented here. […]

This post first appeared at https://blog.crossjoin.co.uk/2025/03/23/speed-up-dataflow-publishing-validation-times-in-power-bi-and-fabric/?utm_source=rss&utm_medium=rss&utm_campaign=speed-up-dataflow-publishing-validation-times-in-power-bi-and-fabric. The author is Chris Webb

Read More

Read More

Here is Gil’s recorded session in Power BI & Fabric Summit 2025 Here is the summary of the presentation: This post first appeared at https://datachant.com/2025/03/18/measuring-the-effectiveness-of-your-power-bi-dashboards/. The author is DataChant TeamRead More

This post first appeared at https://datachant.com/2025/03/18/measuring-the-effectiveness-of-your-power-bi-dashboards/. The author is DataChant Team

Read More

Read More

Data Strategy Consulting Strategy & Corporate Success The ROI of a Smart Data Strategy This post first appeared at https://p3adaptive.com/blog_-roi-of-smart-data-strategy/?utm_source=google&utm_medium=cpc&utm_term=p3%20adaptive&utm_content=US_Awareness_BrandP3Brand_Malificent&utm_campaign=US_Brand_BrandRecBrandRec_TheOne&gclid=CjwKCAjwrIixBhBbEiwACEqDJek7yJFN180C-vRI3ZEQ8c9NkbwiLLMUOzbWbKSgrp3clSdDJUefVBoCoBcQAvD_BwE. The author is Kristi CantorRead More

This post first appeared at https://p3adaptive.com/blog_-roi-of-smart-data-strategy/?utm_source=google&utm_medium=cpc&utm_term=p3%20adaptive&utm_content=US_Awareness_BrandP3Brand_Malificent&utm_campaign=US_Brand_BrandRecBrandRec_TheOne&gclid=CjwKCAjwrIixBhBbEiwACEqDJek7yJFN180C-vRI3ZEQ8c9NkbwiLLMUOzbWbKSgrp3clSdDJUefVBoCoBcQAvD_BwE. The author is Kristi Cantor

Read More

Read More

Power BI Consulting Power BI Consulting For C-Suite Enterprise Power BI Strategy Consulting This post first appeared at https://p3adaptive.com/enterprise-power-bi-strategy-consulting/?utm_source=google&utm_medium=cpc&utm_term=p3%20adaptive&utm_content=US_Awareness_BrandP3Brand_Malificent&utm_campaign=US_Brand_BrandRecBrandRec_TheOne&gclid=CjwKCAjwrIixBhBbEiwACEqDJek7yJFN180C-vRI3ZEQ8c9NkbwiLLMUOzbWbKSgrp3clSdDJUefVBoCoBcQAvD_BwE. The author is Kristi CantorRead More

This post first appeared at https://p3adaptive.com/enterprise-power-bi-strategy-consulting/?utm_source=google&utm_medium=cpc&utm_term=p3%20adaptive&utm_content=US_Awareness_BrandP3Brand_Malificent&utm_campaign=US_Brand_BrandRecBrandRec_TheOne&gclid=CjwKCAjwrIixBhBbEiwACEqDJek7yJFN180C-vRI3ZEQ8c9NkbwiLLMUOzbWbKSgrp3clSdDJUefVBoCoBcQAvD_BwE. The author is Kristi Cantor

Read More

Read More

Power BI Consulting Power BI Consulting For C-Suite Data-Driven Decision-Making with Power BI This post first appeared at https://p3adaptive.com/data-driven-decision-making-with-power-bi/?utm_source=google&utm_medium=cpc&utm_term=p3%20adaptive&utm_content=US_Awareness_BrandP3Brand_Malificent&utm_campaign=US_Brand_BrandRecBrandRec_TheOne&gclid=CjwKCAjwrIixBhBbEiwACEqDJek7yJFN180C-vRI3ZEQ8c9NkbwiLLMUOzbWbKSgrp3clSdDJUefVBoCoBcQAvD_BwE. The author is Kristi CantorRead More

This post first appeared at https://p3adaptive.com/data-driven-decision-making-with-power-bi/?utm_source=google&utm_medium=cpc&utm_term=p3%20adaptive&utm_content=US_Awareness_BrandP3Brand_Malificent&utm_campaign=US_Brand_BrandRecBrandRec_TheOne&gclid=CjwKCAjwrIixBhBbEiwACEqDJek7yJFN180C-vRI3ZEQ8c9NkbwiLLMUOzbWbKSgrp3clSdDJUefVBoCoBcQAvD_BwE. The author is Kristi Cantor

Read More

Read More

Power BI Consulting Power BI Consulting For C-Suite How To Improve Business Performance With Power BI This post first appeared at https://p3adaptive.com/how-to-improve-business-performance-with-power-bi/?utm_source=google&utm_medium=cpc&utm_term=p3%20adaptive&utm_content=US_Awareness_BrandP3Brand_Malificent&utm_campaign=US_Brand_BrandRecBrandRec_TheOne&gclid=CjwKCAjwrIixBhBbEiwACEqDJek7yJFN180C-vRI3ZEQ8c9NkbwiLLMUOzbWbKSgrp3clSdDJUefVBoCoBcQAvD_BwE. The author is Kristi CantorRead More

This post first appeared at https://p3adaptive.com/how-to-improve-business-performance-with-power-bi/?utm_source=google&utm_medium=cpc&utm_term=p3%20adaptive&utm_content=US_Awareness_BrandP3Brand_Malificent&utm_campaign=US_Brand_BrandRecBrandRec_TheOne&gclid=CjwKCAjwrIixBhBbEiwACEqDJek7yJFN180C-vRI3ZEQ8c9NkbwiLLMUOzbWbKSgrp3clSdDJUefVBoCoBcQAvD_BwE. The author is Kristi Cantor

Read More

Read More