Docs
Add Data Model

Add a Data Model

When possible, you should try to modify or extend an existing data model instead of adding new data models for each new analysis. This section shows you how to quickly add data if you're getting started, you should also check out Data Models Overview and Data Modeling Best Practices

Preparing Data for Hashboard— Each Hashboard model is based on an underlying data table. For more technical advice see the best practices section on creating denormalized data tables. If your data isn't quite in the right format in your database, it's possible to specify an underlying data query that will run as you explore data.

  1. From your project homepage (opens in a new tab), click New Model.
  2. Select the data connection you'd like to use or Uploads if you want to use a file from your computer.
  3. Select either an existing table or click SQL editor to use a custom query.
  4. Click Continue to create the initial data model (all date fields and a row count measure are added by default).
  5. Edit the name of the data model at the top of the page.
  6. Add additional measures and attributes by clicking the Add measure and Add attribute icons next to the name of the field.
  7. Create SQL-based custom measures and attributes by clicking + Add custom measure or + Add custom attribute next to the Measures and Attributes headers in the right pane, respectively. See Measures or Attributes for more details.
  8. Click Save and explore to start exploring the data.