BI solution for sound controlling at the German Economic Institute

  • Home page
  • /
  • BI solution for sound controlling at the German Economic Institute

The project at a glance

3-stage contribution margin accounting

Complex models automated and visualised with TARGIT

personnel reporting
with a click

What used to take days is now available in seconds.

Notification agent for KPIs

Automatically detect deviations and take targeted action

Industry

Authorities and public institutions / Science & Research

Customer

Cologne Institute for Economic Research (IW)

Technology / Product

TARGIT Decision Suite 2019 (Microsoft SQL Server, Analysis Services, Custom Reporting with b-imtec)

© German Economic Institute

Project description

The task

As one of Germany's leading economic research institutes, the IW needed a powerful BI solution to analyse complex key figures and present them in an understandable way. The existing ERP tools were not sufficient to make transparent and reliable statements about cost and revenue structures.

The aim was to create a system that enables period-based analyses, individual reports and automated alerts – tailored to the needs of management, controlling and project managers.

© German Economic Institute

Solution

The realisation

Requirements and objectives were defined jointly in an initial workshop. Based on the TARGIT Decision Suite, b-imtec (a member of the collana Group) developed a central reporting system including interactive dashboards, KPI monitoring and role-based views.

Highlights:

  • Automation of three-stage contribution margin accounting
  • Personnel reporting with significant time savings
  • Notification agent that automatically informs you in case of deviations

The system is based on Microsoft SQL technologies and has been seamlessly integrated into the existing infrastructure.

„Trust-based, continuous communication and a shared understanding of the underlying models are key to good analysis. This helps to identify the software's options in the best possible way and make optimal use of them. We look forward to further projects of this kind with our sparring partner b-imtec.“

Thilo Schuhmann

Project manager at the IW

© German Economic Institute

Result / Impact

This is how the problem was solved

Today, the IW has a central BI platform at its disposal that provides all relevant key figures in real time. Controlling processes have been significantly accelerated, and data quality and comparability have been improved.

The solution supports informed decisions at all levels – from project management to strategic planning – and offers maximum transparency with minimal manual effort.

Recommendation

Customers were also interested in

Map complex reporting requirements flexibly and precisely with customised software.

Identify analytical potential and put it into practice in the Data Intelligence Workshop.

Use data and analytics to uncover the treasures in your own data and put them to profitable use.

Best Choice for data-based economic research

With TARGIT and b-imtec, the IW is laying the foundation for fact-based decisions.