How to filter in Excel
Filters are a powerful tool in Excel that can help you quickly organize and analyze large data sets. With filters, you can easily find the information you need without having to manually search through thousands of rows of data. In this blog post, we’ll discuss how to filter in Excel so that you can take […]
Data Warehouse Integration Benefits
Integrating systems with a data warehouse can be a powerful way to get a comprehensive view of your data and make better business decisions. A data warehouse is a central repository that allows you to store and analyse large amounts of data from a variety of sources. By integrating your systems with the data warehouse, […]
Is your Management Information Accurate?
Is your Management Information accurate? Do you wonder if the reports you’re getting are accurate? Or do you find yourself questioning whether the data you’re seeing is really reflecting reality? In either case, it’s important to have a single version of the truth – and to make sure that the reports and data you’re using […]
Remove Carriage Returns in SQL Server SSMS
How to Remove Carriage Returns in SQL Server Management Studio? It is a fairly common task, a lot of people manually select and remove carriage returns and new lines, which can take time and is error prone But you can use find and replace functionality built into SSMS to make the task more efficient This step […]
How to create Pivot Tables in Excel
This quick guide shows you how to create pivot tables in Excel What is a Pivot Table? Pivot tables are an incredibly powerful tool in Microsoft Excel, providing a dynamic and intuitive way to analyse, summarize, and manipulate large amounts of data. By using a drag-and-drop interface, users can quickly and easily create summaries from […]
Which Data Warehouse is best for you?
There are always a few key factors to consider when deciding which data warehouse is the correct one We always start with those options that fit best with the technologies and skills you already have in place. Having readily available data is really valuable and helps to simplify implementation and can help build confidence within […]
How to sort dates in Power BI
Working with dates can sometimes be a little challenging, this quick guide shows you how to sort dates in Power BI Its not always obvious how to do simple things like sort months in calendar or chronological order Here we show some simple tips using a date dimension table If you want to know how […]
Is your Management Information fast enough?
Do you get your management information fast enough? Are you left waiting for answers and have to use ‘gut feel’ All too often we see frustrated directors, owners, managers and other senior leaders. Frustrated by slow, out of date business performance reporting. Is this you? read on to find out Can your team answer new […]
How to show line numbers in SQL Server Management Studio
Using Line Numbers in SQL (SSMS) Showing line numbers in SQL Server Management Studio is a simple tip that can really help users to quickly debug and find their away around large SQL scripts Why use line numbers in SQL Server? The primary benefits from enabling line numbers in SQL Server Management Studio are Finding […]
Why you need a data warehouse
This blog explains why you need a data warehouse and the advantages and disadvantages that can come with one What is a data warehouse? A data warehouse is a central repository that allows an organization to store and analyse large amounts of data from a variety of sources. It is designed to handle huge amounts […]
