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.
- From your project homepage (opens in a new tab), click
- Select the data connection you'd like to use or
Uploadsif you want to use a file from your computer.
- Select either an existing table or click
SQL Editorto use a custom query.
Build Modelto create the initial data model (all date fields and a row count measure are added by default).
- Edit the name of the data model at the top of the page.
- Add additional measures and attributes by clicking
Add attributenext to the name of the field.
- Create a SQL based custom measure by clicking
+ Add custom measure(see Measures for more details).
Save Modelthen click
Open in Exploreto start exploring the data.