Is your Management Information always available

Is your Management Information always available when you need it? Do you have access to the information you need at the right time? Do you have to wait and miss opportunities? Improving the availability of your management information helps your decision makers by having the information they need at their fingertips, enabling them to make […]

Show Values in Rows in Power BI

This quick guide shows you how to show values in rows in the matrix visual in Power BI You will learn how to switch values on show in rows in a matrix, like this example The Matrix visual in Power BI is similar to a Pivot Table in Excel, but not quite as intuitive, which […]

Tips for a Data Analytics Leader

10 Tips and Stories for New Data Analytics Leader: Practical tips and real stories which analytics leaders would face in this commercial world What are you likely to face as a new Analytics Leader? What should you consider before joining a company as their Head of Analytics? What are the expectations from your key stakeholders? […]

Is your Management Reporting Understandable

Is your management information simplified, organised, consistent, easy to understand? Management Reporting Understandability It doesn’t have to be complicated Are reports presented consistently, clearly and have a familiar look and feel? Do you have organisation wide reporting standards that are championed? If your whole suite of reporting is simplified and consistent it helps users to […]

LEAD and LAG Functions in SQL

A Guide to Lead and Lag Functions in SQL Introduction: An Overview of Lead & Lag Functions and Their Benefits in SQL Lead and Lag in SQL are essential functions for data analysis. These window functions allow users to compare and analyse data points between rows in a specified window. By using Lead and Lag […]

GETPIVOTDATA Function in Excel

useUsing the GETPIVOTDATA Function in Excel to add flexibility to your Data Analysis & Reporting What is GETPIVOTDATA and How Can It Help You? The GetPivotData function in Excel provides users with the ability to return specific data points from a pivot table, Think of it like a specialised lookup mechanism that can find an […]

Do you Trust your Management Information

Do you trust your management information? Is it secure? Do you believe it is well controlled? Is reconciled? Do you find it to be consistent? Your management information contains valuable competitive insights from your business. Securing who can access this rich data source is important, you wouldn’t want it getting into the wrong hands Having […]

Change the data source in Power BI

Sometimes you need to change the data source in Power BI from a static data source such as a CSV file to a SQL connection Here is an efficient way to do it to save you time and headaches This guide shows you a quick and easy way to make the change without having to […]

Selecting Reporting and Visualisation Software

Selecting Reporting and Visualisation Software Selecting the correct reporting software for a data warehouse is an important decision. It can have a significant impact on the effectiveness of your system. A data warehouse is a central repository that allows you to store and analyse large amounts of data from a variety of sources. The right […]

Running Totals in SQL Server

This blog post explains how to calculate running totals in SQL Server, why you would use them and provides a breakdown of the syntax What is a running total? A running total is a cumulative sum that takes all the values of a sequence and adds them together. It is also called a cumulative sum […]