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. Take 5: Research-Backed Tips for Scheduling Your Day
    Kellogg faculty offer ideas for working smarter and not harder.
    A to-do list with easy and hard tasks
  2. Why Are Products Marketed to Women Sometimes More Expensive?
    A new study upends popular assumptions about the “pink tax.”
    woman shopping for shampoo
  3. 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
  4. Will AI Eventually Replace Doctors?
    Maybe not entirely. But the doctor–patient relationship is likely to change dramatically.
    doctors offices in small nodules
  5. Most Employees Retaliate If They're Slighted at Work
    Here’s how managers can break the cycle of office conflict.
    When targeted with negative behavior at work, employees are most likely to retaliate.
  6. Podcast: How to Discuss Politics When You Disagree
    Talking politics in this polarized climate is a dicey proposition. On this episode of The Insightful Leader, an expert in the psychology of persuasion offers tips on how to approach the topic constructively.
  7. How to Manage a Disengaged Employee—and Get Them Excited about Work Again
    Don’t give up on checked-out team members. Try these strategies instead.
    CEO cheering on team with pom-poms
  8. 3 Things to Keep in Mind When Delivering Negative Feedback
    First, understand the purpose of the conversation, which is trickier than it sounds.
    woman crossing rope bridge
  9. What Happens to Worker Productivity after a Minimum Wage Increase?
    A pay raise boosts productivity for some—but the impact on the bottom line is more complicated.
    employees unload pallets from a truck using hand carts
  10. Which Form of Government Is Best?
    Democracies may not outlast dictatorships, but they adapt better.
    Is democracy the best form of government?
  11. 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
  12. What Went Wrong at AIG?
    Unpacking the insurance giant's collapse during the 2008 financial crisis.
    What went wrong during the AIG financial crisis?
  13. Take 5: How to Be a Better Mentor
    Be sure your mentee “owns” the relationship—and don’t shy away from tough conversations.
    Companies should adopt intentional leadership strategies since developing leaders internally is critical to success.
  14. How Peer Pressure Can Lead Teens to Underachieve—Even in Schools Where It’s “Cool to Be Smart”
    New research offers lessons for administrators hoping to improve student performance.
    Eager student raises hand while other student hesitates.
  15. Immigrants to the U.S. Create More Jobs than They Take
    A new study finds that immigrants are far more likely to found companies—both large and small—than native-born Americans.
    Immigrant CEO welcomes new hires
  16. How Closely Do Our Beliefs About Social Mobility Match Reality?
    The answer differs between Americans and Europeans, and between liberals and conservatives.
    Socioeconomic divide on the same street.
  17. For Students with Disabilities, Discrimination Starts Before They Even Enter School
    Public-school principals are less welcoming to prospective families with disabled children—particularly when they’re Black.
    child in wheelchair facing padlocked school doors
  18. Why Well-Meaning NGOs Sometimes Do More Harm than Good
    Studies of aid groups in Ghana and Uganda show why it’s so important to coordinate with local governments and institutions.
    To succeed, foreign aid and health programs need buy-in and coordination with local partners.
  19. How the Wormhole Decade (2000–2010) Changed the World
    Five implications no one can afford to ignore.
    The rise of the internet resulted in a global culture shift that changed the world.
More in Data Analytics Strategy