The Basics of ETL Testing
Imagine spending lots of time and resources to move your data to a new system, only to realize that the data is incomplete or inaccurate. Not only would this result in costly mistakes, but it
Read Article
Imagine spending lots of time and resources to move your data to a new system, only to realize that the data is incomplete or inaccurate. Not only would this result in costly mistakes, but it
Read Article
Azure DevOps is a highly flexible software development and deployment toolchain. It integrates closely with many other related Azure services, and its automation features are customizable to an...
Read Article
What is Azure Data Lake Storage & Analytics? Take a deep dive into data lakes, their components, challenges, best practices, and real-world use cases.
Read Article
Learn how to use data mining for business intelligence applications. Here are 5 data mining examples in real life, including retail, telecom, and more.
Read Article
Having the right schema is a key factor supporting modern data analytics. Database schemas can be confusing, but this article will help you design the right schema for your data stores –...
Read Article
This guide is a walk-through of how to connect Matillion ETL to a Snowflake cloud data platform account. In Matillion ETL, the metadata for connecting to Snowflake is held in an artifact known
Read Article
In the journey towards gaining value from data, it’s common to convert between formats. As discussed in this article, often it involves using Matillion to move data along the path from...
Read Article
What is machine learning used for? Machine learning has been around for decades, but in the era of Big Data, this type of artificial intelligence is in greater demand than ever before. Why? Simply...
Read Article
Data consolidation is a relatively new discipline that has emerged because our data is becoming more spread out and difficult to manage. To learn more about how data consolidation can help your...
Read Article
We are excited to be part of today’s announcement of the General Availability of Microsoft Azure Synapse Analytics. Azure Synapse Analytics is a limitless analytics service with unmatched time...
Read Article
If you are employing a data lake using Amazon Simple Storage Solution (S3) and Spectrum alongside your Amazon Redshift data warehouse, you may not know where is best to store your data. This is...
Read Article
This two-part blog will walk you through setting up and creating a Shared Job in Matillion ETL using variables. In Part 1, we will walk you through the setup process for Job and Grid
Read Article
Why Do We Need ETL Tools? The importance of ETL in an organization is in direct proportion to how much the organization relies on data warehousing. ETL tools collect, read, and migrate large
Read Article
A data lake vs data warehouse comparison is not a competitive one because a data lake is not a direct replacement for a data warehouse; they are supplemental technologies that serve different use...
Read Article
Data visualisation and dashboards in particular can form a crucial component of your analytics strategy. However, it can be easy to get them wrong. To gain a better understanding of what makes a...
Read Article
This blog article describes a commonly-encountered practical problem when you are creating a dimensional model. With a star schema, it’s a fixed rule of dimensional modeling that every foreign key...
Read Article
This is the first blog in a three-part series on Matillion ETL error handling options. This blog describes some best practice approaches to making your job more resilient to errors. The second...
Read Article
Matillion uses the Extract-Load-Transform (ELT) approach to delivering quick results for a wide range of data processing purposes: everything from customer behaviour analytics, financial analysis,...
Read Article
The market for business intelligence is becoming increasingly competitive and as a result there are a multitude of vendors offering a vast array of business intelligence features. We take a look...
Read Article