Anna's best insights come from time series data. This article will help you understand the features of time series data, and identify if your dataset is good for Anna. If you're looking to quickly validate if your dataset is Anna ready, please refer to our checklist here.

Data types

Date: Time series data typically has one or more date fields. Anna needs at least one date field, to assist in the identification of patterns, trends and seasonality over time. Anna’s insights depend on the period your data spans, for example:

  • Anomaly detection: 7 months of data or more
  • Seasonality analysis: 24 months of data or more 

The preferred date format is YYYY-MM-DD. 

Segment: In order to upload your data to Anna, the data should have at least one segment, but the more the better! Segments are the qualitative fields of your data, for example, office locations, departments, product types, job ranks and more. 

Make sure your segments use user friendly language and natural language terms.

Measure: Your data should have at least one measure. A measure is a number or value that can be summed or averaged. Examples of measures include total value of sales, quantity ordered, spend and more.

If your measures have any special characters ($, %, #, &, etc.), thousands separators or currency indicators (e.g. AUD, USD, NZD etc.), these should be removed from your data before uploading. If you would still like to see the currency indicator in Anna, create a new column for these values.

Unique value: Unique values are distinct, countable identifiers, like customer, product and employee IDs. If your data has a unique value, Anna will automatically perform calculations based on this value, such as average sales by customer ID.

When you upload data, Anna will automatically detect the format of each of your columns. You have the option to change this selection during the upload process. See the Related articles for more information on uploading your data.

Related articles
Data upload checklist
How do I upload data?
How do I connect to a database?
How do I connect to a .csv file?

If you have any questions, please contact us at support@hyperanna.com.

Did this answer your question?