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
*Note that there is no Avg Utilization data in the QA account.
Connect to the Data Source from Tableau
-
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.
-
- In the popup, enter the URL
https://space.enlightedinc.com/tableau
, then press the Enter key. -
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.
-
- 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.
- Click Get Facilities Data! Once the data has been pulled into Tableau, the Data Source page will open.
- Click the Update Now button. (Note that the Update Automatically button does not work.)
- 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.
- 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.
-
Click the sheet tab at the bottom left of the window to start your analysis.
Refresh or Edit Data
-
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.
-
-
In the Space Tableau Connector popup, select the dates and click Get Facilities Data!
-
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.
tenant |
This is the Customer. |
|
Campus name |
|
Building name |
|
Building address |
|
Floor name |
|
Space name |
|
Space category |
|
Space department |
|
Date |
time_start |
Timestamp for the start of each 15-minute time period. For example, a 12:00am time stamp represents the start of the 15-minute period from 12:00–12:15am. |
time_end |
Timestamp for the end of each 15-minute time period. For example, a 12:15am time stamp represents the end of the 15-minute period from 12:00–12:15am. |
avg_utilization |
For clarity, this field is named “Utilization” in Tableau. For every 15 minutes, the aggregate utilization data is shown as a percentage. Note that there is no Avg Utilization data in QA.
|
minutes_occupied |
Number of minutes there is at least one person in the space. |
minutes_data |
Number of minutes of sensor data. |
agg_interval |
Duration of the |
Comments
Article is closed for comments.