Unify Tableau Connector (Unify BI)
The Unify Tableau Connector (Unify BI) is a web data connector that allows Tableau users to create a query to UM Analytics subject areas and return the data to Tableau that can be used to create reports and visualizations. To use Unify Tableau Connector, it is necessary to have Authoring access to one or more UM Analytics subject areas.
Unify BI uses an individual's UM Analytics security; functional/departmental accounts cannot be used for Unify BI data extracts.
Unify Tableau Connector
About Unify Tableau Connector
Unify BI is a plugin that allows Tableau users to tap into UM Analytics as a data source. A UM Analytics query can be exported into Tableau for further reporting.
Some of the key features of Unify BI include:
- Reporting on governed data sources through Tableau
- Using existing UM Analytics reports in Tableau
- Performing joins in Tableau between two UM Analytics data sources
More information can be found on the Unify BI Tableau Connector technology page.
To use the Unify Tableau Connector, you need to have authoring access to one (or more) of the subject areas in UM Analytics. Check assigned access roles in UM Analytics.
Information about requesting author access to subject areas in UM Analytics can be found on the UM Analytics technology page.
Configure Unify Tableau Connector
- Start Tableau Desktop.
- Select Web Data Connector in the Connect - To a Server category. The Web Data Connector window is displayed.
- Note: If Web Data Connector is not displayed in this section, use the More… option to see an expanded list of connections and find Web Data Connector.
- Enter the URL for the Unify Tableau Connector in the address bar at the top of the Web Data Connector window.
- The URL is: https://unifybi.umn.edu/unify
- If you've previously used Unify BI, it will be listed in the Recent Connectors area
- The URL is: https://unifybi.umn.edu/unify
- Press enter on the keyboard. The authentication window is displayed.
- Enter your University of Minnesota Internet ID and Password into the fields.
- Click Sign In. The Unify BI Workspace is displayed.
- Note: This functionality uses an individual's UM Analytics security and all data extracts and refreshes will require Duo (multi-factor authentication). Functional/Departmental accounts cannot be used for Unify BI data extracts.
- Click the subject Area dropdown list in the top left. All subject areas that you have authoring access to are displayed.
- Select a subject area. The folders of dimensions and measures for the subject area are displayed in the left sidebar.
- Click the > icon to expand a folder.
- Double-click or drag-and-drop dimensions and measures to add them to the workspace (the Drop Columns Here area).
- In the image below, the Date folder is collapsed and the HR Dept Hierarchy folder is expanded.
- In the image below, the Date folder is collapsed and the HR Dept Hierarchy folder is expanded.
- Select the X icon to remove a column from the workspace.
- Click the Filters tab at the top of the Unify workspace. The filters panel is displayed.
- Click the > icon to expand a folder in the Subject Area pane.
- Double-click or drag-and-drop a dimension or measure to add to the filter group.
- The default filter condition is Equal/In, click the drop-down to select a different condition.
- Click the drop-down in the empty field to select values for the filter condition.
- Click the magnifying glass to the right of the empty field to search for values.
- Click the X to remove the filter condition.
- Filters within a filter group are AND by default. Click the OR button in the filter group bar to change it.
Create Filter Groups
- Click the + icon in the Filter Group heading to create a new Filter Group.
- Click the X icon in the Filter Group heading to remove the Filter Group.
Adding columns to Filter Groups
If you have multiple filter groups defined, double-clicking a column will only add the column to the first filter group. If you want to add a column to any other group, you will need to drag the column and drop it on the Filter Group bar.
"Combining and grouping filters with AND and OR Boolean operators enables you to create complex filters without requiring you to know SQL statements. Grouping enables you to establish the precedence in which Oracle BI EE filters an analysis." (From the Oracle help documents.)
Creating and editing column formulas is the same as in UM Analytics. Creating column formulas is useful if aggregation or calculation is needed in the report. For example, the IFNULL formula is useful when a measure column contains null values; or, COUNT is useful for aggregating values of a column.
- Click the Columns tab in the header area of the Unify BI workspace.
- Locate the column and click the gear icon. The edit column window is displayed.
- Edit the name of the column at the top.
- Enter the formula in the formulas area.
- Click the book icon to open the list of all formulas to see the correct syntax.
- Click the book icon to open the list of all formulas to see the correct syntax.
- Click the checkmark to finish editing the column.
At any point when selecting, editing, and filtering the columns, the returned data can be previewed.
- Click the preview data button in the header area of the workspace.
- The data is displayed in a table.
- The data preview is limited to 100 rows in order to verify your data set.
- Use the filter at the top to filter the displayed data in the table.
- Use the filter in any column to filter the displayed data for only that column.
- These filter tools are only for finding data in the table, they do not affect the data that will be returned by the finished query.
- The columns can be sorted by clicking the column header.
Multiple queries can be created at the same time. When finished building a query, click Queries in the right hand sidebar. A generic name Table (1) will be assigned. Click the pencil icon to change the name of the query.
Create another query
Click the New Query button in the top toolbar. The Unify BI workspace is cleared out, and the next query can be constructed.
Select the Queries button in the right side bar to save the query
To return to a previous query, click the query name in the right sidebar.
When satisfied with the query, click the green Unify button at the top of the workspace.
Note: The volume of data that can be exported to Tableau is currently limited to 500,000 rows.
The query will execute, and then the data will be available in the Tableau workbook.
- Reminder: If your account uses Duo, you may need to authenticate again.
In Tableau, your data will not initially display on the Data Source tab. Click Update Now to start interacting with your data.
- Reminder: If your account uses Duo, you may need to authenticate again.
Refresh Tableau Data
To refresh the data in the Tableau report,
- Click Data in the menubar.
- Click Refresh all extracts...
- Click Refresh.
- You might need to authenticate with your University Internet ID and Password.
- The data extract will refresh and a green checkmark will be displayed.
The query that is being used by the Unify Tableau Connector can be edited.
To edit the query:
- Click the Data Source tab in the lower left.
- Note: If clicking the Data Source tab takes you straight to the Unify login screen, you will need to refresh the extract first.
- Click the drop-down arrow for the unifybi.umn.edu connection.
- Click Edit Connection...
- Note: If your account uses Duo, you will need to authenticate first.
- Click Edit Connection...
- The Unify BI workspace is displayed.