Integrating Tableau Extensions with DataRobot

This post was originally part of the DataRobot Community. Visit now to browse discussions and ask questions about DataRobot, AI Cloud, data science, and more.

This tutorial shows how to integrate Tableau extensions with DataRobot. By the end, you will be able to:

1. Generate automated insights using the DataRobot Insights extension.
2. Run sensitivity analysis using the DataRobot What-if extension.

Requirements

• You must have a full version of Tableau (2018.2 and later) to use these extensions. You cannot use a Tableau Public account to access the DataRobot extensions. See Tableau help for using extensions.
• For Tableau Server and Tableau Online, you need to ensure that DataRobot’s app and prediction server URLs are whitelisted:

• If you are using an on-premise version of DataRobot:
  • Tableau expects all extension communication to use HTTPS. You need to make sure that DataRobot is set up with SSL and ideally with a certificate from a trusted Certificate Authority; otherwise, additional steps are required.
  • Update the DataRobot application server URL in the Tableau Extension:
    1. Download the Extension file:
       
       • https://app.datarobot.com/tableau/insights or https://app.eu.datarobot.com/tableau/insights (or a similar on-premise domain location).
         OR
       • https://app.datarobot.com/tableau/what-if or https://app.eu.datarobot.com/tableau/what-if (or similar on-premise domain location).
    2. Open the DataRobot_Insights.trex file with a text editor.
    3. Edit the URL of the DataRobot application server for your organization.

DataRobot Insights Extension

1. Open a new Tableau book and add a new data source. You can upload a local Excel file as well.
2. Create a new worksheet and try to visualize some interactions between the columns. For this example, we use AVG(Target) in columns and the Purpose of the loan in rows to see how the outcome is dependent on different categories.

3. Create a new dashboard using the worksheet created above.

4.  Drag the Extension button to the dashboard.

5. Click My Extensions and select the DataRobot Insights extension. If you don’t see the extension file, you can download it from the Extensions Gallery (https://app.datarobot.com/tableau/insights, https://app.eu.datarobot.com/tableau/insights, or similar on-premise domain location).
   

   

6. Select the DataRobot_Insights.trex file.
   

   

   
   
   And click OK for Allow Extension.

   

     
7. Establish a connection between DataRobot and Tableau by providing the API Token.
   
   Click the account profile link to go to your DataRobot settings.
   
   

   

   
   
8. From the Account Profile page, select Developer Tools.

   

9. Copy the API token.
   

   

10.  Paste the API token in the Tableau extension (1) and click Login (2).
    

    

11. Select the worksheet, set the target column (Find insights related to), and click Start to launch automated insights.
    

    

DataRobot will analyze all the features, and find associations between these features and the target column. This process could take from a few seconds to a few minutes depending on the volume of data.

After analysis

Once the computation is finished, you will see the correlations between the features and the outcome in an interactive manner.

These insights can be incredibly important to get a sense of what the data looks like before starting to build models. It can give an early indication of whether or not there’s any any predictive signal in the data.

In situations where there too many columns, these insights could be used for reducing the dimensionality of the data by eliminating columns that do not have any association with the target.

Important: Tableau restricts this extension to operate on 10,000 rows. If you think that more data is required for meaningful insights, then it is recommended that you connect DataRobot directly to the source data.

DataRobot What-if Extension

Note: The What-If extension requires a DataRobot Prediction Server and works for binary classification and regression models; time series and multiclass are currently not supported.

1. Open a new workbook and create a new dashboard. This time there is no need to add data sources because you will access the DataRobot model deployment directly.

2. Drag the Extension button to the dashboard again.

3. This time, upload the DataRobot_What-if.trex file when asked for the extensions file.

4. Connect to DataRobot by providing the API key (as you did for the DataRobot Insights extension).
5. Paste the API token in the Tableau extension (1) and click Login (2).

7. Once the connection is made, you will see all the deployments associated with your DataRobot account. Choose the deployment on which you want to run the scenarios (1) and click Start Simulation.
8. In this area of the page you can create scenarios by entering values for different variables that the model uses for computing predictions. After entering the values, click Update prediction. This will display the predicted probability along with Prediction Explanations.
9. Click + Add to comparison to add this scenario to the comparison list.

10. Create more scenarios by tweaking the values of variables of interest and click Update prediction and + Add to comparison for each of these scenarios.
11. On the Compare tab (next to the Simulate tab), you now see a side-by-side comparison of these different scenarios.

The consumers of these predictions can modify attributes and analyze how the outcome changes. In addition to providing a glimpse into the future, the what-if analysis also leads to faster decisions.

How to Enable Debug Mode on Tableau

If you have issues connecting Tableau to DataRobot, it can be very useful to enable Tableau’s debug mode, which allows you to gather more information so that you can narrow down the issue.

The below steps describe how to enable Tableau’s Debug Mode for Tableau 2019.1 or greater. If you are using Tableau 2018.2 or 2018.3, refer to Tableau’s trex debugger for the Chromium browse (available for download).

For Tableau 2019.1 or greater:

1. Start Tableau Desktop and enable debugging:
   from a command prompt, start Tableau using –remote-debugging-port=8696
   
   For example:
   C:\Program Files\Tableau\Tableau 2019.3\bin>tableau.exe –remote-debugging-port=8696
2. Open the Tableau Dashboard that includes the DataRobot Extension.
3. Open Chrome browser and browse to http://localhost:8696.
   
   The image below will appear, listing the pages to inspect.
   
   
   
   
   1. Select the extension to inspect; in this example, it is the DataRobot What-If extension.
   2. Complete the fields in the Tableau dashboard and select the dashboard button that calls the DataRobot integration. (For the What-If extension, this is the Update Predictions button.)
   3. Switch back into the Chrome inspect page to view the network requests from Tableau Desktop and the associated status. Note, this will be in the Network tab on the page.
      
      The two images below show success cases:
      
      
      
      The first image provides the details around the call (the request URL, response headers, and status) and the second image provides a preview of the response message.
      
   4.  The next two images show an error condition and the resulting message back from DataRobot:
      
       
      The first image is showing a status code of 422 while the second image from the Preview tab displays the message back. In this case, the Tableau Extension is not properly handling the formatting of currency data types.

Looking for More Information on Tableau Extensions?

Check out the DataRobot blog, Introducing DataRobot Insights Extension for Tableau. Or go to our public documentation portal and navigate to the Using the Tableau Analytics Extension with Deployments section for more details.

About the author

Linda Haviland

Community Manager

Meet Linda Haviland