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
Last May, we announced the integration between Power BI and OneDrive and SharePoint (ODSP) that allows you to view Power BI reports directly in a OneDrive or SharePoint document library. Previously, this capability was limited only to reports with data in import mode. We’re excited to announce that you can now view Power BI reports […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-live-connect-for-power-bi-report-integration-with-onedrive-and-sharepoint/. The author isIn today’s dynamic business world, the need for data analytics consulting is becoming increasingly crucial. Companies from all sectors are looking to make smarter, data-driven decisions, and they need the right guidance to do so effectively. Data analytics consulting isn’t just about looking at numbers; it’s about transforming these numbers into actionable insights that can […]
This post first appeared at https://p3adaptive.com/data-analytics-consulting/. The author is Kristi CantorIn the Power BI Service, Import mode models are stored offline and paged into memory only when they are needed – for example because someone runs a report that uses the model as its source. As discussed in my last post, though, there’s a limit on the amount of memory that a model can use […]
This post first appeared at https://blog.crossjoin.co.uk/2024/05/05/power-bi-semantic-model-memory-errors-part-2-max-offline-semantic-model-size/. The author is Chris WebbIn the dynamic realm of Microsoft Fabric Data Analytics, mastering development workflows and refining data analytics processes are pivotal for organizational success. One essential tool in this landscape is Git integration—a powerful solution that enhances collaboration and version control within Microsoft Fabric and Power BI. Git integration serves as the backbone for streamlined collaboration and […]
This post first appeared at https://p3adaptive.com/git-integration/. The author is Kristi CantorIn today’s ever-evolving tech landscape, mastering development workflows and refining data analytics processes are crucial for organizational success. That’s where Git integration with Fabric comes into play—an innovative solution that transforms collaboration and version control within Microsoft Fabric data analytics and Power BI. This integration not only enhances project management but also underscores the importance […]
This post first appeared at https://p3adaptive.com/git-integration-with-fabric/. The author is Kristi CantorNavigating the complex world of data doesn’t have to be a daunting task. Power BI, Microsoft’s premier analytics platform, offers a suite of tools that simplify data analysis and visualization, empowering businesses to unlock valuable insights with ease. This guide will introduce you to the extensive features of Power BI, highlighting how it stands as […]
This post first appeared at https://p3adaptive.com/power-bi-features/. The author is Kristi CantorKeeping up with the latest business intelligence tools is key to staying on top in today’s data-driven world. Microsoft’s Power BI is constantly evolving, offering new updates to meet users’ needs. It’s important to regularly update your Power BI setup so you can enjoy the latest features, enhancements, and security improvements that Microsoft rolls out. […]
This post first appeared at https://p3adaptive.com/power-bi-updates/. The author is Kristi CantorYou probably know that semantic models in Power BI can use a fixed amount of memory. This is true of all types of semantic model – Import, Direct Lake and DirectQuery – but it’s not something you usually need to worry about for DirectQuery mode. The amount of memory they can use depends on whether […]
This post first appeared at https://blog.crossjoin.co.uk/2024/04/28/power-bi-semantic-model-memory-errors-part-1-model-size/. The author is Chris WebbFollowing the announcement of the deprecation of creation of Power BI Automated Machine Learning (AutoML) models for Dataflows V1, the feature has now been deprecated in all regions as of the third week of April. This post first appeared at https://powerbi.microsoft.com/en-us/blog/deprecation-of-automl-in-power-bi-using-dataflows-v1/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/deprecation-of-automl-in-power-bi-using-dataflows-v1/. The author isIn the dynamic and constantly evolving realm of data analytics, the integration of Excel and CSV file support directly into the report creation experience in Fabric, which is now in public preview, marks a significant leap forward. This development in Microsoft Fabric Data Analytics is streamlining workflows for data analysts and other information workers, making […]
This post first appeared at https://p3adaptive.com/excel-and-csv-connectors-in-fabric-a-game-changer-for-data-analysis/. The author is Kristi CantorIn the ever-evolving landscape of technology, staying ahead means constantly updating your skills. This is where Microsoft Certifications come into play, acting as a beacon for professionals aiming to validate their technical expertise. Among the myriad options, from the easiest Microsoft certifications to the most challenging ones, making an informed choice can be daunting. But […]
This post first appeared at https://p3adaptive.com/what-is-the-hardest-microsoft-certification-to-get/. The author is Kristi CantorIn the realm of business analytics, the ability to quickly sift through complex analytics and transform vast datasets into insightful, actionable intelligence has always been crucial. Power BI stands as a pillar of innovation in this space, offering a comprehensive suite of tools that make data analysis both accessible and deeply informative. This blog takes […]
This post first appeared at https://p3adaptive.com/power-bi-visual-calculations/. The author is Kristi CantorIn the ever-changing world of business intelligence, mastering the art of dashboard creation in Power BI is an important skill for translating complex datasets into actionable business insights. Through adept Power BI consulting, organizations are equipped to craft dashboards that not only simplify data analysis but also transform it into an engaging narrative. These dashboards […]
This post first appeared at https://p3adaptive.com/how-do-i-create-a-power-bi-dashboard/. The author is Kristi CantorIt’s time for another short post on the free books that various authors have been kind enough to send me over the last few months. Full disclosure: these aren’t reviews as such, they’re more like free publicity in return for the free books, and I don’t pretend to be unbiased; also the Amazon UK links […]
This post first appeared at https://blog.crossjoin.co.uk/2024/04/21/power-bi-data-books-roundup/. The author is Chris WebbWe are excited to announce the April 2024 release of the on-premises data gateway! This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-april-2024-release/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-april-2024-release/. The author isWe have some exciting announcements to share regarding Copilot in Microsoft Fabric. The information in this blog post has also been shared with Fabric tenant administrators. Below are the highlights of the changes. This post first appeared at https://powerbi.microsoft.com/en-us/blog/copilot-in-power-bi-soon-available-to-more-users-in-your-organization/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/copilot-in-power-bi-soon-available-to-more-users-in-your-organization/. The author isIn 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 Webb