How Open Data Is Changing Chicago
Skip to content
Data AnalyticsStrategy Operations Jun 20, 2016

How Open Data Is Changing Chicago

A Q&A with Chicago’s chief data officer about the power of big data.

Chicago's Open Data Portal helps improve operational efficiency.

Michael Meier

Based on insights from

Achal Bassamboo

Tom Schenk

United States cities collect data on everything from reported potholes to bus ridership to municipal workers’ salaries. With all this info at their fingertips, they are perfectly positioned to take advantage of big data to improve their efficiency and service delivery.

But some cities have even bigger plans for the data they collect.

The City of Chicago’s Open Data Portal, an initiative to promote access to government information, makes over a thousand raw data sets publicly available online. This allows researchers, technologists, and average citizens to conduct any analysis they want. Online since 2010, the portal has grown to include regularly updated data from every city agency.

Kellogg faculty recently visited the city’s Department of Information and Technology to talk big data on a trip organized by the Program on Data Analytics at Kellogg. Afterwards, Tom Schenk, Chicago’s chief data officer, sat down with Achal Bassamboo, a professor of managerial economics and decision sciences, to discuss the evolution of the portal and how data is driving operational change in the city and beyond.

This interview has been edited for length and clarity.

Bassamboo: Who are the audiences for the data portal?

Schenk: We see a lot of different audiences. Some folks are interested in transparency—city salaries are the most viewed data set. We see academic partners who use that data for research. There are what I call “civic technologists,” who are using that data to provide information or build civic applications. Nonprofits and community groups use that data to help inform what’s happening at the local level. Technologists use it to try to learn how to program and store data. Students and teachers use that data for classroom purposes. Members of the public use it to find out what’s happening around them. A lot of people reference the data portal to look at crimes or other activities like business openings.

Bassamboo: One of the biggest challenges in dealing with big data sets is curating them, making sure that they are properly handled and that there are no mistakes. The amount of effort that is needed to clean even one data set is one thing that people sometimes appreciate only once they have done it. Can you talk about that process for the open data portal?

Schenk: What we publish is the same data that city employees use. We don’t clean the data. We simply extract it and post it to the data portal. Cleaning data can be quite a time sink. Trying to clean data before we publish it would not be as productive as adding data sets to the data portal. Adding a data set increases what the public can do with it.

Bassamboo: You wanted to allow for more opportunities, rather than driving people to use the data in certain ways. How have you seen people using data differently than you might have expected?

Schenk: One novel way is a website called How’s Business Chicago.

On the national level, new home constructions and new business permits are leading economic indicators of where the U.S. GDP might be heading. It’s tougher on the local level.

We publish all the local business permits on our data portal, and How’s Business Chicago uses that data and some statistical analysis to try to give us an indication of where the local economy is going. When you combine that with other indicators, it’s somewhat similar to what we have at the national account levels.

Bassamboo: This open data portal is being used internally by the various departments at the City of Chicago and also by the public. How are the data sets being used internally right now?

Schenk: There was a lot of attention in the press about the difficulty that the City of Chicago was having meeting its obligations to do food inspections. There was a clear opportunity for analytics to help inform those decisions. The Department of Public Health had very progressive leadership that was looking to innovate in a number of different ways, so it was easy to reach out to them and make recommendations about how we could do a better job operationally on a day-to-day basis.

Bassamboo: Can you talk a little bit about that link between having this great information and figuring out how to incorporate that data into action plans?

Schenk: We look for the small changes that we can make and insert crucial parts of information to improve the decision-making process.

It’s important to us when we are doing the research project to minimize the impact on the business process—that is, to not ask too much of the manager. If anything, we want to make it easier for that manager to do her job.

You wouldn’t want the manager to have to come into work an hour earlier to do her job better, right? That’s asking too much. But if she can walk into the office, sit down at her computer, and have pieces of information that she did not have access to before that make it easier for her to make decisions, that works.

Bassamboo: When we talk about operations, the ideal organization works through collaborative effort rather than each department doing it’s own thing. Have you seen scenarios where people or organizations have used the shared data to make better decisions collaboratively?

Schenk: Quite often there are large lines of demarcation between departments. But there are encouraging conversations happening. For instance, the Department of Public Health is using 911 data to look at opioid overdoses, which are an epidemic lately. With that data, the Department of Public Health can be proactive in preventing opioid overdoses, whereas before they didn’t have access to the 911 data, so they didn’t have insight into where those overdoses were happening.

Bassamboo: Are there ways in which you feel open data, and this platform, can increase trust in government?

Schenk: The action of posting data sets makes everything much more transparent and easier to access. In the past, some of this data might have been public in the sense that you could have requested it from us, but now it’s something that you can get on demand.

By making data publicly available, I think you change the type of discourse that you have because you’re being proactively transparent, not reactively transparent. Your trust model changes.

