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 a natural language question. NLQ is particularly effective for enabling non-IT users in your company to make data-driven decisions: they don't need to understand pivot tables or data visualization, as reports are automatically configured through natural language search.

GenAI-powered Ask Data and top-menu Search Box allow users to start data exploration with simple free-form queries. SeekTable automatically generates appropriate tabular report/chart based on the natural language query, providing clear and understandable answers.

Search-driven reporting significantly lowers the barrier to entry for data analysis. Try these online demos:

• American Time Use Survey dataset: type average television by age range and gender
• Superstore Sales dataset: type show sales sum in 2024 vs 2023 by region and month

Sometimes you can get something different from what you expect; in this case you may back to your query by returning to the cube view ("back" in a web browser or click the cube name in the breadcrumbs) and clarify your question.

Search-driven reporting is enabled by default for CSV cubes; for databases you may enable search interface by checking an appropriate option in the cube configuration form.

Non-LLM "Ask Data" implementation

On-prem SeekTable installations without activated "AI Functions" have "Ask Data" capability that fallbacks to built-in non-LLM search query recognizer (which is 100% safe in terms of data privacy). This implementation works like a search engine: it tries to find best matches for keywords from the query.

Keep in mind that non-LLM "Ask Data" does not really understand your query (intent), it just matches keywords you entered and tries to suggest most relevant reports.

Keywords recognized in non-LLM search query parser:

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.

Hinted Comparison

To filter by some dimension's value you may specify a hint keyword that refers to the dimension (or measure) before an entity name to clarify which exactly dimension (or measure) you want to match. For example: city Berlin (or city:Berlin), name John. Hint is required if you want to filter by a high-cardinality column (when SeekTable cannot recognize a value).

Entity Name

You can use specify full or partial name of some entity (company, person name, country, city etc) without a hint and SeekTable will try to match most appropriate dimension that corresponds to this name. For example: Canada, New York, John Smith, closed (may refer to 'state' or 'status' column).

Entities recognition works differently for CSV and databases. In case of CSV data SeekTable performs quick scan of CSV file and suggestions/by-value-recognition works for all dimensions. However, this approach is not possible for DB cubes, and suggestions/by-value-recognition works only for dimensions explicitly specified in "Match Dimension" list on the cube configuration form. It is recomended to specify here only low-cardinality dimensions that may be quickly loaded.

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

Chat with data

LLM makes it possible to chat with connected databases or uploaded CSV data, ask various questions, and get text answers that require making queries to your data. This is known as RAG (Retrieval Augmented Generation) when an additional data context is added to LLM's prompt and guarantees that the answers you receive are accurate and come directly from your data.

SeekTable can act as a managed context provider, when LLM can do only queries in terms of configured cubes and applied RLS (row-level security) rules to guarantee that a concrete user can access only allowed records. Compared to allowing LLM to run any SQL it can generate, this is a much more convenient and safe way to work with business data.