The Data Lens Workflow
The following list describes a typical workflow for creating visualizations with Data Lens. Follow the links to the detailed topics for more in-depth descriptions of each step.
- Prepare your data: The data you use in Data Lens visualizations must be in CSV format and follow some rules.
See also: Data Format Guidelines
- Upload your data: You use the Data Lens REST API to upload your data to your Data Lens account. First you create an empty dataset, and then you populate it by uploading your CSV files. You can subsequently append additional data to the dataset or delete it.
See also: Managing your Data
- Define a query on the dataset: To consume data in your visualizations, you use the Data Lens REST API query language to define how to call and process your datasets. Data Lens queries are JSON objects that are run from within your app by calling its unique ID. (Queries are similar to 'prepared statements' in SQL.)
You can define a query to be a simple construct to load data, or it can perform complex data transformations and other processing. In addition, you can define "dynamic parameters", which allow you to modify the parameters of the query using front-end URL parameters. This creates the interaction between the end-user viewing the visualization in the browser and the data processing being triggered in the background.
You use the Data Lens REST API to save the query to your account and to publish it if you want to make the results of the query publicly available.
See also: Querying your Datasets
See also: Retrieving Data with a Query