

Data Storyteller uses datasets to build Dashboards, time-to-time use data prep tools to clean data, a more visual person not advanced in JSON & SQL.
Data Architect and Data Shepherd are strategic roles, robust with data cleansing methods, most of the time spend building data flows. They are advanced in using JSON and SQL, ML, and data models for cleansing data.



Users were presented with many irrelevant screens, starting points, and flow dead-ends.

A single Data Prep tool replaces three existing tools.


UX deliverables timeline

UX deliverables based on a release schedule timeline

While preparing data, users need to visualize and keep track of how data transforms at every step. Customers would prefer to have a real-time data preview, a visual schematic representation of how data flows, and a robust cleansing transformation to address vital power users' needs.


Brainstorming ideas on post-it notes in Miro.com

Themes that emerged as a result of the design studio

Example of JTBDs

List of user flows


An example of one of the digital concepts at an early stage
Interactive Prototype
How does the graph behave? What is the logic of node placement? How does the user interact with panels and nodes? How does the user prep the data? And etc.

• Clarity on a clear visual graph layout, shapes of nodes and an overview of various transformations.
• The ability to add transformations anywhere in the flow, reorder steps and rearrange nodes on canvas. The ability to move steps around quickly.
• Creating multiple outputs as different data types were very well received.
• Seeing live data preview and real-time error troubleshooting considered by customers as a tremendous improvement.
• Consider providing onboarding and lots of in-product help, videos, etc.
• Provide intelligence capabilities in combining & scheduling data.
• Provide users with the ability to specify a dependency on flows and the ability to change output destination and the kind of data push.



Live Data Previews
• Nodes can not be placed on top of each other;
• The canvas has an infinite grid, and data flows only from left to right, from top to bottom;
• Node types defer by different shapes and colors;
• Multi-selecting nodes for bulk interactions;
• Accessibility and keyboard navigation.


Solving for complex flows
• We’ve consolidated linear, simple transformations into a single node;
• Improved search capabilities;
• Differentiated nodes by colors and shape;
• Improved nodes naming and added annotation capabilities;
