20150709wrightstate1

Getting Smart About Business Intelligence

Getting Smart About Business Intelligence

 

Wright State University revamped its approach to data and built a self-service BI tool that puts powerful drill-down capabilities in the hands of users across the university.

For any college or university that has experienced the challenge of implementing a campuswide business intelligence (BI) initiative, the experience of Wright State University (OH) should be an inspiration and a reminder not to give up too easily.

Five years ago, Wright State made investments in an enterprise data warehouse, operational data store and the Cognos reporting tool from IBM. But the technology's potential was never fully realized. Cognos ended up being used as a static reporting mechanism, meeting various state reporting obligations as well as some day-to-day reporting needs of the university — but not operating as a true BI tool.

Then in 2013, Wright State began transforming its budget model to one that emphasized entrepreneurialism and innovation, and the need for BI tools became more pressing. "We realized that in order for that model to be successful at the unit level, we needed to provide the tools for people in a self-service approach," said Mark Polatajko, vice president for business and finance and chief financial officer for the university. "We realized that this underutilization was driving the manner in which we work. We have a lot of analysts' time and effort focused on the compilation and development of reporting instead of the value-added aspect of emphasizing analytics."

Read Also:
5 Key Roadblocks to Data-Driven Healthcare

The first step, a gap analysis, found several problems that had to be addressed, he said. First, users were frustrated with errors due to inconsistent report setups. Reports created to analyze similar information could bring back very different results because they used different underlying algorithms that are not transparent to the user. Users also felt an urgency to get the data, yet they were dependent on Wright State's limited number of data specialists for help. That increased the workload of the data specialists and slowed the turnaround time for data-related requests. Frustrated by these roadblocks, users often created their own databases — essentially Excel files housed on their computer desktops. A significant amount of time and energy was spent on maintaining these databases rather than performing data analyses.

"We realized that it is crucial that this be self-service," Prabhala said. "More importantly, you have everyone looking at a single version of the truth."

Following a thorough assessment of user needs and technology capabilities, Prabhala and his team identified three focus areas (student, finance and human resources); four key performance indicators (KPIs) for each of the focus areas; and the corresponding attributes for each of the KPIs. For example, the KPIs for the student focus area are application, enrollment, retention and graduation. For an initial pilot, the BI team worked with leadership from the college of business, college of engineering, institutional research and enrollment management. "We quickly realized there was a lot of momentum and others wanted to jump on board as quickly as possible, so it was sort of a self-fueling fire," Polatajko said.

Read Also:
Open source data visualization tool by Airbnb: benefits and limitations.

Once the results of the pilot were shared with the council of deans and the cabinet, the project team decided it was time to broaden the scope across the university and emphasize development of key dashboards and analytics with data-mining capabilities.

The Wright State executives see the BI initiative a foundational building block that will allow them to do more advanced analyses and predictive modeling in the future. That has become increasingly important because Ohio is the first state in the U.S. for which 100 percent of its universities' funding formula is based on course completion and degree completion.

"Retention and getting people to the finish line is of the utmost importance, so we are aligning our activities, our data analytics and our systems in order to drive course completions, retention of students and degree completion," Polatajko said. "When we do that successfully, we are getting rewarded in terms of our share of the state operating funds we get to fund our activities. That is huge."

Read Also:
​Can Oracle become a public cloud power?


Data Science Congress 2017

5
Jun
2017
Data Science Congress 2017

20% off with code 7wdata_DSC2017

Read Also:
4 new job roles for the digitized, big data-fueled, cloudified enterprise

AI Paris

6
Jun
2017
AI Paris

20% off with code AIP17-7WDATA-20

Read Also:
Big data's big role in humanitarian aid

Chief Data Officer Summit San Francisco

7
Jun
2017
Chief Data Officer Summit San Francisco

$200 off with code DATA200

Read Also:
The Full Spectrum: How a Visual Analytics Platform Empowers the Business

Customer Analytics Innovation Summit Chicago

7
Jun
2017
Customer Analytics Innovation Summit Chicago

$200 off with code DATA200

Read Also:
How data can inspire creativity

HR & Workforce Analytics Innovation Summit 2017 London

12
Jun
2017
HR & Workforce Analytics Innovation Summit 2017 London

$200 off with code DATA200

Read Also:
5 Key Roadblocks to Data-Driven Healthcare

Leave a Reply

Your email address will not be published. Required fields are marked *