Services

Technologies

Industries

About Us

Our Work - Case Studies

Business Analytics, Tips and Timesavers Blog

New Select Distinct Business Analytics Blog title screen with new categories

In our Business Analytics Blog, we talk about a wide range of topics.

From Business Analytics, to Tips and Timesavers for Microsoft Power BI. And tips and time-savers for SQL, including SQL Server Management Studio and Google Big Query. We also share practical tips for Excel.

As well as sharing our broader knowledge of Management Information, leadership, team building and mentoring

Tips and Timesavers

 

Our tips and time-savers are designed to share those little tricks and techniques that you wish you had known earlier.

Whether you are looking to learn about then benefits of data warehousing and what it can bring to your business. Or you are just looking for practical timesavers as an analyst, there is something for everybody

We hope you enjoy this blog, and if you have any questions or comments, please feel free to reach out!


Topic Filters

You can filter using these tags to find the content you like, newest posts will be shown first

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...

16 April 2024

-

The Medallion Architecture Unveiled

Medallion architecture, a term increasingly recognized within the realms of data management and software development. It presents a compelling framework...

21 March 2024

-

A Guide to Extracting Data from Joblogic

Following on from the blog last week,Joblogic Integrations with Power BI - Select Distinct Limited I thought I'd write a...

19 March 2024

-

A Guide to Extracting Data from BambooHR

Having worked with a few customers on automating the data output from their HR system, namely BambooHR. I thought I'd...

13 March 2024

-

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...

12 March 2024

-

Explaining User-Defined Types in SQL Server?

Having recently stumbled on User-Defined Types (UDTs) in SQL Server. I thought I'd write a blog to explain what user-defined...

6 March 2024

-

Azure Data Factory vs Logic Apps:

Key Differences and Cost Implications On a recent project I have been looking at whether to use Azure Logic Apps...

4 March 2024

-

Using Google Search Console Data in Power BI

Google Search Console is a very powerful tool to measure SEO performance. This post highlights how with a little effort...

1 March 2024

-

Split a column in BigQuery

This quick guide shows you how to split a column in BigQueryWhen working with text data, quite often you need...

20 February 2024

-

Import XML into Excel

Importing XML data into Excel allows you to have a readily available data source that can be refreshed on Demand...

15 February 2024

-

Choosing the Right Paginated Reporting Tool

Pixel-Perfect Precision: In the data realm, the importance of robust reporting tools cannot be overstated. Businesses rely on accurate, timely,...

15 February 2024

-

Slowly Changing Dimensions (SCDs) Described

Source systems are a treasure trove of historical information. Importing data in a data warehouse is a a key part...

12 February 2024

-