Back in 2012, Michael Hansen had a dream: To open access to data, making information available to all Oregon State University (OSU) employees, dependent on their need to know and based on their job duties.
Today, that dream has come true.
“Rather than have each unit doing its own thing, we sought to standardize and open up access to everyone on campus,” says Hansen, OSU’s director of the business intelligence center in Corvallis. “Access went from about 900 people to almost 7,000. Rather than having to go to an individual in your department for information, you can get it yourself.”
Prior to 2012, the institution lacked standardized reporting across the 30,000-student campus. “Everybody came up with his or her own reports,” he explains. “Every department and college would create its own reports and numbers based on its metrics, which were correct for each of its own operations, but didn’t match another college’s operation. Once you put all these reports together, none of them matched our numbers for the university. We needed to standardize reporting across the university so that everybody understood what the data meant and [what] metrics the university would use to make decisions.”
About the same time, Lois Brooks, vice provost and chief information officer, attended meeting after meeting where participants all had “an incredible hunger for operational data and information to manage the university and ensure student success,” she recalls. “As I sat through conversation after conversation about what we were trying to achieve with our programs, the question of data kept coming up. It occurred to me that if we could get data to people’s fingertips—and they could trust that the data were accurate—we could really transform the conversations we were having.”
Both Brooks and Hansen soon became transformative leaders in the resulting Cooperative Open Reporting Environment (CORE) initiative, which was recognized with a NACUBO 2015 Innovation Award. “We spent about four months in information technology, planning our architecture before we actually wrote a line of code,” Brooks recalls. “We really sat back and looked at what we already owned, where the data came from, how it would flow, and who needed it. We then walked the plan by security, audit, and other key stakeholders to make sure that they felt comfortable with where we were going.”
To keep the project affordable, OSU relied on existing technology and an open source system. “The entire incremental spend on this has been $36,000,” Brooks says. “All of it was done with existing staff by understanding where we had the expertise and tapping people to say, ‘We need you to work on this now.’”
The business intelligence center development team consists of six handpicked developers and analysts, plus Hansen, who put the hodgepodge of systems together and built the reports needed to make everyday decisions. “We took the approach that data, no matter where it resides, is a university asset,” Hansen says. “Therefore, we would all have access to data, depending on our roles, rather than keeping all the data stored in silos.”
To accomplish this, the business intelligence team merged the disparate information sources involving finance, students, HR, and payroll into a central data warehouse and then added housing, auxiliary, and foundation facts and figures to the mix. “Rather than having a warehouse that was strictly Banner data, we have a warehouse with data from many, many sources,” he says.
A Standard Reference
After its fall 2013 rollout, CORE fundamentally changed the way campus units use information, explains Sherman Bloomer, director of budget and fiscal planning. “We’re seeing units, both academic and business, using the reports generated by the CORE group as the standard reference for measuring anything you can think of—from credit hours to majors to expenditures. Student affairs is using it to identify students at risk.”
For example, he says, if a unit is struggling with balancing a budget, he can now sit at his desk and pull up a standard way of looking at the unit’s expenditure patterns, history, and anomalies relative to this year versus the last two years. Prior to CORE’s rollout, he would be sorting through spreadsheets.
“We use the information in how we budget so that we have a consistent way of comparing units in terms of how many credit hours they generate, how many majors they have, and how many credit hours they teach for students outside their college,” he says. “This is an institutional resource, not owned by any particular group, which makes it possible to have common information to make decisions. People have confidence that what Michael and his team have produced is an accurate representation of their units, which saves a tremendous amount of time in working through problems.”
With more than 600 reports, dashboards, and visualizations to choose from, users have already collected favorites. Class roster reports are popular, especially at the start of the term, explains Jeff Merth, business intelligence analyst, because of the hyperlinks. “You can click on the instructor and see what he or she is teaching this term or any term,” he says. “You can click on a student and see his or her schedule for the term. When you see the schedule, there are more hyperlinks.”
Student profile reports have also proven popular because they consolidate information that used to be spread across two or three other systems. “Advisers campuswide have latched onto this report because it shows in one place a student’s name, address, phone number, current class standing, and GPA, as well as where he came from, if she transferred, and all grades in all classes,” Merth says.
Not Without Challenges
Although CORE team members now daily churn out detailed reports with apparent ease, the mission to open access to data at OSU was not accomplished without challenges.
“We had a number of kumbaya moments,” Brooks says. This usually occurred once people realized that they would get to see not only more information—but everyone would be able to view their previously protected storehouse of statistics. They then wondered, “Do I want everybody to see that data? Is my job threatened because it’s my job to hand out that data?”
During the process, Brooks admits she learned how incredibly important governance is to this process. “Part of the change is the decision-making structure of who gets to see what,” she says. “You need to have a formal way in which those decisions are made.”
Bloomer believes data control and access were probably the most difficult issues to overcome because departments interpreted FERPA rules locally, sometimes coming to conclusions that were overly restrictive or permissive. Changing that was largely a matter of conversation and education, although once in a while, a manager was told, “I’m sorry, but you’re not in charge of that anymore.”
“Fortunately, we didn’t have very many of those,” Bloomer acknowledges.
In addition to access rules, the subject of shadow systems occasionally arose in the early days. “Some people were hesitant to give up historical practices,” Bloomer says. “By and large, we took the approach that you could keep running shadow systems, but they wouldn’t be the system of record, and they wouldn’t give you the right answer. People let them die because they weren’t useful anymore.”
For Jeff Merth, who developed the behind-the-scenes database, the biggest challenge was to make the system so easy that someone could sit down and use it with very little training. First-time users can go to the quick-tips page, which tells them how to run reports, how to export them to a PDF or Excel, and how to contact the CORE team.
“With CORE, we deliberately kept it very simple, and we have tips or hints that will pop up for first-time users,” he adds. “We have video help so that instead of reading manuals or documentation, you can sit down with a two-minute help video that explains some aspect of the system.”
Another challenge: Once all the data were consolidated, it became apparent that cleanup needed to become a priority. “There had been errors in the data all along,” Brooks says, “so the business office, the registrar’s office, HR, and finance made an effort to clean up the data and to retool business processes to catch errors on the way in. Data only hold value in as much as they are available, actionable, and true.”
In Merth’s opinion, developing a custom interface and embedding OSU reporting, rather than just going with the stock product “and being stuck with whatever,” was a differentiator that he recommends to other institutions. “We have been able to make the interface look, feel, and behave the way we want it to.”
The interface, he says, is a custom Web application designed and built using Visual Studio and other Microsoft technologies. “You can access CORE anywhere in the world that you have a browser available. People access CORE from home or from our research vessels at sea. If you need to know what the current balance of one of your grants is, you can pull up CORE while out in the ocean.”
Other advice from Oregon State University leaders includes:
- Offer training. The business intelligence team participates in several campuswide training days on CORE throughout the year and offers individual instruction as requested. “We will go out to any unit on campus, no matter how big or small, and present customized training,” Merth says. “We also have people stop by the office and say, ‘Hey, I need a little help.’ Then we work one-on-one with people.”
- Determine consequences. “When you make a lot more information available—and appropriately available—the chances of somebody doing something inappropriate do change,” Bloomer says. He advises institutions to discuss how to hold people accountable—and what the consequence would be—for unauthorized access or misappropriation of data. “You need senior leaderships saying, ‘Yes, we endorse this. This has our seal of approval.’”
- Involve users. At every step, the business intelligence team lets users know they are part of the development process and that their input greatly influences the outcome. “Wherever we go, Michael always says, ‘This is your system. We’re designing it for you, so please let us know how you want it to work.’”
In fact, a feedback loop is built into CORE. If users are in the system, and notice that a report could be improved by adding a particular field, they simply push a button, and type in “Please add this field.” The request— including all the information about the report, who the user was, and the parameters they ran—goes directly to the business intelligence team and gets triaged.
“We can see exactly what they were looking at and decide if [the request is] possible,” Hansen says. “There may be restrictions on the data that don’t allow it, but in most cases, we can make the change and send it back.”
- Select visual software. To create the reports, members of the business intelligence team use SQL Server Reporting Services, to which they already had access because of OSU’s sitewide license for Microsoft software. “We bought Jaspersoft, which is a Web-based tool that you use to drag and drop your rows and columns on a page, and it makes a report for you,” Merth says. “We were able to embed that in the CORE interface as well.”
- Keep on keeping on. “If you decide to go down this road, you have to be persistent,” Hansen insists. “Keep moving forward, and improving and adapting the system to user needs. Your reports can never become stagnant.”
The Next Step
Although she “donated” three staffers to the CORE team, Brooks doesn’t worry if she will ever get them back. “I don’t think of it that way,” she says. “This is a strategic IT project for the university. Technology is not the reason we exist, but it does have the power to transform the university. We’re aggregating data now with strategic implications. We are understanding things we never could before.”
The goal is student success, which Brooks compares to an ocean with different tributaries of data and activities feeding into it. “Amassing all the data is the first step. We can now see very clearly, for example, our wait list and when it is time to open up more courses. The next generation of analytics will be to understand more fully how each of these tributaries affects or does not affect student success. For example, are students who study abroad more likely to graduate on time? Or what influences a student’s migration through changing majors?”
She anticipates that OSU’s next step will be more sophisticated modeling, folding in predictive analytics with historic analytics to better forecast the recipe for student success. “That’s the core business of our university. It’s hard to envision much that is more important.”
MARGO VANOVER PORTER, Locust Grove, Va., covers higher education business issues for Business Officer.