University of Jyväskylä

The new reporting portal is based on Microsoft Power BI, which was set up and taken into versatile use together with Pinja.

Brief summary of the project

Leap forward

In 2020, the University of Jyväskylä took a significant step forward in its path of knowledge management when it introduced a data warehouse reporting portal.

Implementation

In the first phase of implementing the new reporting portal, the University of Jyväskylä introduced the study progress report of master’s and bachelor’s degree students, the study progress report of doctoral students, and project portfolios for the application stage of supplementary funding.

Transferring knowledge

The goal of the project was not only to introduce a new system but also to transfer knowledge and deeper understanding of Power BI from Pinja to the University’s own staff.

I appreciate the fact that we have been able to utilize the extensive knowledge and experience Pinja has accumulated.

Jenni Kokko, Data Analysis Specialist, Jyväskylä University

Project information

2020 the system was deployed

1 year duration of the deployment project

over 5 key user groups

The challenge: Real-time external and internal reporting

In Universities, both external and internal reporting are an important part of knowledge management. Real-time numerical data and progress reports are very useful for monitoring and management at university level, as well as in every smaller unit, from departments to subjects, separate institutes and projects. The reports will be of particular importance in monitoring key information affecting the core funding provided by the Ministry of Education and Culture.

In the first phase of implementing the new reporting portal, the University of Jyväskylä introduced the study progress report of master’s and bachelor’s degree students, the study progress report of doctoral students, and project portfolios for the application stage of supplementary funding. In the second phase, financial and personnel reporting, reporting on international staff mobility and a management dashboard will be introduced. The University has several key user groups, including unit management, controllers and project secretaries, as well as education coordinators and research developers.

The solution: Pinja’s operating model ensured a smooth and fast implementation of Power BI

The University of Jyväskylä selected Pinja as its Power BI partner through public tendering. The most important selection criterion was quality, and this proved to be a clear strength for Pinja.

The deployment project, which started in January 2020, was completed in December of the same year. During the year, a foundation was constructed, the availability of the necessary source data was ensured, the necessary data models were prepared and back-end servers were set up. Careful groundwork with definition steps ensured that the portal works reliably and comprehensively, also in the long run.

– The cooperation with Pinja has been really good all the time, and the communication has remained excellent, despite the coronavirus. In the cooperation, I appreciate the fact that we have been able to utilize the extensive knowledge and experience they have accumulated. They have guided us through proven practices, so we avoided reinventing the wheel – and this was our original goal, says Data Analysis Specialist Jenni Kokko, who worked as a project manager for the University of Jyväskylä’s Power BI implementation.

The goal of the project was not only to introduce a new system but also to transfer knowledge and deeper understanding of Power BI from Pinja to the University’s own staff. In 2021, the focus will shift to the sharing and transfer of knowledge, and the University’s own staff will gradually take overall responsibility for maintaining and expanding the use of the portal.

– Our cooperation agreement was originally for 1+1 year, and we came to the conclusion that we definitely want to use the optional year as well. We have received valuable feedback from Pinja about our own development work and also excellent ideas for things we did not have any previous experience in, Kokko says.

Knowledge is for all

The ERP of a University has certain special features that differ from the business world, which set their own framework for the work community’s activities. Still, the activities must be streamlined and productive.

– University researchers have the freedom to choose their own research objects and methods, and this is an important value for us to cherish. However, while protecting independence, we must also ensure the basic conditions and the financial basis for the activities. This type of coordination is one thing that we here at the university’s Division of Policy & Planning do, Kokko says.

The education and research communities must also invest in efficient operations, monitoring the right indicators and the continuity and timeliness of reporting. Universities have their own key role to play in the full transition to a digital society.

The University of Jyväskylä has already used data warehousing and reporting tools in the past, but the introduction of Power BI means a significant step towards more comprehensive and real-time knowledge management. With the help of the reporting portal, the University compiles reports relevant to each user group, the content and outlook of which are planned together with the target groups.

The portal reduces the amount of manual work, monitoring becomes real-time and the understanding of the cause-and-effect relationships of different matters improves.

– The main reason for the transition was that we wanted to make relevant information directly available to everyone in need. That is why we are talking about data-informed decision-making instead of knowledge management. This better illustrates the dissemination of information to the wider community. For example, in order to steer activities in the desired direction, profit-making units need to have access to data related to financial models in an easily understandable and manageable form. It must also be possible to monitor progress and changes in key figures continuously, Kokko states.

Jyväskylä University in a nutshell

3 200+ Publications

14 000 Students

2 600 Staff

3 Centres of excellence in research (2021)

202 M Funding (2020)

Similar success stories

Jydacom

Jydacom Oy is a software house specializing in the system needs of construction companies. The secret of Jydacom’s success is…

HUS

The main goal of the development work has been to form a clearer and more comprehensive overall picture of the…

Betset

The latest link in the company’s continuous development is the Power BI solution, implemented with Pinja, which was introduced in…

HUS

The visual presentation of information on the reports influences the decision-making within the organization at many different levels.

Diak

Pinja developed a solution to collect data from the My Diak student management system, the most central data source for…

Spinnova

"We have cooperated with Pinja in an information management project related to our specific needs”, says Sanna Haavisto at Spinnova