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
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 MarketingMicrosoft 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 MarketingIn 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 CantorThere 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 WebbThis 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 isLast 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 TeamPower 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 isEarlier 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 isPowerPoint 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 isThe 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 WebbIn 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 CantorIn 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 CantorThe 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 MarketingBoost 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 isBy 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 WebbIn 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 MarketingIn 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 MarketingAs 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 MarketingConnect to100+ data sources and create paginated reports. This post first appeared at https://powerbi.microsoft.com/en-us/blog/get-data-with-power-query-available-in-power-bi-report-builder-preview/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/get-data-with-power-query-available-in-power-bi-report-builder-preview/. The author isWe are excited to announce that Mirroring, previously announced at Ignite in November 2023, is now available to customers in Public Preview. You can now seamlessly bring your databases into OneLake in Microsoft Fabric, enabling seamless zero-ETL, near real-time insights on your data – and unlocking warehousing, BI, AI, and more. This post first appeared […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-the-public-preview-of-database-mirroring-in-microsoft-fabric/. The author is