Business Analytics, Tips and Timesavers Blog

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

Power BI Filters Explained: Visual, Page & Report-Level

Power BI filters control what your audience sees, and understanding the three filter levels - Visual, Page, and Report - makes your reports clearer and more intentional. Visual‑level filters shape a single chart, Page‑level filters keep an entire page consistent, and Report‑level filters apply global rules across every page. Once you grasp how each scope works, you can build focused, beginner‑friendly dashboards without repeating work or confusing your viewers.

8 January 2026

-

Introduction to Power BI Concepts

Power BI transforms raw data into actionable intelligence through three core pillars: data sources, data modelling, and dashboards. From connecting to hundreds of systems, shaping data with relationships and measures, to delivering insights via reports and mobile apps — mastering these concepts is the key to unlocking Power BI’s full potential.

25 November 2025

-

Introducing Our New Power BI Glossary

Power BI can feel overwhelming when every term, visual, and formula seems wrapped in jargon. The Power BI Glossary changes that. Built for clarity and fast lookup, it offers plain‑English definitions, beginner‑friendly examples, and a visual learning system that helps analysts, creators, and learners decode DAX, modelling, and reporting with confidence. It’s a growing, community‑shaped resource designed to make Power BI feel intuitive-one clear definition at a time

10 November 2025

-

How to Disable Auto Column Width in Power BI

Learn how to disable auto column width in Power BI tables and matrices to prevent layout shifts, protect branded visuals, and keep your dashboards client-ready.

29 October 2025

-

A Special Touch from Kiveton Park FC

A heartfelt gesture from Kiveton Park FC brings community spirit and personal connection to life - proof that small moments can leave a lasting impact.

20 October 2025

-

Enhance Your Xero P&L in Power BI

Take your Xero Profit & Loss dashboard to the next level in Power BI with layout fixes, branded visuals, and smart formatting tips for client-ready reporting.

13 October 2025

-

Smarter Navigation, Better Insights – Our Blog Just Got an Upgrade!

Discover what’s new on the Select Distinct blog from smarter navigation to clearer categories - all designed to help you find insights faster and explore analytics with ease.

7 October 2025

-

How To: Create a P&L from Xero in Power BI

Build a clean, branded Profit & Loss dashboard in Power BI using Xero data - ideal for consultants and small businesses seeking visual clarity and actionable insights.

29 September 2025

-

Proud to Support Kiveton Park FC U18 Girls

Celebrating our support for Kiveton Park FC’s U18 Girls team - a proud moment of community connection and grassroots impact that reflects our values beyond analytics.

22 September 2025

-

Using QUOTIENT and MOD in Power BI

Explore how to use QUOTIENT and MOD in Power BI to simplify calculations, clean up visuals, and unlock smarter logic for dashboards and audit workflows.

15 September 2025

-

Power BI Licensing: The Ultimate Guide

Confused by Power BI licensing? This guide breaks down the key options - Free, Pro, Premium, and Fabric - so you can choose the right fit for your team and budget.

25 October 2024

-

Top Big Data Challenges and How to Solve Them

Explore the top challenges in big data analytics—from data quality and integration to scalability and governance. This guide breaks down the issues data teams face and offers practical strategies to overcome them using modern tools and platforms.