Why is Datamartist better than Excel for some types of data transformation?
Unlike Excel, Datamartist allows for easy use of multi-million row data sets, and provides a user interface that makes it clear visually how the data flows, and what data transformations are performed where. While Excel is spreadsheet based, Datamartist manages tables and definitions more like a database. But without many of the constraints of a data base, and without the need to use programming languages like SQL. Finally, Datamartist has been designed to guide the creation of data models that facilitate cleaner data transformation, and the production of a more useful output data set. It inherently manages concepts like duplicate keys, duplicate records, multiple hiearchies, and complex segmentation rule sets. Because it does this in a graphical user interface, it avoids the need for complex nested spreadsheet functions, visual basic programming or complicated lookup calculations.