Create datasets

A dataset acts as a curated view of your data from a database. It connects the complex structure of a database table or a custom SQL query in a user-friendly interface required for building visualizations.

Datasets can be created from or database tables.

Prerequisites

How to proceed

Create a dataset from an SQL query

To create a dataset from an SQL query:

  1. Follow the steps from Query and explore data in SQL Lab.

  2. Instead of clicking the Save button (as described in the last step), expand its dropdown and select Save dataset.

Create a dataset from a database table

  1. Click Datasets in the upper ribbon on the home page.

  2. Click the Add new datasets button add dataset.

  3. Select a schema type and a table, on which you want to base your dataset.+

  4. Click the Create and explore dataset button.
    You are now promted to create a new chart from your dataset.

  5. Explore the different categories and types of charts and select the one that is most appropriate to your specific needs.
    After you have selected the chart type, you are directed to fill in the data values for your query, based on the chart type you selected in the previous step. All highlighted fields are mandatory. When you have filled all of them, your chart is ready to be generated.

  6. Click the Create chart button. You new chart is displayed up right and the values you based it on are listed in the Results section under it.

  7. Click the Save button up right.

Create dataset from table

Now that you know how to create your datasets, you can proceed with learning how to build charts.