What are the Basics of ETL Testing?
Now that more organizations are using ETL tools and processes to integrate and migrate their data, the obvious next step is learning more about ETL testing to confirm that these processes are...
Read Article
Now that more organizations are using ETL tools and processes to integrate and migrate their data, the obvious next step is learning more about ETL testing to confirm that these processes are...
Read Article
As the importance of data analytics continues to grow, companies are finding more and more applications for Data Mining and Business Intelligence. Here we take a look at 5 real life applications...
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
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
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
We’ve been hearing a lot about the Microsoft Azure cloud platform. With all of the talk about cloud and the different Azure components available, it can get confusing. So what is Azure Data
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