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
Microsoft offers a diverse spectrum of certifications, each tailored to different levels of expertise and various professional roles. Whether it’s the foundational knowledge of Microsoft 365, the intricate workings of Microsoft Fabric Data Analytics, or the advanced capabilities in Azure, these certifications embody a professional’s commitment to staying abreast of technological advancements and their ability […]
This post first appeared at https://p3adaptive.com/are-microsoft-certifications-still-worth-it/. The author is MarketingSurvey the field of data management and analysis today, and you’ll notice the pivotal role of Microsoft Fabric Data Analytics. It has swiftly become a key player, renowned for its ability to simplify complex data challenges with remarkable efficiency and adaptability. As we move forward, its influence across various sectors seems only set to expand. […]
This post first appeared at https://p3adaptive.com/microsoft-fabric-tutorial/. The author is MarketingAs a Power BI consulting service, we understand that it’s crucial for your analytics process to use accurate data. Reports and dashboards that show the “truth” are what really help in data-driven decision-making. Master Data Management (MDM) is a solution that helps organizations maintain their critical data. In this article, we’ll help you understand its […]
This post first appeared at https://p3adaptive.com/power-bi-master-data-management/. The author is MarketingIn Power BI, you can create insightful reports and dashboards to meet your data visualization needs. While dashboards allow you to see important metrics at a glance, reports provide more detailed information to help you analyze data. Reports and dashboards are two separate entities. However, you might find people referring to dashboards when they mean […]
This post first appeared at https://p3adaptive.com/power-bi-reports-examples-and-practice-guide/. The author is MarketingA dashboard is more than just charts and graphs. It’s the voice of your analytics process, a visual storyteller that translates complex data into actionable insights. Moreover, it facilitates sharing and collaboration around results, empowering businesses to excel in their respective domains. As a leading Power BI consulting service, we at P3 Adaptive have built […]
This post first appeared at https://p3adaptive.com/power-bi-sample-dashboards/. The author is MarketingI don’t have anything against the use of calculated columns in Power BI semantic models in general but you do need to be careful using them with DirectQuery mode. In particular when you have a DirectQuery connection to another Power BI semantic model – also known as a composite model on a Power BI semantic […]
This post first appeared at https://blog.crossjoin.co.uk/2024/02/04/performance-implications-of-using-calculated-columns-in-composite-models-on-power-bi-semantic-models/. The author is Chris WebbAs you may know, Microsoft has an MVP Programme where it acknowledges and rewards community leaders for their subject matter expertise and contribution to the community. There are many benefits of being an MVP including the recognition (leading to people understanding that you must be doing something right if Microsoft […]Read More » This post […]
This post first appeared at https://exceleratorbi.com.au/my-journey-as-microsoft-mvp-is-coming-to-an-end/. The author is Matt AllingtonWe are excited to announce that the VNet Data Gateway is now GA! Read the blog to find out more and get started using the VNet Data Gateway to secure your production workloads. This post first appeared at https://powerbi.microsoft.com/en-us/blog/vnet-data-gateway-for-fabric-and-power-bi-is-now-generally-available/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/vnet-data-gateway-for-fabric-and-power-bi-is-now-generally-available/. The author isAnnouncing the availability of the partner solution accelerators for embedded analytics This post first appeared at https://powerbi.microsoft.com/en-us/blog/accelerating-embedded-analytics-for-your-application/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/accelerating-embedded-analytics-for-your-application/. The author isMicrosoft Fabric is now HIPAA compliant This post first appeared at https://powerbi.microsoft.com/en-us/blog/microsoft-fabric-is-now-hipaa-compliant/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/microsoft-fabric-is-now-hipaa-compliant/. The author isOne of the most popular questions on the forums I follow is “How can I learn Power BI and Fabric?”. There are a ton of great, free online resources out there – blogs, videos and so on – but the people answering this question often do not mention user groups and conferences. I think that’s […]
This post first appeared at https://blog.crossjoin.co.uk/2024/01/30/learning-power-bi-and-fabric-by-attending-user-groups-and-conferences/. The author is Chris WebbIf you’re writing your own M code in Power Query in Power BI or Excel you may run into the following error: Expression.Error: Evaluation resulted in a stack overflow and cannot continue. This post first appeared at https://blog.crossjoin.co.uk/2024/01/28/understanding-the-evaluation-resulted-in-a-stack-overflow-error-in-power-query-in-excel-and-power-bi/. The author is Chris WebbRead More
This post first appeared at https://blog.crossjoin.co.uk/2024/01/28/understanding-the-evaluation-resulted-in-a-stack-overflow-error-in-power-query-in-excel-and-power-bi/. The author is Chris WebbNew capabilities for Power BI Report Server in the January 2024 release. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-january-2024-feature-summary/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-january-2024-feature-summary/. The author isThe Microsoft Fabric free license represents a significant offering regarding data management and analysis, providing users with key functionalities of Microsoft Fabric at no cost. This post aims to provide clear, actionable information for decision-makers and data professionals considering Microsoft Fabric data analytics. Here, you’ll find everything you need to know about leveraging this platform […]
This post first appeared at https://p3adaptive.com/what-is-the-microsoft-fabric-free-license/. The author is MarketingMicrosoft has once again made headlines with the November 2023 introduction of Microsoft Fabric, an innovative platform designed to streamline and enhance data analytics. Microsoft Fabric Data analytics stands as a groundbreaking development that marks a significant milestone in data management and analysis, offering a plethora of features that cater to the needs of businesses […]
This post first appeared at https://p3adaptive.com/what-is-new-in-microsoft-fabric/. The author is MarketingBusinesses seeking to make informed data decisions must appreciate the distinctions between the various cloud computing and data analytics platforms available. When it comes to data science and data engineering, Databricks and Microsoft Fabric are two such platforms that have drawn a lot of interest. This post seeks to dispel popular misconceptions andf answer questions […]
This post first appeared at https://p3adaptive.com/what-is-the-difference-between-microsoft-fabric-and-databricks/. The author is MarketingBoth Snowflake and Microsoft Fabric are widely used platforms in the data and analytics market. This comprehensive article aims to dissect their offerings, providing a thorough comparison for a well-informed choice about Microsoft Fabric data analytics and Snowflake. Is Microsoft Fabric a Competitor to Snowflake? Microsoft Fabric is indeed a strong contender in the cloud […]
This post first appeared at https://p3adaptive.com/microsoft-fabric-vs-snowflake/. The author is MarketingChoosing the right Power BI implementation partner is a pivotal decision that can shape your business’s ability to effectively utilize data and create data visualization. This choice goes beyond just an IT solution; it’s a strategic move directly influencing your organization’s path. We at P3 Adaptive, an experienced Power BI consulting service, will guide you […]
This post first appeared at https://p3adaptive.com/how-to-choose-a-power-bi-implementation-partner/. The author is MarketingKnowledge, the lifeblood of any thriving company, is derived from data. As your business grows, so do your data demands. Microsoft Power BI, praised for its robust features and adaptability, is becoming a favored tool for Business Intelligence solutions. It grants access to data discovery, visualization, and predictive analytics once your data is organized. Implementing […]
This post first appeared at https://p3adaptive.com/power-bi-implementation-guide/. The author is MarketingOne of the most important properties you can set in a Power BI DirectQuery semantic model is the “Maximum connections per data source” property, which controls the number of connections that can be used to run queries against a data source. The good news is that the maximum value that you can set this property […]
This post first appeared at https://blog.crossjoin.co.uk/2024/01/21/new-limits-for-the-maximum-connections-per-data-source-property-in-power-bi-directquery-mode/. The author is Chris Webb