For example, if somebody came up to you and told you some facts about themselves, about their life, without you even having to ask that question, you would be hard-pressed to call that person reclusive. Same thing here. Proactively publishing information makes it harder to say that the government is being reclusive—and that helps increase trust.

Bassamboo: What do you feel is missing right now from the open data portal that you would like to see?

Schenk: There’s so much. There’s so much that we do in the city that we have not yet transcribed on the data portal. We have a lot of nonemergency activities that we need to publish to the data portal. Some of those basic day-to-day services that the city provides—that’s probably one of the biggest blind spots that we have right now.

Bassamboo: With people coming to the public portal and taking that data to use, do you feel that there’s a responsibility to create a forum where their findings or results have an opportunity to be shared?

Schenk: It’s easy to reach out to us by email or by social media to share those results or ask questions. It’s also easy for us to reach out. We are present at community meetings—every Tuesday I’m at Chi Hack Night, which is a meeting of civic technologists who are using the data portal. We also go to meetings with community groups across the city to solicit their input and tell them about what we’re doing. That’s a core principle that we have.

Featured Faculty

Charles E. Morrison Professor of Decision Sciences; Professor of Operations; Co-Director of MMM Program

About the Writer
Fred Schmalz is the business editor of Kellogg Insight.
Most Popular This Week
  1. How Are Black–White Biracial People Perceived in Terms of Race?
    Understanding the answer—and why black and white Americans may percieve biracial people differently—is increasingly important in a multiracial society.
    How are biracial people perceived in terms of race
  2. Don’t Wait to Be Asked: Lead
    A roadmap for increasing your influence at work.
    An employee leads by jumping from the bleachers and joining the action.
  3. How (Not) to Change Someone’s Mind
    Psychologists have found two persuasion tactics that work. But put them together and the magic is lost.
    A woman on a street talks through a large megaphone.
  4. Which Form of Government Is Best?
    Democracies may not outlast dictatorships, but they adapt better.
    Is democracy the best form of government?
  5. How Autocracies Unravel
    Over time, leaders grow more repressive and cling to yes-men—a cycle that’s playing out today in Putin’s Russia.
    autocrat leaning over battle map surrounded by yes-men.
  6. Knowing Your Boss’s Salary Can Make You Work Harder—or Slack Off
    Your level of motivation depends on whether you have a fair shot at getting promoted yourself.
    person climbin ladder with missing rungs toward rich boss surrounded by money bags on platform
  7. Will AI Eventually Replace Doctors?
    Maybe not entirely. But the doctor–patient relationship is likely to change dramatically.
    doctors offices in small nodules
  8. Sitting Near a High-Performer Can Make You Better at Your Job
    “Spillover” from certain coworkers can boost our productivity—or jeopardize our employment.
    The spillover effect in offices impacts workers in close physical proximity.
  9. It’s Performance Review Time. Which Ranking System Is Best for Your Team?
    A look at the benefits and downsides of two different approaches.
    An employee builds a staircase for his boss.
  10. Why Do Some People Succeed after Failing, While Others Continue to Flounder?
    A new study dispels some of the mystery behind success after failure.
    Scientists build a staircase from paper
  11. Four Strategies for Cultivating Strong Leaders Internally
    A retired brigadier general explains how companies can prioritize talent development.
    Companies should adopt intentional leadership strategies since developing leaders internally is critical to success.
  12. Entrepreneurship Through Acquisition Is Still Entrepreneurship
    ETA is one of the fastest-growing paths to entrepreneurship. Here's how to think about it.
    An entrepreneur strides toward a business for sale.
  13. Take 5: Not So Fast!
    A little patience can lead to better ideas, stronger organizations, and more-ethical conduct at work.
  14. Too Much Cross Talk. Too Little Creativity. How to Fix the Worst Parts of a Virtual Meeting.
    Six tools from an unlikely place—improv comedy—to use on your next Zoom call.
    meeting participants improv
  15. Take 5: How to Be Prepared for Important Career Moments
    Expert advice on getting ready to network, negotiate, or make your case to the CEO.
    How to be prepared
  16. Why Do Long Wars Happen?
    War is a highly inefficient way of dividing contested resources—yet conflicts endure when there are powerful incentives to feign strength.
    long line of soldiers marching single file through a field
  17. 2 Factors Will Determine How Much AI Transforms Our Economy
    They’ll also dictate how workers stand to fare.
    robot waiter serves couple in restaurant
  18. What Went Wrong at AIG?
    Unpacking the insurance giant's collapse during the 2008 financial crisis.
    What went wrong during the AIG financial crisis?
  19. 5 Tips for Growing as a Leader without Burning Yourself Out
    A leadership coach and former CEO on how to take a holistic approach to your career.
    father picking up kids from school
More in Leadership & Careers Leadership