Filtering and Transforming Data

Overview

One of the key skills utilized when building analytics is the ability to filter or otherwise transform data. Data that represents a dataset (that is, a plurality of data points), is usually contained within an Javasript array. The davinci platform provides an additional data type, $list which provides array like functionality and inlcudes additional methods for querying and transforming the underlying data.

Topics

• Iterating a Dataset
• Filtering
• Transforming
• Grouping
• Joining

Transformation Apps

In addition to basic scripting facilities, the davinci platform provides a number of different apps and graphical tools for transforming data.

• View Data App
• Indicators App - adds computed columns to a tabular dataset. Mostly used with time series.
• Edit Table - lets users edit records in an array of data