DGS created a telework dashboard to track telework-related statistics at the enterprise level. Review the case study and data dictionary to learn more.
This is a summary of the DGS telework dashboard, skip this if you want to go to the dashboard directly
Dashboard summary: The DGS telework dashboard combines DGS employees’ telework status with GIS route data to estimate the benefits of the telework program. This dashboard and its data are available to the public. The DGS dashboard displays the following information as of August 17, 2020. DGS has 3,513 employees of which 56.3% are eligible for telework and 43.7% are ineligible. Of the 1,979 eligible employees 1,205 employees telework full-time, 419 employees telework part-time, and 355 employees don’t telework. On average, DGS has 73.3% of eligible employees teleworking per week. The average estimated 1-way commute distance for teleworking employees is 15.42 miles. The average estimated 1-way commute time for teleworking employees is 27.34 minutes. Weekly, DGS telecommuters save 220,000 commute miles. This equates to 6,521 commute hours, or 272 days. Cumulatively, an estimated 16.4 years of commute time has been saved. The trend of gasoline prices reduced from $3.44 per gallon in March, 2020 to $2.88 per gallon in May, 2020, then increased to $3.29 per gallon in August, 2020. Weekly, DGS telecommuters save an estimated 9,035 gallons of gas, equating to $29,699 in saved gas dollars. Cumulatively, an estimated 198,000 gallons of gas and $619,000 gas dollars have been saved since March 2020. The cumulative estimate of saved commute miles equates to traveling around the Earth 194 times, or 10.1 round trips to the Moon. Weekly, DGS telecommuters avoid an estimated 80 metric tons of CO2 released into the atmosphere. Cumulatively, an estimated 1,761 metric tons of CO2 has been avoided, and 2,287 acres/year of carbon has been absorbed by the US forest. DGS used both internal and external data sources. Internally, telework requests are maintained in ServiceNow. Employees’ driving distance and time are calculated via Esri ArcGIS from the home and work addresses registered in DGS’ HR system. DGS is sharing the aggregated, scrubbed datasets converted to Excel files via the California Open Data Portal. Externally, historic average gas prices in California come from the California Energy Commission’s California average weekly retail gasoline prices report. Mid-grade gasoline prices are used for calculations. The following assumptions were made in calculating commutes, energy savings, and CO2 emissions. All employees are assumed to drive alone. Public transportation or carpools were not considered. Employees with more than a 100-mile one-way commute, or those using a P.O. Box address were calculated using the average values of teleworking employees. Holidays and vacation days were excluded from calculations. Actual telework days may differ from ServiceNow’s reported counts due to circumstance. The average fuel economy for gasoline passenger vehicles is 24.4 miles per gallon, per the California Energy Commission’s analysis of the Department of Motor Vehicles'’ registration data for personal gasoline vehicles, as of the end of 2019. DGS used the common conversion factor of 8,887 grams of CO2 emissions per gallon of gasoline. The conversion factor for carbon sequestered is 0.77 metric tons of CO2 per acre per year, sequestered annually by one acre of average U.S. Forest (per the Environmental Protection Agency’s Greenhouse Gases Equivalencies Calculator References).
DGS Case Study
How DGS developed a solution to effectively monitor, track and support the transition to telework
The data inputs and data sources used with Power BI to create the telework dashboard
A template with sample datasets will be made available to all departments in the near future