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
Today, we’re announcing changes to our pricing for Microsoft Power BI Pro and Premium Per User (PPU) licenses—this represents the first pricing update since we launched Power BI nearly 10 years ago. This post first appeared at https://powerbi.microsoft.com/en-us/blog/important-update-to-microsoft-power-bi-pricing/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/important-update-to-microsoft-power-bi-pricing/. The author isWe are thrilled to announce the release of Copilot in Power BI Mobile apps! This new feature brings the power of AI directly to your fingertips, enhancing your mobile experience and offering a quick and simple way to dive into your data while on the go. This post first appeared at https://powerbi.microsoft.com/en-us/blog/introducing-copilot-in-power-bi-mobile-apps-preview/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/introducing-copilot-in-power-bi-mobile-apps-preview/. The author isBusiness Intelligence Consulting Services Power BI Power Query PowerBI What Does A Business Intelligence Role Do? This post first appeared at https://p3adaptive.com/what-does-a-business-intelligence-role-do/. The author is Kristi CantorRead More
This post first appeared at https://p3adaptive.com/what-does-a-business-intelligence-role-do/. The author is Kristi CantorBusiness Intelligence Consulting Services Power BI Power Query PowerBI What Is A Business Intelligence Consultant? This post first appeared at https://p3adaptive.com/what-is-a-business-intelligence-consultant/. The author is Kristi CantorRead More
This post first appeared at https://p3adaptive.com/what-is-a-business-intelligence-consultant/. The author is Kristi CantorBusiness Intelligence Consulting Services Power BI Power Query PowerBI Business Intelligence Consulting Services This post first appeared at https://p3adaptive.com/business-intelligence-consulting-services/. The author is Kristi CantorRead More
This post first appeared at https://p3adaptive.com/business-intelligence-consulting-services/. The author is Kristi CantorContinuing my occasional series of ways you can improve the results you get from Power BI Copilot by setting properties on your semantic model, in this post I’ll look at how setting the Summarize By property can have an impact. Let’s say you have a semantic model that contains the following table of temperature readings […]
This post first appeared at https://blog.crossjoin.co.uk/2024/11/10/tuning-power-bi-copilot-with-summarize-by/?utm_source=rss&utm_medium=rss&utm_campaign=tuning-power-bi-copilot-with-summarize-by. The author is Chris WebbPower BI Power Query PowerBI Now You Can Save Time by Automating Repetitive Tasks This post first appeared at https://p3adaptive.com/save-time-automating-tasks-power-bi-power-query/. The author is Kristi CantorRead More
This post first appeared at https://p3adaptive.com/save-time-automating-tasks-power-bi-power-query/. The author is Kristi CantorMy post from a few months ago about the dangers of DAX measures that never return blank attracted quite a lot of attention – this is a hot topic on the forums and adding zeros to measures is a common cause of memory errors in Power BI. In that post, though, I didn’t talk about […]
This post first appeared at https://blog.crossjoin.co.uk/2024/11/03/different-ways-to-replace-blanks-with-zeros-in-dax/?utm_source=rss&utm_medium=rss&utm_campaign=different-ways-to-replace-blanks-with-zeros-in-dax. The author is Chris WebbManufacturing Data Analytics Manufacturing KPI Dashboard This post first appeared at https://p3adaptive.com/manufacturing-kpi-dashboard/. The author is Kristi CantorRead More
This post first appeared at https://p3adaptive.com/manufacturing-kpi-dashboard/. The author is Kristi CantorIf you’re the admin for a large Power BI/Fabric tenant you’ll know how important it is to monitor your on-premises data gateways: if they aren’t working then no-one will be able to refresh any semantic models or dataflows connected to on-prem sources. A while ago Rui Romano published a gateway monitoring solution that proved to […]
This post first appeared at https://blog.crossjoin.co.uk/2024/10/27/new-solution-for-monitoring-power-bi-fabric-gateways/?utm_source=rss&utm_medium=rss&utm_campaign=new-solution-for-monitoring-power-bi-fabric-gateways. The author is Chris WebbManufacturing Data Analytics Production Data Analysis In Excel This post first appeared at https://p3adaptive.com/production-data-analysis-in-excel/. The author is Kristi CantorRead More
This post first appeared at https://p3adaptive.com/production-data-analysis-in-excel/. The author is Kristi CantorWe have just released a new update of BI Pixie (now available on Azure Marketplace and Microsoft AppSource) to help you analyze how design choices can impact user engagement and the effectiveness of your reports. The motivation behind the new feature is rooted in the law of diminishing returns. At what point does an increase […]
This post first appeared at https://datachant.com/2024/10/23/how-do-design-choices-in-power-bi-impact-user-engagement/. The author is Gil RavivPower BI’s mission is to empower every individual, team, and organization to make confident decisions with data. With the increased focus on governance, compliance, and policy, customers need greater visibility into workflows and related activities. Tenant Administrators need out-of-box datasets and reports to understand tenant level adoption and deep dive on such details as active […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-admin-monitoring-workspace-is-now-available-in-these-government-cloud-tenants-gcc-gcc-high-dod-usnat-ussec-and-mooncake/. The author isManufacturing Data Analytics What Is An Example Of Supply Chain Analysis? This post first appeared at https://p3adaptive.com/what-is-an-example-of-supply-chain-analysis/. The author is Kristi CantorRead More
This post first appeared at https://p3adaptive.com/what-is-an-example-of-supply-chain-analysis/. The author is Kristi CantorSome time ago I wrote a post about how you can use the DISCOVER_CALC_DEPENDENCY DMV to get a list of all the tables, columns and relationships referenced by a DAX query. That’s really useful and indeed the new INFO.CALCDEPENDENCY DAX function allows you to do the same thing without all the complexity of calling a […]
This post first appeared at https://blog.crossjoin.co.uk/2024/10/20/finding-the-columns-touched-by-a-dax-query/?utm_source=rss&utm_medium=rss&utm_campaign=finding-the-columns-touched-by-a-dax-query. The author is Chris WebbYou can use Power BI Desktop to live edit Direct Lake semantic models, improving your data modeling experience and allowing export to Power BI Project (PBIP) for professional development workflows. This post first appeared at https://powerbi.microsoft.com/en-us/blog/live-edit-of-direct-lake-models-in-power-bi-desktop/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/live-edit-of-direct-lake-models-in-power-bi-desktop/. The author isWe have a lot of exciting updates to share with you this month. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-october-2024-feature-summary/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-october-2024-feature-summary/. The author isToday, we are announcing that we will be retiring real-time streaming in Power BI. This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-the-retirement-of-real-time-streaming-in-power-bi/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-the-retirement-of-real-time-streaming-in-power-bi/. The author isDAX Downloads Data Analytics Made Easy: Download Our Power BI DAX Reference Card This post first appeared at https://p3adaptive.com/reference_card/. The author is Kristi CantorRead More
This post first appeared at https://p3adaptive.com/reference_card/. The author is Kristi CantorI’m a big fan of Kurt Buhler‘s work (indeed we like him so much at Microsoft that we get him to help out with our docs) and I have a lot of respect for his opinion. A few weeks ago, in a thread on Twitter/X, he asked an important question about Power BI Copilot: why […]
This post first appeared at https://blog.crossjoin.co.uk/2024/10/13/why-would-you-use-power-bi-copilot/?utm_source=rss&utm_medium=rss&utm_campaign=why-would-you-use-power-bi-copilot. The author is Chris Webb