Benefits

Analyzing employee badge data is useful for space managers who have a large portfolio of mixed workspaces, hoteled desks, and team spaces and need to:

• understand if the current capacity meets the occupancy demand

• understand if booked workspaces and meeting rooms are actually used

This type of analysis can lead to:

• increased efficiency of booked or assigned space, which can lead to potential space inventory savings

• higher degree of employee accountability for booked space

In terms of return to work during the COVID-19 pandemic, tracking employee badge data enables you to:

• trace employees and visitors potentially exposed to COVID-19

• understand if the current capacity meets the reduced occupancy targets and safe distancing rules dictated by the COVID pandemic.

• promote a safe return to work, by preventing liabilities and increasing employee confidence in the contact tracing system.

Procedure

To analyze the provided sample employee badge data, you run a connector that gathers badge data. You can then review this data in the Daily Badge Swipes report and analyze the data with the Space Access Analysis report. If you want to work with your own badge data, edit the connector file and enter the name of your own CSV file.

1. Run the System / System Administrator / Execute Connectors task. In the filter, search for the Solution-DailyBadgeSwipes connector.

2. Check the import process status to make sure that data was imported successfully. If there are connector/API import log error messages, fix the data in the CSV file and re-import the file.

3. Review the badge data in the View Daily Badge Swipes report ( \schema\ab-products\solutions\badge\ab-ex-daily-badge-swipe.axvw).

4. Analyze your space usage with the Space Access Analysis report ( \schema\ab-products\solutions\badge\ab-sp-access-analysis.axvw). This report provides statistics on:

   • Daily Utilization %

   • Peak Daily Utilization

   • Daily Utilization Trend

Calculations

Value	Description	Calculation
Floors	Count of building floors. S	ELECT COUNT(fl_id) FROM fl WHERE em.bl_id = [selected bl_id]
Seats	Building total capacity by summing the capacity of all rooms in the building.	SUM (rm.cap_em) FROM rm WHERE rm.bl_id = [selected bl_id]
Assigned	Total count of employees permanently assigned to floors and rooms in the building.	SELECT COUNT(em_id) FROM em WHERE em.bl_id = [selected bl_id]
Seen (Daily, Avg.) (Based on badge swipes)	Average count of employees that have accessed the building for each day of the selected date range.
Daily Utilization	Average percentage of daily seen employees vs. building seats for the selected date range	Seen Employees (Daily, Average) / Seats
Occupancy Target	Building Occupancy Target	bl.occup_target . Formatted as Percentage.

Assignment Type (for the building and date accessed):

• Permanent → the employee has a permanent seat on this floor ( EXISTS 1 rm.em_id FROM em_id and fl_id)

• Hoteling → the employee has at least on booking on this floor and date

• Meeting → the employee has at least one reservation on this floor and date

• Multiple types → the employee has multiple assignment types for this floor and date → ex. permanent and/or hoteling and/or meeting

• Unknown → the employee has no assignment (permanent or hoteling bookings or meetings) for this floor and date

Details

View Files

• Space Access Analysis report -- \schema\ab-products\solutions\badge\ab-sp-access-analysis.axvw

• View Daily Badge Swipes -- \schema\ab-products\solutions\badge\ab-ex-daily-badge-swipe.axvw

Connector

• Solution-DailyBadgeSwipes

Sample data

The sample data file is located in this folder:

• \projects\hq\datafeeds\solutions\connectors\feeds\badge\SAMPLE utilization.csv

The columns are:

• Building = Building Code

• EmployeeNo = Employee Code

• Access Date = Date of accessing the building in international format (YYYY-MM-DD)