Sisense Analytics for Slack
  • 19 May 2022
  • 3 Minutes to read
  • Contributors
  • Dark
    Light
  • PDF

Sisense Analytics for Slack

  • Dark
    Light
  • PDF

Sisense Infused Analytics for Slack is an easy to use chat bot for infusing analytics from Sisense into your workflows in Slack.

Go beyond standard business intelligence by infusing actionable insights in Slack. Sisense is the AI-powered analytics platform that empowers users of all skill levels to not just explore data but take multi-step actions based on results. With customized alerts and action-based widgets, anyone can react immediately when important business changes occur. With the Sisense Infusion App for Slack, you can ask questions of your data without ever leaving your main communication hub.

You can:

  • Perform a customized search/ summary analysis against a Published View using a simple NLQ.
  • Save your NLQs as bookmarks for future reuse.
  • Add Notes/Tribal Knowledge for records returned in the NLQ.
  • Share data with other users.

Basic Commands

You can type basic commands into the input fields:


Command

Description

Login

Prompts the user to login to Sisense

Logout

Logs the user out

Help 

Displays quick help for querying, and actions

Views

Lists all the Views available to the user

Bookmarks

Lists all of the user’s Bookmarks

Querying Using the Sisense Analytics Bot

In Slack, you can write a natural language query and interact with the bot. Results will be returned in a list format. 

Natural language queries are not case sensitive. You can fill in your own jargon like “show me”, but view names, column names, and literal values must be spelled correctly.

To query the bot:

  1. Type Show Views in the input field. All views available to you are displayed:

  2. Write a query using the view name, along with any filters.

See Using Ask Me for more information about how to construct your query.

For example, consider the view shown above named orders, which has Sales Rep, Amount, and Order Date exposed as filter fields.

The following are examples of different ways to query this view:

  • show orders
  • show me orders whose sales rep = ‘sam,oliver’
  • display orders whose sales rep = ‘sam.oliver’ and amount > 100k
  • show orders last quarter whose amount > 50000
  • what are the orders whose order date = last quarter where amount > 100k
  • what are the orders last quarter whose amount > 100k

Note: ‘=’ is the universal operator when filtering string values or dates.

You can navigate the result set of your query.

Left/Right Arrows

Click the left/right arrows to move through each page. 

Results are displayed 10 records at a time.

 Hyperlink

Click a result’s hyperlink (must be configured in the view’s column configuration) to open the linked page in a new window.  

Viewing and Using Query Results

After Sisense returns the results of the query, there are a number of ways you can interact with the results. Results will be displayed natively in Slack, as opposed to a Sisense widget.

Three Dot Menu

This displays options to View Entire Record and Add/View Notes.

View Entire Record

The record will display 6 columns of the view in a report-like format. 

 Add/View Notes

This enables notes to be saved for an individual record. These notes are visible to all users who have access to the view. 

Bookmark

Click Bookmark to create a new bookmark from the query. You can bookmark a query directly from the result set. Advanced users can create an NLQ and share these with other users, who in turn can bookmark them for future use. See Using Bookmarks for more information.  

 Share

Share the query results with other users in a channel or individually. 

 

Analyzing Data

The bot can analyze your data by summarizing metrics and providing a Top 10 breakdown of the different dimensions. The analysis performed is based on the following metrics:

  • The Distinct Count of the Unique Identifier as specified in the view.
    • Past Period and YoY Differential if there is a date filter defined in the query.
  • Aggregation of the Default measure as specified in the view.
    • Range of Min and Max
    • Past Period and YoY Differential if there is a date filter defined in the query.
  • Aggregation of all other measures.

To analyze data:

  1. Run a query and click Analyze Data or prefix a query with the word "analyze".
  2. Select a dimension to analyze the data further.
    Note:
    Selecting a time-based dimension will display a line chart



Was this article helpful?