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
Top Articles
-
-
5 real life applications of Data Mining and Business Intelligence
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
-
Database Schema: Types, Examples, and Benefits
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
-
Connecting Matillion ETL to Snowflake: A Guide
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
-
Data Vault vs Star Schema vs Third Normal Form: Which Data Model to Use?
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
-
Uses and Benefits of Machine Learning for Your Enterprise
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
-
5 Best Practices for managing Azure DevOps CI/CD Pipelines with Matillion ETL
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 Data Consolidation?
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
-
What is Azure Synapse Analytics?
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
-
What is Azure Data Lake?
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
-
Where to store your data: Amazon Redshift vs. S3
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
-
Shared Jobs in Matillion ETL: How to Create Variables (Part 1 of 2)
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
-
The Importance of ETL Tools in Data Warehousing
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
-
Data Lake vs Data Warehouse - 5 Key Differences Between Both
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
-
Dashboard examples: The good, the bad and the ugly
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
-
What to do with a Late Arriving Dimension or Early Arriving Facts
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
-
Error Handling in Matillion ETL – Best Practices
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
-
Using Iterator Components in Matillion ETL to Load All Tables from an RDS Database
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
-
10 Business Intelligence Features that You Should Prioritize
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
