News & Tips
AllAdobe IllustratorAdobe InDesignAdobe PhotoshopAutoCADGuides & TipsManagementMicrosoft AccessMicrosoft ExcelMicrosoft Power AutomateMicrosoft Power BIMicrosoft PowerPointMicrosoft ProjectMicrosoft SharePointMicrosoft WordNewsResilienceSQLTime Management
Creating Word Clouds [Power BI Visuals]
In this article, we will look at how to create a Word Cloud with Microsoft Power BI. We will see what a word cloud is, why it is useful, and how to perform various transformations on a Word Cloud. If…
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…
Use AI To Become An Excel Pro Today!
AI is changing the way we interact with technology and the world around us. New tools are popping up every day that save hours of work – even for Excel! Excel Formula Bot, ChatGPT and Ajelix are here to…
Complete Guide To Percentages in Excel!
In this article, we will demonstrate how to calculate a percentage in Microsoft Excel, Word and PowerPoint. Additionally, we will go through some other important percentage related calculations. What is a Percentage? A percentage is defined, as a part or…
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…
A Detailed Comparison Of Power BI And SSRS
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…
Finding Outliers In Excel: A Detailed Guide
Microsoft Excel is an incredibly powerful data analysis tool that empowers users to store, analyse, and visualise data to derive valuable insights out of it. With so many basic and advanced level data analysis tools, Excel provides you with almost…