NIRAS 'new data warehouse with Power BI ensures an overview of the entire business

NIRAS new data warehouse with Power BI 

gives them an overview of their entire business

Morsø bruger aktivt targit løsningen fra Accobat
Large projects require a sharp overview. Especially when it comes to your finances. Therefore, NIRAS decided to implement a dynamic dashboard in connection to the launch of a new ERP system; Maconomy.

The new dashboard is used for management information with a focus on graphical presentation and a greater opportunity to look ahead through forecasts and by going from a general level and then “drill down” to the individual appendix.

Watch the video below where Lone Berg-Olsen, Responsible Business Intelligence Development at NIRAS, tells us about their experience:

”I think that our Management Dashboard is in a uniform and attractive design, we have fast performance, and we have great flexibility when it comes to selections, sorting, and thereby many analytics opportunities across our business units.”


- Kresten Kloch, CFO, NIRAS

”Currently, we primarily use our solution for line management reporting – our internal reporting on performance, cash flow, and backlog development for all companies – both the ones on our collective ERP system and the smaller companies outside of our collective ERP,” Lone Berg-Olsen, Responsible Business Intelligence Development at NIRAS, explains. She has been the internal project manager during the entire process.

“Additionally, we have created multiple other reports and dashboards which support the management dashboard, for example, the management dashboard which gives us information about the composition and the development in our project portfolio within, among others, customers and project types.”

Before NIRAS had created the data warehouse with Power BI on top, they used Qlikview and SAP Business Objects as BI tools as well as performing manual reporting in Excel. Especially Business Objects was challenged on performance when it comes to the reporting, Lone Berg-Olsen explains: “Our new data warehouse now extracts data from our ERP system Maconomy, employee data from our HR system CatalystOne as well as uploaded files from forecast data and subsidiaries in Excel. The new Power BI dashboard is embedded in SharePoint, which we already use for project documentation.”

NIRAS had an analytics phase with several suppliers.
“We chose Accobat because of their customer-oriented approach and their knowledge of integration with Maconomy. At the same time, they also had a competitive price,” Lone Berg-Olsen says and continues: “We have had an excellent collaboration with Accobat – from the quotation phase through the implementation to ‘go live’. I feel we have a partnership where both parties want to make the most of the collaboration. NIRAS are dependent on things working and that we can get quick support – and that is what we always receive. We feel that we are an important customer to Accobat.”

Kresten Kloch, CFO at NIRAS, adds: ”The collaboration with Accobat has worked really well. Accobat has been understanding of our needs throughout the entire process and been a good sparring partner in the development of our Dashboard.”


Before ’the topping-out ceremony’ there was a lot of leg work
Lone Berg-Olsen explains: “We had a clear, overall requirement specification for content and shape, but during the implementation, the requirements developed a bit with more details than we had originally scoped. We had some difficulties in getting detailed data attuned on individual projects – primarily because our ERP system converted data from multiple sources, which were set up in different ways. It was difficult to solve. Additionally, there was a need to create monthly snapshots in our data warehouse to secure regular monthly figures – that realization came late in the implementation project.”

As mentioned NIRAS has created a setup with uploads of Excel files with forecast data and data from subsidiaries, and that can create some challenges in that they only have an Excel solution for the purpose and not an automatic integration.

“However, we have just chosen a consolidation system which will replace the Excel solution,” Lone Berg-Olsen reveals without going into details.

“Right now, we are working on a Project Manager dashboard which, through graphical visualizations, will be able to help project managers and project owners to focus on the projects which require their attention. The dashboard gives easy and quick access to our collection of project-related data.”

The dashboard is a success throughout the organization
The dynamic dashboard is used by all line managers – from the department manager to the CEO. It is also used daily in the CRM group and by the controllers in Finance. Lone Berg-Olsen welcomes the success. “We have gotten a comprehensive reporting tool which is reliable and gives us ‘one set of numbers’. That is worth its weight in gold. It also gives better processes for the controller with regards to the reporting and the follow-up so we can make sure that we do not create Excel reports. We are almost there.”

CFO Kresten Kloch joins Lone in welcoming the success: “The NIRAS management – from the department level and up – has with our Management Dashboard gotten a unified BI tool which shows the status and the development of our performance, liquidity as well as our order backlog and Pipeline. We are presented with data both graphically and in tables and compares our realized numbers with the forecasts – a setup which offers a good management tool for the management. We have high-level data for all companies in the whole group, and we have the possibility to drill down to specific projects and individual entries,” the CFO says and ends: “I think that our Management Dashboard is in a uniform and attractive design, we have fast performance, and we have great flexibility when it comes to selections, sorting, and thereby many analytics opportunities across our business units.”


Power BI logo
READ MORE ABOUT POWER BI DOWNLOAD CASE AS PDF

About NIRAS

The Danish company NIRAS is one of Scandinavia’s leading consulting engineering firms. With a wide field of expertise within process plants, industry, construction, energy, environment, water & supply for infrastructure, development assistance, and urban planning, NIRAS contributes solutions for a wide range of major societal challenges.



Udfordringer - ikon
Previous challenges
  • Reporting was challenged in terms of performance
  • They had too many Excel reports
  • They could not combine data from different sources
  • A very numbers-based reporting
Marketing-ikon til site
The solution
  • A graphical reporting that can go from overview down to detail view
  • A stable and scalable reporting solution
  • They can now combine data from different sources
Share by: