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 […]
Is your Management Information Relevant
Is your Management Information Relevant to you? Do you find yourself looking at reports which don’t help you make decisions? Is the really valuable information hidden in the depths of the reports? Changes over time As the competitive environment the business operates in changes over time, the focus of your management reporting needs to change […]
