alteryx-vs-matillion

Alteryx Platforma is a business intelligence and data visualization software, while Matillion is an Extraction, Transformation, and Loading (ETL) tool. Matillion is used for centralizing, consolidating, and formatting data for analysis and reporting. Alteryx is used for more intensive analytics and reporting, but it also emphasizes its ETL capabilities relative to other BI tools. Given Alteryx’s broad feature set, it is more heavily used by enterprises, while Matillion has users across company sizes. 

Features

Both Alteryx and Matillion have distinct strengths tailored to certain needs.

Alteryx stands out for its full-service analytics capabilities, from data extraction to visualization and modeling. Users point to a robust set of predictive analytics models for various use cases. For repeated analyses or processes, Alteryx also provides automation and macros functionality to streamline data analytics. 

Matillion specializes in data centralization and preparation. In particular, it excels at extracting data from an extremely wide range of platforms, especially AWS environments and cloud-based data warehouses. It also features a very low learning curve, with greater accessibility via a drag-and-drop interface. 

Limitations

While Alteryx and Matillion both have strong features, they also have some limitations.

Alteryx has struggled with more polished visualizations. Users have described limited data visualization functionality and customization. Alteryx also has limited training, which can contribute to a more difficult learning curve. 

In contrast, Matillion’s ETL specialization trades off with any data analysis capabilities. Matillion does not provide post-data loading functionalities like analytics or reporting. Users have also struggled with a lack of documentation for updating the tool or tracking existing projects. 

Pricing

Alteryx has two offerings, Designer and Server. Designer, the core data analytics offering, is priced at $5,195/user/year for the base license, $11,700/user/year for added location data, and $33,800/user/year for additional demographic, spatial, and segmentation data. Alteryx provides a 14 day free trial for Designer. Alteryx Server’s base price is $78,975/year for greater scalability and collaboration, plus an additional $39,000/year for additional data management and discovery functionality. 

Matillion provides four packages for its ETL capabilities, priced per hour of usage. The “Medium” package, at $1.27/hr, provides 2 users and 6 environments. The “Large” package, at $2.74/hr, supports 5 concurrent users and 15 environments and clustering. The “XLarge” package, at $5.48/hr, supports 12 concurrent users and 35 environments. Enterprise package pricing is available by quote from the vendor.