Steveco

We helped Steveco, the largest full-service port logistics company in Finland, optimize its operations by creating a modern BI data platform and reporting system that meets both business and user needs.

THE CHALLENGE

To manage and develop its cargo handling and transporting services efficiently, Steveco needs accessible and up-to-date information covering and combining assets, logistics and financials. Its legacy BI system had become outdated in terms of technology and usability: only a few people had access to the data, gathering the required information was difficult, reports had to be produced manually and the system was reaching the end of its lifecycle. As the data couldn’t be used systematically, its potential was lost. Managing the legacy system was expensive, too. Three goals were set: to create a scalable, secure and well-documented cloud data platform that provides coherent and uniform data to all users; to enable the users to create the business reports themselves; and to provide users with the first reports to let them explore new possibilities.

To ensure the right starting point for the system overhaul – meeting business and user needs – we first ran a data sprint with Stevecos’ business owners and IT specialists. The aim was to first form an understanding of the current state of the organization's data and analytics landscape and then define the target state as well as the concrete steps needed to get there. The data sprint was crucial in ensuring we focus on technical solutions that push the business agenda forward.

As an outcome of the sprint, we defined the goals, calculated the Return-on-Investment (ROI) and created the roadmap as well as the technical plan for the implementation. We built a serverless Azure cloud-based data platform and the data warehouse solution containing the data models. An important technical aspect in the implementation was to ensure that all the Stevecos’ IT systems would work fluently with the new platform, whether they are located at the local server rooms or on the cloud. Demo sessions among the development team were held every other week, ensuring the right direction and knowledge sharing early on in the project, so a Thinnest Viable Platform (TVP) that includes all the critical functions initially needed was created efficiently. To make the cloud transformation and further development as smooth as possible for Stevecos’ developers, we used technologies that were familiar to them, such as dimensional Kimball data modeling and SQL-based transformations as well as a low-code approach utilizing ELT solution with Azure Data Factory. The data monitoring features were developed to be integrated into Microsoft Teams.

We also designed report layouts in a user-centric way, ensuring the information is represented in a clear and useful format to support the users in decision-making and provided the first reports as an example.

The business and user driven development process ensures the new data platform helps Steveco manage its operations more efficiently. The business owners now get clear reports and valuable insight that help them make decisions – and they can also tailor new reports themselves. Since producing the reports requires no manual work, Stevecos’ IT and financial staff can concentrate on their core work. This means savings in time and money, improved results and a more meaningful work experience.

By using a cloud environment, Steveco pays only for the data resources it needs, generating significant savings in system infrastructure, maintenance and licensing costs. The scalable platform supports modern agile development methods that help ensure future needs are met cost-efficiently, step by step and without major capital investments. System maintenance is mostly handled by the cloud provider and the creation of the BI reports is no longer in the hands of a few people. The Azure cloud platform offers better and more cost-effective security features. By using technologies familiar to Steveco, we ensured they can develop the platform independently in the future.

Highlights

A comprehensive delivery with a business and user driven approach: cost-effective and secure data platform that helps make the right decisions.

Continuous savings in time and money: no manual work, less system-related costs.

A smooth cloud transition and independence in further development: familiar technologies were used.

Working with Pegasus InfoCorp was easy and the challenges during the project were tackled quickly. We now have a solid start and a good basis to further build our reporting on the PowerBI platform. Our journey with PowerBI has just begun.

Client Testimonial
Steveco Group