This documentation page assumes that you already have a SeekTable account. You can create free account by signing up.

Search driven analytics with natural language queries

Search driven analytics is a new way how you can make ad-hoc queries and get answers simply by entering search query. This works like Google search but for your own dataset, and instead of list of links you get reports with numbers. Search driven analytics is especially good when you need to enable data-driven decisions in your company by non-IT staff - they don't need to know anything about pivot tables and visualization, as reports are configured automatically by search.

SeekTable Ask a question function allows you to perform data exploration with simple search queries. Just enter free-form natural language query and get answers in the form of pivot table or chart. SeekTable helps to form the question with keywords auto-completion: suggestions come from the dataset itself and the cube configuration.

Everyone can use search-driven analytics and get the results for data-driven decision making. Try these online demos:

Sometimes you can get something different from what you expect; in this case you may back to your search query by returing to cube dashboard ("back" in a web browser or click on the cube name in the breadcrumbs) and add more keywords.

Currently natural language queries are supported only for CSV data sources; we'll enable it for databases a bit later.

Keywords recognized in search queries

Dimension Names
Word or phrase that matches dimension Label (or Name if label is not defined). Words order is not important.
Measure Names
Word or phrase that matches measure Label (or aggregate column name + measure Type if label is not defined). Word order is not important; for example, if you have "Sum" measure for column "Total" you can reference it either with total sum or sum of total. To use first "Sum" measure it is enough to specify just sum.
Entity Name
In most cases you can use exact or partial name of some entity (company, person name, country, city etc) without a hint and SeekTable will match most appropriate dimension that corresponds to this name. For example: Canada, New York, John Smith, closed (may refer to 'state' or 'status' column).
Hinted Comparison
You may specify 'hint' keyword that refers to dimension (or measure) before an entity name to clarify which exactly dimension (or measure) you want to match. For example: city Berlin, name John. Hint is required if you want to filter by high-cardinality column (when engine cannot determine a dimension by specified word or phrase).
Equality
=, equal, equals, not equal, not equals
Less Than
<, before, below, less, less than, fewer, under, ending with
Greater Than
>, after, after, above, greater, greater than, more, more than, larger, over, starting with
Dates
SeekTable recognizes dates written in many different formats; this can be even incomplete date like May 1 or 2019 Mar. Note that these 'partial' dates are applied correctly only when your cube has separate dimensions for date parts (year, month, day).
Relative Dates
yesterday, today, tomorrow, this month, current month, prev month, previous month, last month, next month, this year, current year, prev year, previous year, last year, next year
Are you interested in the search-driven analytics for database sources? Please let us know!