Select Distinct Logo Clear Background

Comparing Year on Year in Power BI

Comparing Year on Year in Power BI

In an earlier post we showed you how to use SAMEPERIODLASTYEAR in power BI to compare data to the prior year The major shortfall of this is that the built in function matches the day of month and month, and does not properly reflect the day of the week If we show these with the […]

How to Sync Slicers in Power BI

Sync Slicers in Power BI

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

Using Google Search Console Data in Power BI

Working with GSC data in Power BI

Google Search Console is a very powerful tool to measure SEO performance. This post highlights how with a little effort you can use Google Search Console Data in Power BI to create much more compelling dashboards It tracks a vast amount of really insightful data, but the reporting is limited The example below is the […]

Split a column in BigQuery

How to 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 in Excel

Create a refreshable site map in 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 […]

How to Create Drop Down Lists in Excel

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 Creating a drop down list in Excel […]

Top SQL Tips for 2023

Top 5 SQL Tips and Timesavers 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 […]

Top Power BI Tips for 2023

Top 5 power bi tips 2023

Here are our top Power BI tips for 2023 Highlighting our top 5 Power BI tips for 2023 based on popularity Our most popular Power BI tip this year   Show values in Rows in Power BI How to show values in rows in the matrix visual in Power BI. a step-by-step guide to change […]

Calculated Columns and Measures in Power BI

Calculated Columns and Measures in Power BI

Introduction to Calculated Columns and Measures in Power BI A guide to understanding the differences between calculated columns and measures in DAX for Power BI What is a calculated column? A calculated column is a static value added to a table, calculated row by row when you load the data. What is a measure? A […]

What is Business Analytics

What is business analytics

What is Business Analytics? Introduction: What is Business Analytics and why use it? Business analytics refers to the skills, technologies, and practices used to examine the data and performance of an organisation. It aims to generate insights that can help improve business performance and decision-making. Business analytics can help businesses understand their current situation. Predict […]