How to prepare for a data warehouse migration

Data warehouses are at the heart of an organisation’s decision-making process which is why many businesses are moving away from the siloed approach of traditional data warehouses to a modern data warehouse that provides advanced capabilities to meet changing requirements.  We have looked at how to tackle data warehouse migration...

Easily analyse big data with Connected Sheets

Google recently announced the general availability of Connected Sheets which provides the power and scale of a BigQuery data warehouse in the familiar context of Sheets. Connected Sheets enables people to analyse billions of rows and petabytes of data in Sheets without requiring specialised knowledge of computer languages like...

How to optimise your BigQuery costs

Once you’re using BigQuery, you’ll be able to run blazing fast queries, get real-time insights with streaming and start using advanced and predictive analytics. But that doesn't mean there’s no room for further optimisations for your data housed in BigQuery.  Here’s a guide to help you optimise your costs and...

5 weaknesses of legacy data warehouses

Today’s businesses are solving complex business problems that are data-intensive. Unfortunately, their data platform infrastructure is holding them back. Those legacy data warehouses likely aren’t cutting it anymore. Here’s why and what you can do about it.   1. Business agility is hard to achieve with legacy tools Business agility is the...

Switching from traditional data warehouse to BigQuery

Enterprises have always been relying on traditional on-premises data warehouses to collect and store their most valuable data. These traditional data warehouses can be costly, inflexible and difficult to maintain. Enterprises need an easy, scalable way to store all that data, as well as to take advantage of advanced...