Ultimate Guide to Highlighting Duplicate Values in Excel

When working with large datasets, you often encounter issue where you data isn’t pristine and needs cleaning up before you […]

Using The Group By Feature In Power BI

In this article, you will see how to use the Group By feature to group data in Power BI.  The […]

A Complete Guide To SharePoint Lists

Microsoft added SharePoint Lists to the 2016 version of Microsoft SharePoint.  They are designed for tracking and managing data and […]

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 […]

Step-By-Step Guide to Remove Blank Rows or Cells in Excel

Occasionally you may find that it’s necessary to clean up your data and part of that cleaning up, may involve […]

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 […]

Introduction to Power BI Date Slicers

This article looks at using a Power BI Date slicer on different types of Power BI visualisation. We will also […]

Introduction to Slicers in Power BI

In this article, we will look at what a Power BI slicer is and some of its use cases with […]

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 […]