News & Tips
The Calculate Function In DAX
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…
Power BI Vs Tableau: A Detailed Analysis
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…
Hierarchy Slicers In Power BI
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…
REPLACE Function in Dax
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.…
Speeding Up Power BI
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…
All About Power BI Templates including 5 Great Places To Download Them
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…
Connecting Power BI to Google Sheets – The New Connector
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
AI is rapidly changing the way we interact with technology and the world around us. In the simplest of words, AI is how machines perform tasks that typically require human intelligence. Like interpreting and communicating in natural language, recognizing images,…
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. If you would like to learn more about Microsoft Excel, then please…
Power BI: Connecting Power BI to SQL Server
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…
Comparing 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…