DOTTY is a program that allows the user to input data, manipulate it, and get results that are fully traceable. Much more than just diagramming, DOTTY allows the user to play with data. The app allows standard data flow features such as filter, aggregate, join and transform. It also allows full inspection of the data processing, record by record. Once the user is happy with their data flow, they can export the results as SQL, CSV, JSON or saved as a complete DOTTY file. All of this happens in the browser – no bulky program to download or connection errors to debug – just play with your data and watch it move.
Examples
Simple data flow
Complex data flow
Demo video