Microsoft Power BI

The calculate function in DAX is one of the most widely used DAX functions. It can both be very useful on its own and also be used as a container for far more complex calculations because it can modify the…

Choosing the proper business intelligence and data analytics tool is crucial to making timely and informed decisions with business data. A good business intelligence tool must offer a combination of power, ease of use, affordability and the ability to work…

This article explains what a Power BI hierarchy slicer visual is and how you can use it to filter information on various report types.  The article also describes some basic formatting options for the Power BI Hierarchy Slicer.  We cover…

The Replace function in DAX is a Power BI text function that you use to replace part of a text string with a different text string. It is relatively straightforward to use and appropriate for DAX beginners to be using.…

Waiting for Power BI if it is running slowly can be incredibly frustrating.  The bad news is that if your Power BI report is slow on the Power BI desktop, it will be even slower when you publish it on…

Templates are critical to increasing your work speed as you become a more advanced Power BI user. This article walks you through what they are and how to use them in detail with the help of an example. Templates are…

Microsoft recently (16th November 2021) announced that they have beta released a Google sheets connector for Power BI and Power Query.  This means that you can now connect to and import your business data from Google Sheets into Power BI…

Power BI supports a variety of data sources such as Blank Queries, Flat Files, SQL Server Database, OData Feed, Azure Cloud Platform etc. The number of import features you have will depend on the version of Power BI that you…

This article looks at the main differences between the Microsoft SSRS (SQL Server Reporting Services) and the Microsoft Power BI (Microsoft Power Business Intelligence).  We compare the two Microsoft business intelligence tools against a number of criteria and then look…

In this article, we will walk step-by-step through how to use Power BI merge queries, and Power BI append queries to combine data or for data preparation. You will also learn to use fuzzy matching features when merging queries in…

By the end of this introduction to DAX article, you will have a good all-round understanding of Power BI’s Data Analysis Expressions (DAX) language. DAX is the language behind Power BI, meaning all the potential in Power BI comes from…

Power BI is a data analysis and visualisation tool developed by Microsoft. Currently, it is one of the most sought-after skills for business intelligence analysts in particular and data scientists in general. This article covers some of the most common…