Natural Language Processing

Knowi's Natural Language capabilities is a powerful way to enable self-service analytics to non-technical users, by asking questions in plain English to drive insights and visualizations quickly. This empowers any member and individual the ability to make better, data-driven decisions, any time.

Natural Language capabilities are available for use across all datasets and widgets within a dashboard. It can be accessed using the Natural Language/Self Serve Analytics icon on a widget. As you explore your data with natural language, Knowi recommends questions based on your input and the data source available. The technology works by translating your natural language query to Cloud9QL statement to resolve your request.

NLP Across Datasets

Using natural language processing at the dashboard queries across all datasets within your account. Auto-complete suggestions will be recommended as you type based on the associated dataset. For example, if you had multiple datasets powering a single sales and marketing dashboard, and you wanted answer on the latest marketing information, typing your query matches the requested fields and aggregation to the datasets the user has access to.

Natural Language Processing

When using NLP across datasets, you can explicitly request which datasets/query to use by incorporating "from" at the end of your query. For example,

what is the average revenue by sales_representation by region from product sales (prod)

From the example above, product sales (prod) is the name of the dataset/query containing the sales information.

NLP From

Enable NLP Usage Across Datasets

Using NLP across datasets is a customer user feature that must be enabled by an admin-role. To enable this feature for users:

  1. From the Knowi panel, click Settings and navigate to the User Settings page
  2. In the Account Settings tab, click the NLP ACCESS switch to ENABLE/DISABLE the feature

Enable NLP Dash

NLP Within Widgets

Unlike across datasets, for use within widgets, natural language queries are applied directly on the dataset powering that widget.

NLP is available on all widgets inside a dashboard from the widget menu and available to all users, regardless of user role/permission.

NLP Widget

Examples

The following are examples of natural language query to get you started:

Sample field selection
"bounced, sent, customer"

"bounced and sent and customer"

"Show me all for Wells Fargo"

"all for customer Wells Fargo"

"all fields for customer like Wells Fargo"

"bounced and sent for Wells Fargo"
Aggregations
"Sum of sent sum of open by customer"

"Total sent by customer by week"

"Total sent, Total bounced for Wells Fargo"

"Average Sent, Total bounced by customer by campaign_name for newsletter"
Dates
"all for date after January this year"

"average close monthly"

"close by date for january this year"

"close by date between january and march this year"

Embedding Search-based Analytics (NLP)

Using Knowi's Search Analytics can be embedded in your application through Single Sign-On. Try it out.

Similar to embedding with SSO and the Javascript API, the steps to embedding Search Analytics is almost identical and can be achieved in three steps:

1. User Token: Create a Knowi user token for a new or existing user

curl -i -X POST -d "user=email@domain.com&ssoCustomerToken=<SSO_TOKEN>" https://knowi.com/sso/user/create

2. Session Token: Create a Knowi session token with the user token from step 1

curl -i -X POST -d "user=email@domain.com&userToken=<USER_TOKEN>" https://knowi.com/sso/session/create

3. Embed: Write a Javascript file with the session token returned from step 2

function loadSearchAnalytics() {
    Knowi.render('#knowi-div', {
        type: 'nlp',
        token: "BYhXXCeu0Ego8zA1FqtLOOM4BDWot5AYBLI7PWrQTbsie",
        url: 'https://www.knowi.com',
        view: {
            nlpOptions: {
                icon: "off",
                css: {
                    background: 'transparent'
                },
                placeholder: "Try: total sales for canada this week",
            }
        }
    }, function () {
    });
}

Note: For embedding Search Analytics, type must be nlp

Search-Analytics Resources:

  • Javascript API Reference | link
  • Search Analytics code samples | link


Slack Integration

Slack is where the people you need, the information you share, and the tools you use come together to get things done. With Knowi's Slack integration, its powerful Search-based analytics (or Natural Language Processing) capabilities combine with Slack's intuitive messaging UI, allowing you to ask questions from your Knowi data directly from the Slack app and get answers back instantly. This allows you to obtain quick insights from your data, optimize by integrating it into your workflows, and enhance collaboration within your team.

For instructions on using Knowi's Slack integration as an Admin, click here.

For instructions on using Knowi's Slack integration as a User, click here.