Skip to content

Cloud-based reporting with Power BI and Azure Data Warehouse

Customer story

twoday designed and implemented a new reporting and data warehousing system together with Savox Communications. The system gives quick and easy access to up-to-date information, which creates significant benefits to business-related decision-making.

The Challenge

Savox Communications designs and manufactures communication and hearing protection solutions for professional use. The company has grown strongly both organically and through acquisitions in recent years. Growth has also brought challenges, as different units used different systems, with information scattered across them. To initially solve this, the company started by laying a solid foundation and unifying the systems in use.

However, unifying the systems did not yet solve the challenge of retrieving and combining information from different systems, which was time-consuming and complex. Visibility into their own business and its components was not at the desired level despite the changes. The information could not be utilized in different areas of the business as much as desired and is now possible. 

"At that point, we saw that there was a need to build a reporting platform on top of the production control system," says Terhi Rantala, the executive responsible for Savox Communications' operational activities.

savox-header

The Solution

The need for a reporting environment that met current business needs and the capability to monitor the business was identified in the company, and we jointly set out to solve it. We quickly found a common ground from the beginning, and twoday's experience in building reporting tools and dashboards was convincing.

From the start, we created a new reporting environment for Savox Communications using Power BI technology. Under this reporting environment, we built an Azure-based data warehouse. So, it is a fully cloud-based reporting and data storage solution.

We built the solution iteratively, in stages, and created dashboards for different management areas to meet their needs. In the first phase, we focused on getting sales figures easily compiled at a global level within the company. In the next phase, we implemented the same for warehouse management and purchasing. We are currently implementing financial reporting.

The collaboration has been agile, moving forward in small steps at the pace the customer desires. When improvements have been identified, the work has been expanded piece by piece. According to Rantala, twoday's approach was appealing from the beginning, and it felt like Savox Communications was also getting the much-needed added value.

"We have received good suggestions and it has genuinely felt like there is a desire to find a sensible way to implement things together. The consultants have been skilled, and the continuity and sharing of knowledge within the team during the project have been well taken care of. In addition, communication has worked well at all levels, and it has been active on both sides," says Rantala.

"On several occasions, we have discussed internally that we chose the right partner at the beginning, and we still believe that." 
Terhi Rantala, executive responsible for Savox Communications' operational activities

The Value

As a result of the project, visibility into business data has improved on many levels within the organization. Now, it is possible to access the required information directly, which of course helps in decision-making. For example, the management team can see the current status at any time and, if desired, examine the details. Reports are now user-friendly, easy to read, and up-to-date.

The right information is thus available at the right time to support decision-making. In addition, the amount of manual work has been significantly reduced, and the saved time can be used for business-supporting tasks instead of collecting data.

"In this collaboration, we have genuinely challenged each other and made use of the lessons learned from other similar projects. This has been a very big and essential aspect of our cooperation and has even exceeded expectations," says Terhi Rantala.

Contact

Could we help accelerate your company's data-driven decision-making and business development?