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:
What’s the Difference Between Business Intelligence (BI) and EPM?

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:
3 Ways to Tear Down Silos and Boost Your Business Intelligence

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:
Cloud through the ages: 1950s to present day [Infographic]


Chief Analytics Officer Europe

25
Apr
2017
Chief Analytics Officer Europe

15% off with code 7WDCAO17

Read Also:
21 Business intelligence and analytics terms you should know

Chief Analytics Officer Spring 2017

2
May
2017
Chief Analytics Officer Spring 2017

15% off with code MP15

Read Also:
Predicting Wine Quality with Azure ML and R

Big Data and Analytics for Healthcare Philadelphia

17
May
2017
Big Data and Analytics for Healthcare Philadelphia

$200 off with code DATA200

Read Also:
Google Sheets Gets Analytics, Visualization Features

SMX London

23
May
2017
SMX London

10% off with code 7WDATASMX

Read Also:
Big Data is Transforming Commercial Construction

Data Science Congress 2017

5
Jun
2017
Data Science Congress 2017

20% off with code 7wdata_DSC2017

Read Also:
Hortonworks seeks salvation in proprietary software

Leave a Reply

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