In just one month, Bryant & Stratton used a business intelligence tool to create a dashboard view of its operations out of previously siloed enterprise databases.
For higher ed institutions, gathering data is the least of their problems—the stuff is coming out of their ears. The real challenge lies in sifting, organizing, and analyzing that data to produce actionable knowledge and insights. It’s a problem that Bryant & Stratton College solved in short order when it launched a dashboard-based business intelligence tool in just one month.
The for-profit college, which has 18 campuses across four states plus an online campus, wanted to use the data from its enterprise systems to help track and improve key business metrics. The problem was that much of the data resided in siloed transactional databases in several different systems. “Back in 1998, the college made the decision to go with best-of-breed applications, but we had no centralized reporting system,” said John Grieco, IT director for Bryant & Stratton, which uses Oracle EBS for its financials, Banner for its student information system, and Oracle CRM On Demand for admissions and marketing. “Our goal was to have a central repository of data with one reporting system that could take the data from all these disparate systems, join them together, and put them out in a meaningful manner.”
To realize this goal, the college selected QlikView, a tool that gives clients the ability to pull data into customized dashboards and reports—and the flexibility to slice and dice that data to create new reports as needed. The school signed the contract in mid-March 2015, conducted training in the last week of March, and had its first application up and running on April 24.
Achieving Rapid ROI
IT shops are always under pressure to show a rapid return on investment, but that pressure may be even higher at for-profit institutions. “From an IT standpoint, you have to be able to deliver a benefit very soon after the purchase—you want to make sure the college sees the value right away,” said Grieco. To that end, IT first rolled out an application for student-enrollment reporting, followed a month later by a student-demographics application. “Now our various campuses can see the enrollment numbers for our new and continuing students, and then can break them down by demographics and by academic program to get a better understanding of the student body,” said Grieco.
Not only did the new dashboard reports give administrators greater awareness of where the college stood with respect to its enrollment goals, but the savings in staff time were dramatic. “Our institutional assessment group used to take a week after the start of the semester to accumulate the information for the final student numbers—that time has been eliminated,” said Grieco. “The campuses would also work for another week on the demographic information, which the system creates automatically now. They no longer have to run a report through the system office and disseminate it to each of our campus directors, because the directors can see it all on the dashboards when they sign in every morning.”
The ability for administrators to get real-time updates about enrollment is key at a for-profit college like Bryant & Stratton, which has a recruiting period for each semester and accompanying goals. “At any point, administrators can tell where they stand against budget and where they stand against the projections for the upcoming semester,” said Grieco. “That is something they didn’t really have a good handle on previously.”
(Next page: Understanding the data)