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
Power Query allows you to merge (“join” in database terms) two tables together in a variety of different ways, including left and right anti joins. Unfortunately, as I found recently, anti joins don’t fold on SQL Server-related data sources, which can result in performance problems. Luckily there is a different way of doing anti joins […]
This post first appeared at https://blog.crossjoin.co.uk/2023/12/03/anti-joins-and-query-folding-in-power-query-in-excel-and-power-bi/. The author is Chris WebbIt’s true that you can create reports in Power BI Desktop for free. However, it’s not for sharing and consuming. If you want to share your work with others, especially end users, consider purchasing a paid license. This will give you a more robust and secure solution for data sharing and governance. But how much […]
This post first appeared at https://p3adaptive.com/how-much-does-power-bi-cost/. The author is MarketingLearning Power BI at your own pace, in the comfort of your home, might just be what suits you best right now. Sure, it can seem daunting to learn all by yourself. But don’t worry. You are never truly alone in your learning journey. As a leading Power BI consulting service, we’re here to guide […]
This post first appeared at https://p3adaptive.com/how-can-i-practice-power-bi-at-home/. The author is MarketingHave you ever had a situation where you have a slicer selection that “sticks”? You make a selection in a slicer, then make some changes somewhere else, but the first selection you made “sticks” when it is no longer valid? Take a look at this animated demo below to see […]Read More » This post […]
This post first appeared at https://exceleratorbi.com.au/slicer-values-dont-clear-after-changing-a-second-slicer/. The author is Matt AllingtonIn November 2023 release we added a new fourth view in public preview to Power BI Desktop, the DAX query view! The DAX query view gives you the ability to write, edit, and see the results of Data Analysis Expressions or DAX queries on your semantic model. Finally, you can now take advantage of the […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/deep-dive-into-dax-query-view-and-writing-dax-queries/. The author isWhen comparing Microsoft Power BI vs. Tableau pros and cons, one aspect that distinctly sets them apart is their approach to data modeling. As Power BI Consulting experts, we believe that their data modeling capabilities are worth discussing. Let’s face it: the data model is like the brain of these tools. Want to know which […]
This post first appeared at https://p3adaptive.com/2023/11/what-is-the-difference-between-tableau-and-power-bi-data-model/. The author is MarketingPower BI skills are hot right now. People want them. Companies need them. Learning it could be a game-changer for you. But how to start? Is it easy or hard? Can you learn it quickly by yourself? That’s exactly what this article is about. As a Power BI Consulting service, we’re here to support your […]
This post first appeared at https://p3adaptive.com/2023/11/power-bi-tutorial/. The author is MarketingWondering if Power BI has an online version? Well, many people are asking the same question, and it’s time to put your curiosity to rest. As a leading Power BI consulting service, we’ll give you the comprehensive explanation you need about the online version of Power BI. So, stay tuned as we’ll break down everything […]
This post first appeared at https://p3adaptive.com/2023/11/power-bi-online/. The author is MarketingA lot of DAX performance problems relate to the use of strict and eager evaluation with the IF or SWITCH functions. It’s an incredibly complex, “it depends”, black-box type of topic and naturally Marco and Alberto have a great article on it here. Rather than describe any general rules – which would be pretty much […]
This post first appeared at https://blog.crossjoin.co.uk/2023/11/26/if-switch-and-the-effect-of-dax-variables-on-strict-eager-evaluation/. The author is Chris WebbIn this article I’m going to talk about the recent change that Microsoft has made in renaming the underlying database used in Power BI from the term “dataset” to “semantic model” (or as I would call it, “semantic data model”). The Word “Semantic” Let me start by talking about the […]Read More » This post […]
This post first appeared at https://exceleratorbi.com.au/why-did-microsoft-rename-datasets-to-semantic-models/. The author is Matt AllingtonLast week it was announced that Power BI datasets have been renamed: they are now semantic models. You can read the announcement blog post here and see the change in the Fabric/Power BI UI already. The name change proved to be surprisingly uncontroversial. Of course it’s very disruptive – trust me, I know, I have […]
This post first appeared at https://blog.crossjoin.co.uk/2023/11/18/thoughts-on-power-bi-datasets-being-renamed-to-semantic-models/. The author is Chris WebbIntroducing reference labels: the new feature that will rock your new cards! Now you can add custom labels to your new cards that show amazing information and comparisons. This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-cards-reference-labels-public-preview/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-cards-reference-labels-public-preview/. The author isWe’re excited to announce the latest addition to Power BI’s new slicer experience – the button slicer! Crafted with your feedback and participation in mind, this innovative tool offers unparalleled customization and ease of use. This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-slicer-button-public-preview/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/new-slicer-button-public-preview/. The author isIntroducing the public preview of the new Explore feature, where users have a lightweight and focused experience to explore their data. Similar to exporting and building a PivotTable in Excel, now, directly within Power BI users can quickly launch Explore to begin creating a matrix/visual pair to get the answers they need without all the […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/introducing-explore-public-preview/. The author isWe are thrilled to announce the general availability of Microsoft Fabric and the public preview of Copilot in Microsoft Fabric, including the experience for Power BI. With the launch of these next-generation analytics tools, you can empower your data teams to more easily scale to meet the demand of the business. You can create a […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/empower-power-bi-users-with-microsoft-fabric-and-copilot/. The author isWelcome to the November 2023 update. We’ve got a lot of great features this month including DAX Query view, Semantic Model Scale-out, and Advanced Filtering for Paginated Reports. This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-november-2023-feature-summary/. The author is Read More
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-november-2023-feature-summary/. The author isExcel workbooks are one of the slowest data sources you can use with Power Query in Excel or Power BI. Reading small amounts of data from small workbooks is usually fast; reading large amounts of data from large workbooks can be very slow. But what about reading small amounts of data from large Excel workbooks? […]
This post first appeared at https://blog.crossjoin.co.uk/2023/11/12/excel-workbook-layout-and-the-performance-of-reading-data-with-power-query-in-power-bi/. The author is Chris WebbThe popularity of Microsoft Power BI has skyrocketed in recent years. The fact that more and more people use it can indicate its quality, reliability, and usability. Of course, affordability plays an important role. But it’s not the only reason why more and more people use Power BI. Power BI sets the standard for a […]
This post first appeared at https://p3adaptive.com/2023/11/why-is-power-bi-more-popular-than-tableau/. The author is Rob CollieThe battle between Tableau and Power BI is always a hot topic. These two giants dominate the landscape, each boasting their own strengths. But which one is best for your business needs? Is Tableau a true Power BI alternative? As a Power BI Consulting expert, we bring you the most relevant and latest information to […]
This post first appeared at https://p3adaptive.com/2023/11/tableau-vs-power-bi/. The author is Rob CollieDatasets are being renamed to semantic models in Power BI and Fabric. This will make the product clearer and more usable and reflects the immense progress that Power BI datasets have made in becoming an enterprise-grade semantic modeling technology. The semantic model name will help drive awareness of the unparalleled capabilities provided. This post first […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/datasets-renamed-to-semantic-models/. The author is