Microsoft Power BI
Our Power BI articles below clearly and simply how to use specific aspects of Microsoft Power BI that we also cover in our Power BI training courses.
AllAdobe InDesignAdobe PhotoshopManagementMicrosoft ExcelMicrosoft Power AutomateMicrosoft Power BIMicrosoft PowerPointMicrosoft ProjectMicrosoft SharePointMicrosoft WordSQLTime Management
Power BI’s Scatter Charts – Create Amazing Visuals
A scatter chart is a diagram that displays the relation between two numeric variables for a set of values. Typically, a scatter chart plots data points for a set of values for two variables using Cartesian coordinates. They allow you…
COMPLETE GUIDE Data Models [Power BI]
A Power BI Data model is a collection of entities (in the form of tables) connected via different types of relationships. Data Models looks very similar to an entity relationship (ER) diagram used in database design. We will cover the…
Export From Power BI to PowerPoint Safely! [Quick Guide]
One of Power BI’s great strengths is how easy it makes sharing dashboards and reports but there are occasions when you don’t want to. This article explains how to export Power BI to PowerPoint using Power BI Service. You will…
Step-By-Step: Creating A Power BI Dashboard
A dashboard is designed to visually display a combination of data visuals It should give someone a clear understanding of the underlying data very quickly. It is a great way for you to visualise your information. A well-designed dashboard…
Summarise Data With The Group By Feature [3 Minutes Or Less!]
The Group By feature in Power BI summarises data based on one or more aggregate functions. You can use the Group By feature to find the average, count, min, max, or any other aggregate value for one column, based on…
How Do Date Formats Work In Power BI?
In this article, you will see how the Power BI Date format works and how you can format dates in the Power BI reports view as well as in the Power Query editor. You will also use the different methods…
The Calculate Function [DAX’s Functions!]
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…
Filter Your Information With Hierarchy Slicers [Power BI Guide]
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 [DAX’s Functions!]
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.…
Speed Up Your Power BI Today!
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…
Brand New Connector! Connect Power BI & Google Sheets
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…
Linking Power BI & SQL Server [Ultimate Guide]
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…