Overview

Customers rely on multiple systems to manage their real estate portfolio. The biggest challenge they are facing today is to combine the data from all these sources to get a holistic view and overall understanding of their portfolio. To make it easy for customers to include Space occupancy and utilization data in their portfolio analysis and reporting, Enlighted has built a Tableau integration for the Space application.

Customers can visualize Space application data such as Aggregated Zonal Occupancy and Utilization Data for 5-15 minute intervals. This data can be used to analyze and report on people’s presence in a building or determine asset maintenance needs by furniture type.

Advantages of Exposing Data in Tableau

With the ability to add multiple data connections, customers can blend their Space data with data from different systems to perform aggregate data analysis.

Tableau also makes it easy to create informative visualizations that can be used to submit reports to executives.

Connecting the Space Data Source to Tableau

Connecting Space data with Tableau requires a web data connector. When you use a web data connector, Tableau creates a one-time extract of the data that the connector accesses. You can refresh the extract in Tableau Desktop.

Enlighted provides only the web connector URL. Customers are responsible for pulling, maintaining, and analyzing the data in Tableau.

Prerequisites

Customers must have:

• Space application license

• Their own Tableau instance and license

Enlighted Space-Tableau Connector URL

Enlighted provides the Tableau connector in the form of a URL:

• Production: https://space.enlightedinc.com/tableau

• QA: https://space-qa-1.enlightedinc.com/tableau *

_{*Note that there is no Avg Utilization data in the QA account.}

Connect to the Data Source from Tableau

1. Start the Tableau web or desktop app.

   • In the Connect panel under To a Server, select Web Data Connector.

   • If you do not see the option, you may need to click More.
     
     
     

2. In the popup, enter the URLhttps://space.enlightedinc.com/tableau, then press the Enter key.
   
   
   

3. Enter your Enlighted Space credentials. This works the same way as logging into the Space application—both SSO and non-SSO logins are supported.

   • SSO users will enter your work email, then proceed through your company's login flow.

   • Non-SSO users will enter your Space username/email and password.
     
     
     

4. Enter the dates you want to get data for. You can choose between 1-30 days for any date range that you have Space data. Due to the large volume of data, it is limited to 30 days.
5. Click Get Facilities Data! Once the data has been pulled into Tableau, the Data Source page will open.
   
   
   
6. Click the Update Now button. (Note that the Update Automatically button does not work.)
   
   
   
   
7. The table name and list of fields are in the left pane and the data rows are on the right. You can see the total number of fields and rows (a). By default, the data table shows 100 rows at a time.
   • Click the arrow (b) to page through the rows 100 at a time. Modify the number to see more or fewer rows at a time.
     

8. Click the sheet tab at the bottom left of the window to start your analysis.

Refresh or Edit Data

1. In the left panel of the Data Source page, click the down arrow by the connection name, then select Edit Connection.
   
   
   

   • Tableau requires that each time you want to refresh or extract new data for the connector, you will need to log in again.

2. In the Space Tableau Connector popup, select the dates and click Get Facilities Data!

3. Then on the Data Source page, click the Update Now button.

Data Fields for Zone Utilization and Occupancy Data

The facilities data from the Space application is exposed with this connector.