Sections in this category

Looker → Sisu integration

  • Updated

Sisu’s new integration with Looker enables customers to quickly and easily monitor and diagnose changes in their key metrics. The integration is a direct path from a Looker Explore to a Sisu key driver analysis. Sisu automatically imports the LookML and creates a metric and dataset based on the Explore’s LookML model and analysis containing the dimensions of the Explore.

Demo Video

Requirements

The data source in Looker must match the data source in Sisu.

Initial Setup

[1] Go to Looker “Admin” → “User attributes”. Create a user attribute “sisu_API_token”. Type: string, user access: edit, hide values: no

Untitled__3_.png

Untitled__4_.png

[2] Go to Sisu “Account” → “My API tokens”. Copy the token. 

[3] Go back to Looker “Admin → user admin". Edit the “sisu_API_token” user attribute and paste the API token.

[4] Go to “Admin” → “Actions”. Scroll to bottom of page and “Add action hub”. Paste the URL “https://vip.sisudata.com/services/action_hub”

Untitled__6_.png

[5] “Enable” the Sisu action, selecting the API token. Test the action and save.

Untitled__7_.png

Kicking Off an Analysis

[1] Go to a Looker dashboard or Explore

Untitled__8_.png

[2] Configure the explore. Click the explore actions (⚙️) and “Send”.

[3] Select the General Performance KDA. Select the data source used for both Looker and Sisu. Then “Send”. If the send fails, then the token or data source may be incorrect.

Untitled__9_.png

[4] Open your scratchpad project in Sisu. An analysis with metric and dataset is automatically generated and run in Sisu based on the measure and dimensions defined in the LookML of the Explore.

Untitled__10_.png

Untitled__11_.png