Skip to main content

Mikko Puonti: Utilizing continuous delivery significantly saves time in data projects

Tampere University
LocationKorkeakoulunkatu 5, 33720 Tampere
Hervannan kampus, Rakennustalon auditorio RG202
9.12.2022 12.00–16.00
Entrance feeFree of charge
Mikko Puonti henkilökuva. Mies seisoo juhlapuvussa katsoen suoraan kameraan.
Mikko Puonti, M.Sc.Eng. investigated the practices of data projects in his research and brought to them the continuous delivery method used in software development. The goal of the research is to shorten the time from the reporting idea to the finished report. The implementation of the data warehouse is laborious and time-consuming, which is why its implementation work is automated during the research. By utilising testing, we were able to release working transformations and reports for production use in hours instead of weeks.

The development process in knowledge management solutions usually follows the traditional project model, where the desired solution is defined at the beginning and is implemented in iterative work phases.

In software development, new software versions are often released, but the same practicalities that work in software development have not previously been used in data warehousing.

In his dissertation, Mikko Puonti focused on shortening the time needed to implement business intelligence solutions:

"My dissertation is very practical. In the research, we solved practical problems in industry and used the Design Science Research method to evaluate the solutions".

Implementation automation saves time and increases developers' satisfaction

An essential part of the research was to combine data from different systems into one centralised place – the data warehouse.

"The implementation of the data warehouse is the most time-consuming phase of the project. During the research, we implemented a tool for automating the implementation of the data warehouse. It had tremendous meaning. We reached a situation where the developer did the same thing in an hour, which previously took an entire working day", Puonti summarizes.

However, automation alone does not shorten implementation from months to days. The entire organization that uses the information management solution must be involved in the change.

The development process is different when reports are released often. Previously, it was enough that at the end of the project, the customer accepted the project and did acceptance testing. In a new way, testing must be included as one of the stages of the development work.

"It was amazing to see how much more satisfied the report users and their developers were, Puonti says with satisfaction.

Master of Science in engineering Mikko Puonti's doctoral thesis in the field of information technology, Continuous Delivery in Data Warehousing, will be publicly reviewed at the Tampere University's Faculty of Information Technology and Communication Sciences in Rakennustalo auditorium RG202, Korkeakoulunkatu 5on Friday 9 December 2022 at 12 o’clock. The opponent will be professor Pekka Abrahamsson from the University of Jyväskylä. The Custos is professor Hannu-Matti Järvinen from the Faculty of Information Technology and Communication Sciences.

The doctoral dissertation is available online.

Photo: Essi Peltonen