Reinventing Decision-Making With Data for All

Looking to better serve its 115,000-plus student population, the City Colleges of Chicago system built a "data democracy," empowering all faculty and staff with a flexible reporting and analytics system.

2014 Campus Technology Innovators Awards

Category: Administrative Systems
Institution: City Colleges of Chicago
Project: OpenBook
Project lead: Brendan Aldrich, executive director, data warehousing services

Tech vendor/partner: ZogoTech

At the City Colleges of Chicago, key strategic priorities revolve around data: empowering all 5,800 employees of the college with access to a fully interactive reporting and data analytics system.

These priorities came about through a widely understood need for change. The City Colleges of Chicago is a large system, with seven community colleges, six satellite facilities, a center for distance learning, a culinary institute, two owned and operated restaurants, a public radio station and a public TV station. Educating about 115,000-120,000 students each year, it's the largest community college district in the State of Illinois and one of the largest in the country, yet graduation rates had dipped to about 7 percent per year.

City Colleges of Chicago OpenBook Team
The OpenBook leadership team (photo courtesy of ZogoTech)

To address these challenges, Chancellor Cheryl Hyman founded a program called "Reinvention" about four years ago. A continuously rotating group of about 100 administrators, faculty and staff came together, each for a term or two, to take on the problems of the institution. They were charged with identifying and characterizing the ways in which the organization was operating and serving its students, identifying best practices and putting positive change in motion.

One of the main ideas that came out of the "Reinvention" initiative was the need for data in order to do any kind of meaningful analytics for decision-making. At the time, City Colleges did not have a data warehouse or any kind of centralized reporting system. Reports were pulled from the college's front-end PeopleSoft system, or from other shadow IT systems that had cropped up over the years. The colleges brought in Brendan Aldrich, who had worked on several data warehouses for large organizations, to lead a project to establish better access to data throughout the colleges. Aldrich focused on the idea of building a "data democracy" — so that everyone could have the data they need — and took the job of executive director, data warehousing services for the City Colleges of Chicago. Work on the new data warehouse began in November 2012. In the spirit of "Reinvention," data warehousing and analytics were put in place that would completely reinvent the way the colleges used information. City Colleges of Chicago officially launched the system, "OpenBook", in September 2013.

OpenBook's data warehousing and analytics services are built on technology from ZogoTech. The system's innovative functionality is geared toward empowering all employees: Reporting is re-invented by the elimination of "static" reports, replaced by fully interactive reports where all elements can be changed with drag-and-drop simplicity to answer evolving questions. A Student Navigator enables on-the-fly student analytics, and dynamic data environments ensure that each employee has truly relevant data across multiple roles at his fingertips. Complete data dictionaries with full definitions, samples and notes are available within every report and integrated "just-in-time" training provides on-demand videos to demonstrate OpenBook's functionality for users of all skill levels.

The system is structured by "user views," so that data is filtered according to user needs, noted Nancy Lee Chavez, associate vice chancellor, decision support at City Colleges of Chicago. "If I'm a faculty member, for example, I'm seeing all the data on the students I am teaching, plus the students I have taught in the past — and I'm not just restricted to the 'past' records, as I can also have the ability to look forward and see the students I have taught and how they are doing in their current coursework."

City Colleges of Chicago is now working to fully integrate OpenBook into day-to-day operations across district, college, program, department and faculty areas, with the goals of increasing student retention, accelerating student success in declared programs, facilitating progress on developmental education pathways and helping adult education/GED/ESL students transition to college-level coursework. But perhaps more than anything else, the OpenBook project has brought a renewed vision of what the colleges can be doing with data, now and going forward.

For more information on the Campus Technology Innovators program, visit the awards site.

About the Author

Meg Lloyd is a Northern California-based freelance writer.

Featured

  • illustration of a futuristic building labeled "AI & Innovation," featuring circuit board patterns and an AI brain motif, surrounded by geometric trees and a simplified sky

    Cal Poly Pomona Launches AI and Innovation Center

    In an effort to advance AI innovation, foster community engagement, and prepare students for careers in STEM fields and business, California State Polytechnic University, Pomona has teamed up with AI, cloud, and advisory services provider Avanade to launch a new Avanade AI & Innovation Center.

  •  black graduation cap with a glowing blue AI brain circuit symbol on top

    Report: AI Is a Must for Modern Learners

    A new report from VitalSource identifies a growing demand among learners for AI tools, declaring that "AI isn't just a nice-to-have; it's a must."

  • glowing shield hovers above a digital cloud platform with abstract data streams and cloud icons in the background

    Google to Acquire Cloud Security Firm Wiz

    Google has announced it will acquire cloud security startup Wiz. If completed, the acquisition — an all-cash deal valued at $32 billion — would mark the largest in Google's history.

  • digital dashboard featuring a shield icon, graphs, a world map, and network nodes

    IBM Introduces Agentic AI Governance and Security Platform

    IBM has launched a new software stack for enterprise IT teams tasked with managing the complex governance and security challenges posed by autonomous AI systems.