Data transformation (computing): Difference between revisions

Revision as of 20:36, 16 February 2023

Revision as of 20:42, 16 February 2023

Line 69:

There are a number of companies which provide interactive data transformation tools, like for example the start-ups Trifacta, Alteryx and Paxata. They are aiming to efficiently analyze, map and transform large volumes of data while at the same time abstracting away some of the technical complexity and processes which take place under the hood.

Interactive data transformation solutions provide an integrated visual interface that combines the previously disparate steps of data analysis, data mapping and code generation/execution and data inspection.<ref name="The Value of Data Transformation"/> InteractiveThat is, if changes are made at one step (like for example renaming), the software automatically updates the preceding or following steps accordingly. Interfaces for interactive data transformation interfaces incorporate visualizationvisualizations to show the user patterns and anomalies in the data so they can identify erroneous or outlying values.<ref name="digital.lib.washington.edu"/>

Once they've finished transforming the data, the system can generate executable code/logic, which can be executed or applied to subsequent similar data sets.