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

From API to Dashboard: Create a Live Weather Report in Power BI

Build your first live data dashboard in Power BI. This guide shows you how to connect to a free weather API, shape the data, and create clean KPIs and trend visuals — no API key required.

21 January 2026

-

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

Visual, Page, and Report‑level filters each shape your Power BI story differently. This guide shows you how they work — and how to use them together to build clean, consistent, beginner‑friendly reports.

8 January 2026

-

Introduction to Power BI Concepts

Power BI is built on three core concepts: data sources, modelling, and dashboards. This guide explains how they work together — and why mastering them is the key to creating clear, reliable, insight‑driven reports.

25 November 2025

-

Introducing Our New Power BI Glossary

Meet the Power BI Glossary: a visual, beginner‑friendly reference that explains the terms you use every day — without the jargon. Fast lookup, clear examples, and practical guidance for analysts, creators, and learners.

10 November 2025

-

How to Disable Auto Column Width in Power BI

Power BI loves to resize your table columns — even when you don’t want it to. This quick guide shows you exactly how to disable Auto Column Width, why it keeps switching back on, and how to keep your layouts stable across pages and refreshes.

29 October 2025

-

A Special Touch from Kiveton Park FC

Some gestures stay with you long after the moment passes. This short story from Kiveton Park FC captures the kind of kindness that reminds you why grassroots football matters — the people, the pride, and the unexpected ways a club can make someone’s day feel a little brighter.

20 October 2025

-

Enhance Your Xero P&L in Power BI

If your Xero P&L feels too flat for real analysis, Power BI can transform it. This guide shows you how to reshape your data, add meaningful structure, and build a clearer, more insightful P&L — without changing anything in Xero. A simple upgrade with a big impact.

13 October 2025

-

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

Our blog just became easier to explore. With cleaner navigation, clearer categories, and a more intuitive layout, you can now find Power BI guides, accounting workflows, and practical tutorials faster. A small upgrade that makes a noticeable difference to how you learn.

7 October 2025

-

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

Building a P&L from Xero in Power BI is easier than it looks. This guide walks you through connecting your data, shaping it into a clean structure, and creating a flexible P&L layout you can customise for any audience. A simple workflow with powerful results.

29 September 2025

-

Proud to Support Kiveton Park FC U18 Girls

Grassroots football thrives on passion, commitment, and community. We’re proud to support the U18 Girls at Kiveton Park FC as they continue to grow, compete, and inspire. This post shares why backing local sport matters — and how small contributions can make a real difference

22 September 2025

-

Using QUOTIENT and MOD in Power BI

QUOTIENT and MOD are two simple DAX functions that unlock powerful logic in Power BI. This guide shows you how they work, when to use them, and how they can simplify calculations that look complex at first glance. A great introduction to smarter, more modular DAX.

15 September 2025

-

Power BI Licensing: The Ultimate Guide

Power BI licensing can feel confusing when you’re trying to choose between Free, Pro, and Premium. This guide breaks down the differences in plain English, with simple scenarios that show exactly what you need — whether you’re sharing reports, building dashboards, or scaling across a team.