Connect to the Data Source from Tableau


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:

*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.
      blobid0.png

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

  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.
      blobid2.png

  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.
    blobid3.png

  6. Click the Update Now button. (Note that the Update Automatically button does not work.)
    blobid4.png


  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.
      blobid5.png
  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.
    blobid7.png

    • 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.

tenant

This is the Customer.

campus

Campus name

building

Building name

building_address

Building address

floor

Floor name

space_name

Space name

space_category

Space category

space_department

Space department

date

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.
Sample utilization calculation:

  • There are 4 sensors in a 12x12 area,

    • 1 of them is triggered 50% of the time in an hour

      • Occupancy is 50%

      • Utilization is 12.5%

    • 1 of them is triggered 100% of the time in an hour

      • Occupancy is 100%

      • Utilization is 25%

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 avg_utilization interval. This is always 15 minutes.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Article is closed for comments.