The iAudior, Tableau connector allows you to quickly and easily export your inspection information into Tableau for operations optimization, and drag and drop visualizations. Getting started with Tableau is easy. All you need is an iAuditor API token, a licensed copy of Tableau Desktop 10.0+, and five minutes.
Learn via video
Setup the Tableau connector
- Open Tableau Desktop:
- In the left side menu, select Connect > To a Server > Web Data Connector
- Enter the URL for the SafetyCulture Web Data Connector (tableau.safetyculture.com) in the interface which comes up
- Hit enter and the input form of the Web Data Connector will be displayed.
- You must input a valid API token before templates will be displayed in the ‘Select Templates’ menu.
- Select one or more templates, select a ‘From’ date (leave the ‘To’ field blank if you want to pull audits up until current time and be able to refresh your data later).
- Hit continue
- On the next screen, click “Update Now”
- Tableau will call the API, retrieving all of the audit data that fit the parameters you selected in the input form.
- The Tableau connector fetches all data in the specified date range each time a refresh is requested.
- The time it takes to load the data of a single inspection (audit) depends on many factors including network speed, the size of the audit, etc.
- In our testing, loading a single inspection (audit) took approximately 2 seconds. If a large number of audits is found for the specified date range, the refresh process may take a long time i.e. 2 seconds x the number of audits retrieved.
- Once complete, you’ll see your data in tabular format
- Select ‘Go to Worksheet’ on the bottom menu bar, and then
- Drag and drop fields from the left panes onto the Columns, Rows, and Marks shelves to start building visualizations immediately.
Read this article for information on the Wed Data Connector