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
A few weeks ago I replied to a question on reddit where someone was experiencing extremely slow performance when importing data from a CSV file using Power Query. The original poster worked out the cause of the problem and the solution themselves: they saw that removing all date columns from their query made their Power […]
This post first appeared at https://blog.crossjoin.co.uk/2025/02/09/improve-power-query-performance-on-csv-files-containing-date-columns/?utm_source=rss&utm_medium=rss&utm_campaign=improve-power-query-performance-on-csv-files-containing-date-columns. The author is Chris WebbData Strategy Consulting Now You Can Bring AI into the Workplace The Right Way | AI Workplace Strategy This post first appeared at https://p3adaptive.com/now-you-can-bring-ai-into-the-workplace-the-right-way-ai-workplace-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/now-you-can-bring-ai-into-the-workplace-the-right-way-ai-workplace-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 CantorData Strategy Consulting Data Debt: The Silent Killer of AI Ambition This post first appeared at https://p3adaptive.com/blog_data-debt-why-ai-data-quality-matters/?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_data-debt-why-ai-data-quality-matters/?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 CantorConsider this use-case: You built a sales dashboard for hundreds of sellers in your organization. The dashboard provides them current statuses and KPIs and links to hundreds useful resources by product including sales collateral and demos. Would it be great if you could analyze the popularity of your products and sales collateral by the amount […]
This post first appeared at https://datachant.com/2025/02/03/data-auditing-in-power-bi/. The author is Gil RavivWe are excited to announce that writing DAX queries with Copilot can utilize semantic model descriptions, synonyms, and sample values from columns. This post first appeared at https://powerbi.microsoft.com/en-us/blog/microsoft-fabric-copilot-to-write-dax-queries-in-power-bi-update/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/microsoft-fabric-copilot-to-write-dax-queries-in-power-bi-update/. The author isThe recent announcement of Surge Protection gives Fabric/Power BI capacity admins a way to restrict the impact of background operations on a capacity, preventing them from causing throttling. However, at the time of writing, Surge Protection does not prevent users that are running expensive DAX or MDX queries – which are interactive operations – from […]
This post first appeared at https://blog.crossjoin.co.uk/2025/02/02/limit-the-impact-of-expensive-power-bi-queries-on-your-capacity-by-reducing-the-query-timeout/?utm_source=rss&utm_medium=rss&utm_campaign=limit-the-impact-of-expensive-power-bi-queries-on-your-capacity-by-reducing-the-query-timeout. The author is Chris WebbData Strategy Consulting Now You Can: Transform Your Legacy Systems Without Starting Over This post first appeared at https://p3adaptive.com/blog_transform-legacy-systems-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_transform-legacy-systems-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 CantorThis is a post I’ve avoided writing for many years, and before I carry on let me make one thing clear: Doing bulk extracts of data from a Power BI semantic model is a **really** bad idea This post first appeared at https://blog.crossjoin.co.uk/2025/01/26/why-dax-is-better-than-mdx-for-bulk-extracts-of-data-from-power-bi/?utm_source=rss&utm_medium=rss&utm_campaign=why-dax-is-better-than-mdx-for-bulk-extracts-of-data-from-power-bi. The author is Chris WebbRead More
This post first appeared at https://blog.crossjoin.co.uk/2025/01/26/why-dax-is-better-than-mdx-for-bulk-extracts-of-data-from-power-bi/?utm_source=rss&utm_medium=rss&utm_campaign=why-dax-is-better-than-mdx-for-bulk-extracts-of-data-from-power-bi. The author is Chris WebbThe post Now You Can: Optimize Inventory with AI-Powered Forecasting appeared first on P3 Adaptive. This post first appeared at https://p3adaptive.com/now-you-can-optimize-inventory-with-ai-powered-forecasting/?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 Support TeamRead More
This post first appeared at https://p3adaptive.com/now-you-can-optimize-inventory-with-ai-powered-forecasting/?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 Support TeamThis is a stand alone blog for the Copilot summaries in subscriptions feature. This post first appeared at https://powerbi.microsoft.com/en-us/blog/add-copilot-summaries-to-power-bi-email-subscriptions-preview/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/add-copilot-summaries-to-power-bi-email-subscriptions-preview/. The author isPower BI Report Server January 2025 Feature Summary This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-january-2025-feature-summary/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-january-2025-feature-summary/. The author isBusiness Intelligence Consulting Services Who Needs Data Visualization? This post first appeared at https://p3adaptive.com/blog-who-needs-data-visualization/?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-who-needs-data-visualization/?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 CantorBusiness Intelligence Consulting Services What Is The Most Popular Data Visualization Tool? This post first appeared at https://p3adaptive.com/blog-what-is-the-most-popular-data-visualization-tool/?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-what-is-the-most-popular-data-visualization-tool/?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 CantorFor me the biggest new feature in the January 2025 release of Power BI Desktop is the new TMDL View; many other people like Marco are excited about it too. For more advanced Power BI developers (and honestly, I don’t think you need to be that advanced to get value out of it) it makes […]
This post first appeared at https://blog.crossjoin.co.uk/2025/01/19/tmdl-view-and-power-bi-developer-productivity-an-example-using-the-detail-rows-definition-property/?utm_source=rss&utm_medium=rss&utm_campaign=tmdl-view-and-power-bi-developer-productivity-an-example-using-the-detail-rows-definition-property. The author is Chris WebbWe’re excited to introduce TMDL view for Power BI Desktop. This new feature lets you script, modify, and apply changes using Tabular Model Definition Language (TMDL), providing an alternative experience to semantic modeling using code, instead of a graphical user interface such as Model view. This post first appeared at https://powerbi.microsoft.com/en-us/blog/deep-dive-into-tmdl-view-for-power-bi-desktop-preview/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/deep-dive-into-tmdl-view-for-power-bi-desktop-preview/. The author isWe are thrilled to announce that we have made updates to the Power BI file picker to create an easier and more intuitive time navigating through existing files and saving new files. This post first appeared at https://powerbi.microsoft.com/en-us/blog/save-to-onedrive-and-sharepoint-updated-file-picker-public-preview/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/save-to-onedrive-and-sharepoint-updated-file-picker-public-preview/. The author isAI Consulting Services Train an AI for Your Business This post first appeared at https://p3adaptive.com/blog_train-your-ai-without-losing-control/?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_train-your-ai-without-losing-control/?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 CantorWelcome to the January 2025 update! This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-january-2025-feature-summary/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-january-2025-feature-summary/. The author isBusiness Intelligence Consulting Services Data Visualization Services This post first appeared at https://p3adaptive.com/blog-data-visualization-services/?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-data-visualization-services/?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 CantorBusiness Intelligence Consulting Services What Are The Three Major Steps For Data Integration? This post first appeared at https://p3adaptive.com/blog-what-are-the-three-major-steps-for-data-integration/?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-what-are-the-three-major-steps-for-data-integration/?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