Services

Technologies

Industries

About Us

Our Work - Case Studies

Why you need a data warehouse

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 […]

How to Connect Excel to SQL Server

Connect Excel to SQL Server

Connecting Excel to SQL Server is important because it allows you to have access to up-to-date information. You can connect many spreadsheets to a single trusted data source in SQL Server. Then you can use Excel to refresh the data to be kept in sync. Excel has powerful but simple features that can help you […]

Power BI Tooltips

Power Bi Visual Tooltips

Advanced Power BI Tooltips     Power BI by default gives you basic tooltips, which present you with the values included in your visual These are limited initially to the fields and values that have been used in creating that visual Add other fields into the tooltips You can easily add other fields by dragging […]

What is a Data Warehouse

What is a data warehouse, diagram showing data sources loading into a data warehouse and fed out to reporting layer

What is a data warehouse? In simple terms, its a special type of database that is set up to help you answer your main business questions It adds value by focusing on reporting and analysis and taking reporting workload away from transactional systems     All the data you need in one place A data […]

Management Information Health Check

Man with a confused face

Introducing our Management Information Health Check As a company director, it’s important to ensure that your management information is up-to-date and reliable. Having access to accurate data at the right time can help make informed decisions for your business. Unfortunately, not all businesses have access to simplified, organized and trusted data which can hold them […]

Drag and Drop Field Names in SQL (SSMS)

Drag and Drop field names in SSMS cover

Drag and drop is a common and convenient way to move data and objects in SQL Server Management Studio (SSMS). With the object explorer, you can easily drag field names from a table.  Then drop them into a query window to quickly create a SELECT statement. How to drag and drop field names in SQL […]

Conditional Format a line chart in Power BI

Conditional Formatting a line chart in power bi cover

How to Conditional format a line chart in Power BI (This is a workaround to show you how you can conditional format a line chart in Power BI) Power BI does not at first seem to have an option to add conditional formatting to a line chart, but, there is a way to make it […]

How good is your Management Information

Management Information should be Future Ready, Available, Simplified and Trusted

How good is your Management Information? Does it really give you what you need? or is it more of a frustration? Do you find yourself struggling to trust the reports, with differences from one report to the next? Does your reporting keep up with your business? or every time you add a new channel to […]

Tables in Excel

using tables in Excel

What are the top 10 reasons to use tables in Excel? Tables in excel are a great way to begin to add data structure, improving consistency and reliability of the data What are Tables in Excel? The Excel table is a powerful feature that lets you sort, organize, and analyse a set of data. It […]

SQL Timesaver – Add comma separators

add comma separators to SQL cover image

This one-minute SQL timesaver showcases a free online comma separator tool, designed to simplify the process of adding comma separators to your SQL code. Delim.co is a Free Comma Separating Tool that separates one or more characters and text strings using delimiters such as commas (,), semicolon (;), quotes (\”, ‘), braces ({}), pipes (|), […]