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
We’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 CantorBusiness Intelligence Consulting Services What Are The Types Of Data Integration? This post first appeared at https://p3adaptive.com/blog-what-are-the-types-of-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-types-of-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 CantorIf you’re using deployment pipelines with Direct Lake semantic models in Power BI you’ll have found that when you deploy your model from one stage to another by default the model still points to the Lakehouse it was originally bound to. So, for example, if you deploy your model from your Development stage to your […]
This post first appeared at https://blog.crossjoin.co.uk/2025/01/12/changing-the-source-lakehouse-of-power-bi-direct-lake-models-in-deployment-pipelines/?utm_source=rss&utm_medium=rss&utm_campaign=changing-the-source-lakehouse-of-power-bi-direct-lake-models-in-deployment-pipelines. The author is Chris WebbBig Data Data Strategy Consulting Big Data is Out, Small Data is In This post first appeared at https://p3adaptive.com/blog_big-data-is-out-small-data-is-in-why-the-industry-is-coming-full-circle/?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_big-data-is-out-small-data-is-in-why-the-industry-is-coming-full-circle/?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 Primary Purpose Of Data Integration? This post first appeared at https://p3adaptive.com/blog-what-is-the-primary-purpose-of-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-is-the-primary-purpose-of-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 CantorBusiness Intelligence Consulting Services What Is The Difference Between API And Data Integration? This post first appeared at https://p3adaptive.com/blog-what-is-the-difference-between-api-and-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-is-the-difference-between-api-and-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 CantorBusiness Intelligence Consulting Services What Is An Example Of Data Integration? This post first appeared at https://p3adaptive.com/blog-what-is-an-example-of-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-is-an-example-of-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 CantorPower BI reports are usually used to display numeric data. However it is reasonably common to have text data in a semantic model too and for this to be displayed on a report, and while visuals like the new text slicer allow you apply filters to the text, large amounts of text can still be […]
This post first appeared at https://blog.crossjoin.co.uk/2025/01/05/text-analysis-with-power-bi-copilot/?utm_source=rss&utm_medium=rss&utm_campaign=text-analysis-with-power-bi-copilot. The author is Chris WebbPredictive Analytics Now You Can: Harness Predictive Analytics with AI in Power BI This post first appeared at https://p3adaptive.com/_blog-harness-predictive-analytics-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/_blog-harness-predictive-analytics-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 CantorEvery year on this date I write a post reflecting on the previous year but, as you’ve probably guessed from the title, this is a special year: it’s twenty years since I started writing this blog. Twenty years ago today on the 30th of December 2004 I was working at IMS Health in London, I […]
This post first appeared at https://blog.crossjoin.co.uk/2024/12/30/20th-blog-birthday/?utm_source=rss&utm_medium=rss&utm_campaign=20th-blog-birthday. The author is Chris WebbBusiness Intelligence Consulting Services Data Integration Services This post first appeared at https://p3adaptive.com/data-integration-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/data-integration-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 Why Do So Many Data Warehouse Projects Fail? This post first appeared at https://p3adaptive.com/why-do-so-many-data-warehouse-projects-fail/?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/why-do-so-many-data-warehouse-projects-fail/?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 CantorI have known for a while that setting the Data Category property on a column can influence the results you get from Power BI Copilot but I have struggled to find a scenario where it actually makes a noticeable difference. My sources on the Power BI Copilot team told me that Copilot does consider geographic […]
This post first appeared at https://blog.crossjoin.co.uk/2024/12/29/power-bi-copilot-and-the-data-category-property/?utm_source=rss&utm_medium=rss&utm_campaign=power-bi-copilot-and-the-data-category-property. The author is Chris WebbData Strategy Consulting Ethics Meets Algorithms: Aligning AI with Your Company’s Mission This post first appeared at https://p3adaptive.com/blog_ethical-ai-strategies/?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_ethical-ai-strategies/?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 Is Data Warehousing Difficult? This post first appeared at https://p3adaptive.com/is-data-warehousing-difficult/?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/is-data-warehousing-difficult/?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