Just how valuable are our cities 'data people'?
This story was originally posted by Data-Smart City Solutions.
Increasingly, leading cities are hiring “data people.” Whether with the title chief data officer, chief innovation officer, performance stat program director, or data scientist, these individuals are looking at government in a new way and using data to increase efficiency. Are these hires worth the investment? Resoundingly, the answer is yes. However, their value is often hard to demonstrate. For example, improvements in the quality or efficiency of public services, or the integrity and accuracy of service delivery, are not easy to measure. Yet these officials are essential to improving results and to restoring faith in our government.
There are some areas where the value of data experts in government has been well established. For example, at the federal and state levels, data analytics can identify fraud and find savings in tax and benefits programs. But at the city level there are few documented examples that demonstrate the return on investment available to cities that hire staff specifically for data analysis across operational and functional lines. Government employees with data skills can be thought of as “utility infielders,” able to work across departmental silos on a variety of projects, their value recognized internally but too seldom documented for the public. This compilation of examples of the financial benefit of hiring a data analyst in government is intended to establish a starting point for continued dialogue on how public servants with data skills can produce a financial return for their taxpayers. Examples include the use of descriptive data for management purposes, such as in stat programs, as well as the development of predictive data analytics models that allow prioritization of government action.
The city of Louisville, Kentucky adopted a data-driven performance management approach to measuring results five years ago, creating the Office of Performance Improvement and Innovation (OPI). Last year, OPI hired a chief data officer to lead specialized geospatial and predictive modeling efforts. OPI quantifies everything in city government, including their own impact, which they calculate at a five-to-one return for every dollar of cost to the city. Some examples of concrete financial benefit for the city include:
Reflecting on the success of OPI in claiming revenue owed to the city by scofflaws, and tightening management of operations to avoid excess costs, Daro Mott, Chief of Performance Improvement, says:
“The use of data for performance management has the power to make government smarter, faster, cheaper, and better. With our data-driven approach, we’re addressing the following basic questions: what do we do, how much, how well, and who is better off? Together with department leadership teams, my team co-creates data-driven solutions to problems for the sake of our citizens and taxpayers.”
South Bend, Indiana is a city of 100,000 that punches above its weight in bringing data to bear on government problems, applying data analytics, geospatial analysis, and common sense in the Office of Innovation. The city tracks the return on investment for all of its projects and estimates a total return of $20 million in the three years since the program began, with a large part of that value coming from data analysis on large city contracts to extract additional value.
The team saved the city $5 million via a series of route optimization and fleet management projects. For example, the city saved $1.4 million by moving from larger trucks to SUVs for certain city operations. The city also avoided significant costs for garbage truck replacement when it applied geospatial analysis to the city’s routing of the trucks — the analysis found the city needed only seven garbage trucks, instead of 10, to do its work. Not only did the city reduce costs, it improved the quality of its waste management by putting radio-frequency identification tags on trash bins, which reduced missed pickups by 30 percent. Santiago Garces, the city’s chief innovation officer, says his job is about helping city staff “spend less time doing things that are tedious and more time adding value for the residents.” He recognizes that his team of analysts is small but that it can have strategic value across the city, saying, “The biggest role analytics has played is prioritizing and figuring out what are the things most important to go after for city government to operate at greatest value to the taxpayer.”
In Boston, the Citywide Analytics Team has taken on projects on important topics such as drug overdoses, ambulance deployment, traffic congestion, human trafficking, homelessness, restaurant inspections, the safety of rental housing, and parking enforcement. Chief Data Officer Andrew Therriault, in the position since 2016, recently launched a new project selection and management workflow that makes tracking the return on investment for every project an essential part of the process, and plans to share the results publicly. “The city of Boston has made a major investment in data and analytics over the past three years,” he says, “and it’s already paying off substantially. I’m really proud of what our team has accomplished, and we’re excited to be able to give the public a better view of what we’ve done to make life better for everyone here in Boston.”
A few projects where impact has been quantified already include:
The city of San Francisco is a leader in open data and in promoting data use in city government, led by the office of the chief data officer (CDO). While much of the value created has been hard to measure, the city has developed a long-term evaluation plan to assess the impact of its open data program that will measure both the degree to which, among other things, city employees are using the data to make their jobs easier, and the number of external uses of the data.
There are many ways the value of the open data program has already been demonstrated, even if few are easy to quantify. The CDO’s team has developed a culture of data usage across city government by creating and connecting a cohort of data coordinators in departments, by hosting quarterly events to celebrate exemplary uses of data, and by creating an annual Data and Innovation Awards program. The data culture is evident in cross-departmental efforts to publish and analyze data such as the Housing Data Hub, which includes data across all city agencies connected to the challenge of affordable housing, and the neighborhood-specific problem-solving portal for the Tenderloin district, which is a joint project of city economic development, planning, and public health employees. The anchor of their data culture-change program is the Data Academy. The Data Academy has taught over 700 city employees how to gather and understand data, how to analyze and present data, and how to explain data insights to policymakers. At the cost of about one FTE, the city saves $1.7 million a year by empowering employees to use their technology and data skills to save time and money on the job.
New York City is well-known for its application of data analytics to operations and management through the Mayor’s Office of Data Analytics (MODA), established by Mayor Michael Bloomberg and continuing today. MODA is developing a formal structure for reporting out cost savings and increased revenue achieved for the city, along with efficiencies that improve service quality and fairness. One example of a project that will have quantifiable benefits is an effort to implement universal school lunch programs in a way that optimizes program reimbursement to the city from the federal government. Two additional cost savings examples completed in New York include:
Cincinnati, Ohio created its Office of Performance and Data Analytics in 2015, an operation that includes performance management, open data, and advanced geospatial analytics. Between new revenue and cost avoided, the team has achieved $6.1 million in value for the city since inception. A few examples:
In Syracuse, New York, the city’s chief data officer managed a project through the University of Chicago’s Data Science for Social Good program that developed a predictive model to identify the water mains at greatest risk of breakage so the city could prioritize preventive repairs. The model incorporates 12 years of water main data, including data about the age and diameter of the pipes and the geology of the soil and road quality above them. The model allows for strategic deployment of sensors on the water mains, as well as for preventive repair and replacement in coordination with other public works projects. The new model is six times as effective as the status quo process for preventing water main breaks. Implementing this data-driven model of proactive water main replacement will save the city $400,000 this year and $800,000 next year by avoiding emergency repairs, and replacing them with proactive rather than reactive water main repairs.
New Orleans created its Office of Performance and Accountability in 2011 and has long been a leader in applying data insight to achieve better results for the public, both via citywide performance management and by targeted use of predictive analytics. Many of the high-priority analytics projects have focused on saving lives, including efforts to more strategically deploy ambulances, using risk data to get smoke detectors into the most vulnerable homes, and applying behavioral economics to close health disparities.
The city data team has also applied its talents to work that brings in revenue or avoids costs for the city. The city’s blight reduction project addressed 15,000 blighted properties and reduced inspection time from 160 to 80 days, while reducing the backlog of appeals, all by applying data analytics and a stat process to managing the effort. Financial benefits have not been calculated, but include additional fines and fees collected from errant homeowners and significant additional tax revenue as the properties are returned to productive use. As part of that project, the team applied behavioral economics to “nudge” homeowners of blighted properties to address the problems reported to the city. As a result, the increase in homeowner compliance resulted in a net savings of an FTE in the inspections team.
The small suburban town of Wellesley, Massachusetts has saved $132,000 in energy costs using data analytics. By managing and reporting regularly on energy use for each town building and benchmarking the results, the town reduced energy use by 9 percent over a three-year period, even with 37 percent more extreme weather days. Installing exterior LED lights in town buildings is achieving 15 percent more light and a 10 percent overall reduction in electricity energy costs.
The city of San Diego, with its open data portal, predictive analytics, geospatial analysis, and performance management program, has achieved significant savings, just a few years into its innovation efforts. Many projects have clear value in efficiency and will have future cost savings. For example, innovation teams using Lean Six Sigma methodology streamlined the 911 call answering and dispatch process to offload non-emergency calls, allowing true emergency calls to be answered faster. Another project resulted in a 42-percent improvement in the time spent hand-sorting materials that library patrons request through careful analysis of motion diagrams and process maps and the elimination of non-value-add steps in the process. One project with a significant projected savings is the “smart city” initiative. This effort includes sensors on streetlights that allow automatic dimming and brightening of the lights, estimated to save $2.4 million annually on the city’s energy costs.
The city of Chicago has been a leader in open data and in the use of predictive analytics to improve city operations. Development of sophisticated predictive analytics models have resulted in major quality of life improvements for city residents, including increased effectiveness of restaurant inspections and improved accuracy of estimates of unsafe swimming conditions at city beaches. The city’s rodent abatement program is now 20-percent more efficient based on the predictive model used to identify problems before they occur.
The open data program has been successful in not only increasing transparency and data sharing across agencies, it has also resulted in tangible benefits. For example, the city’s Department of Public Health noticed a 40-percent decrease in Freedom of Information Act requests after the launch of the city’s open data portal. This has allowed that department to deploy its resources on higher value-add activities rather than photocopying documents and mailing them to requestors.
The city of Atlanta has an innovation team in the Mayor’s Office populated with data analysts focused on solving high-priority problems for the city. When faced with a $1 billion infrastructure backlog, the group focused on finding financial efficiencies. Their data analysis skills produced a high financial return including:
In Baltimore, the implementation of a budgeting for outcomes strategy used data in focusing on results for the city’s top priorities, carefully examining data and evidence on what was working and what wasn’t. Data analysts worked in cross-departmental “results teams” to identify efficiencies and opportunities for cross-agency collaboration to achieve the best outcomes for the public. Efficiencies included both cost savings and increased revenue. For example:
While these examples are by no means exhaustive, they demonstrate that hiring a data analyst in city government, and assigning that person to find economies, can pay for their salary once over, or in some cases 22 times over. Each dollar value in quantifiable savings represents immeasurable added value in restored faith in the efficiency and integrity of government. As the field continues to grow, we hope to catalog both substantive successes of data-driven government, as well as the concrete returns for taxpayer value.