There are a large number of tools that perform data transformation on the market. Some are legacy tools, and some are more modern. Even though legacy tools have had multiple facelifts over the years, these products still embrace old-style data transformation, as seen here with Informatica and Talend . Even some cloud/SaaS-based tools that support the ELT process still have old-style data transformation interfaces, as seen here with Matillion .
A good data transformation as a service tool embraces the modern fact that there are multiple personas involves in the analytics engineering process, including data engineers, analytics engineers (more technical analysts), data analysts, and data scientists. Each of these personas often has:
- Different skill sets ranging from being highly technical to less technical,
- Different knowledge and understanding of how data is used,
- Different focal points on their role and where they can best use their time.
To this end, a SaaS Data Transformation tool will provide a much more modern tool that allows each persona to get involves in the data transformation process, best use their skills and ensure they spend the most time doing what they do best. For example, data analysts can spend more time on analysis and less on data transformation through an easy-to-use no-code or low-code data transformation interface.
A highly modern SaaS Data Transformation platform should support three different interfaces to support multiple personas:
- No-code – for non-technical data and business analysts
- Low-code – for slightly more data-savvy data analysts or for analytics engineers that want greater productivity than coding
- Code – for data and analytics engineers that want to use SQL for the control and optimization that comes with it.