TerraWise, a civil engineering and infrastructure construction company, focuses on work planning and timely quality management, which require a lot of data to support them. But when the data they were collecting wasn't making the most of it, TerraWise partnered with Fluentia to develop a new data management tool.
WhenTerraWise Ltd tried to make use of all the site and financial management data it had collected, it realised that the financial management system was not sufficient. The data could not be bent into forms that could be used for business planning and efficiency.
- We wanted to get more out of project financial management. The information should be easily accessible to all those who need it in their work, and we should be able to visualise it so that we can do better monitoring," says Antti Matikainen, Development Manager at TerraWise.
Software specialist Fluentia joined the project, and Data Architect Tomi and Data Specialist Joonas started working on a new data model for TerraWise. The data needed to be transformed from Lemonsoft's ERP system to a more versatile use. Azure cloud services and traditional SQL were also used in the project.
The end result was a data warehouse and Microsoft Power BI-based reporting. It is used by senior and middle management at TerraWise, as well as site managers, and the data can be used for a wide range of day-to-day tasks.
Financial figures for projects can be monitored in real time, and data can be visualised in different formats. It is also easy to drill down into small pieces of data, such as the execution of a single site.
- Power BI is now our tool for making the most of your data. It allows us to solve problems when they arise. We are also looking for cost savings in the future," says Matikainen.
A huge amount of pre-existing data is now available to support decision-making in concrete terms.
Successful cooperation is one of TerraWise's most important values, and Fluentia has also invested in smooth cooperation. According to Matikainen, the joint project went very well overall.
Matikainen is particularly pleased with the speed with which the Fluents were caught up during the project. On a practical level, everything went smoothly even when software development was at its peak.
- We try to communicate with a low threshold. The TerraWise employees involved in the project were very active themselves," says Joonaskin.
Although the project has now come to a successful conclusion, work will continue well into the future. There will certainly be new uses for Data that will allow us to create a whole new competitive advantage.
Fluential is also pleased not only with the excellent cooperation, but also with what was achieved in the project.
- The fact that our customers get business benefits from our help is the most important thing for us," says Head of Sales Timo Helppi.
