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 March we hosted over 4,200 data professionals in Las Vegas for the first-ever Microsoft Fabric Community Conference. When we set out to host this event, we knew there was a hunger in the community, but we had no idea the level of interest, and need, for connection amongst our Fabric users. It was an […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/announcing-microsoft-fabric-community-conference-europe/. The author isThe Power BI integration with Azure Log Analytics has been enhanced through the introduction of a new event known as ‘ExecutionMetrics’. This addition will improve customers ability to obtain more details about their semantic model activities. This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-executionmetrics-event-in-azure-log-analytics-for-power-bi-semantic-models/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-executionmetrics-event-in-azure-log-analytics-for-power-bi-semantic-models/. The author isIn the dynamic realm of analytics, understanding the distinct roles within the data analytics field is crucial for leveraging data effectively. Whether you’re working with top data analytics consulting firms or navigating internal data challenges, knowing the difference between a data analyst and an analytics consultant can significantly impact your strategic outcomes. Data analysts and […]
This post first appeared at https://p3adaptive.com/data-analyst-vs-analytics-consultant/. The author is Kristi CantorIn today’s data-driven business landscape, data and advanced analytics consulting stands out as an essential service for organizations aiming to leverage vast amounts of information for strategic advantage. This specialized field of consulting provides the expertise and tools necessary to transform complex data into actionable insights, empowering businesses to make informed decisions, streamline operations, and […]
This post first appeared at https://p3adaptive.com/what-is-data-and-analytics-consulting/. The author is Kristi CantorI have always wondered what the partialBatch option for the commitMode parameter in the Enhanced Refresh API does exactly. There is some documentation here and here but I was curious to find out more as part of the research I’m doing for my ongoing series on Power BI refresh memory errors, in case it was […]
This post first appeared at https://blog.crossjoin.co.uk/2024/05/12/the-partialbatch-commit-mode-in-the-power-bi-enhanced-refresh-api/. The author is Chris WebbLast 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 is