Best Practices for Using Explicit Measures in Power BI

Part 2: Best Practices for Using Explicit Measures in Power BI (Part 2 of a 2 part post about modelling in Power BI) In our previous post we explained the differences between implicit and explicit measuresUnderstanding Implicit and Explicit Measures in Power BI This post builds on that and explains some best practices for using […]

Implicit and Explicit Measures in Power BI

(Part 1 of a 2 part post about modelling in Power BI) In this post we will explain the key differences between implicit and explicit measures in Power BI We will also explain the “Discourage Implicit Measures” feature and its significance Understanding Implicit and Explicit Measures Implicit Measures What are Implicit measures in Power BI? […]

How to Sync Slicers in Power BI: Step-by-Step Guide

This post explains how to sync slicers in Power BI, without any complex code Slicers are an excellent way to give your users the ability to explore data, allowing users to use the slicers to filter the data down to particular information of interest. But, if your data has different data sets with common values […]

Split a column in BigQuery

This quick guide shows you how to split a column in BigQuery When working with text data, quite often you need to split a column or trim excess characters to clean the data This quick guide shows you how to do it. Using URL data from Google Analytics GA4 to create separate columns for the […]

Import XML into Excel

Importing XML data into Excel allows you to have a readily available data source that can be refreshed on Demand Once that data loaded into Excel you can use Excels features to explore, filter, sort or augment that data from other sources What is an XML file? An XML file is a plain text file […]

Azure Data Factory Best Practices and Tips

Best Practive Data integration to drive operations and make informed decisions. Microsoft Azure Data Factory (ADF) is a cloud-based data integration service. It is available as part of Azure and also as part of the Microsoft Fabric Offering. It offers a robust and scalable solution for managing, orchestrating, and automating data pipelines. This blog highlgihts […]

SQL Server Date Handling

Working with dates in sql is one of the most challenging parts of data manipulation. In this blog we aim to describe some of the complexities of date handling in SQL Server. Data Types Prior to Microsoft SQL Server 2008 the only data types available were datetime or the smalldatetime. With the launch of SQL […]

Navigating Power BI Data Alerts

Introduction Whilst reporting is a key component of any business, how do you respond to key changes. How do you ensure actions are generated when the data changes beyond the limits you set. As part of our Business Support Expert Services this can be a really efficient way to set up reports to monitor values […]

How to Create Drop Down Lists in Excel

The Drop down list in Excel is a useful feature that allow users to select an item from a list of options. They are commonly used in data entry to control what data is entered. And to ensure that users do not enter incorrect data, preventing some errors This post shows you how to create […]

Top SQL Tips for 2023

Top SQL Tips and Timesavers for 2023 Highlighting our top 5 SQL tips for 2023 based on popularity   1. Our most popular SQL tip this year How to calculate running totals in SQL server why you would use them, and provides a breakdown of the syntax The article gives a step by step example […]