Home Success Stories How Ammann Components uses a central reporting tool to support strategic decisions

How Ammann Components uses a central reporting tool to support strategic decisions

About Ammann Components

Ammann AG, known on the market as Ammann Components, is an established Swiss system supplier in the metalworking industry based in Switzerland. With just under 70 employees, the company generates annual sales of around 20 million Swiss francs. For decades, Ammann Components has specialized in processing forged and cast blanks into ready-to-install precision components.

The company supplies a wide range of demanding industries, including the construction machinery and hydraulics industry, large engine manufacturing, rail vehicle manufacturing, and the automotive and defense industries. As a manufacturing and development partner for safety-related components, which are often supplied as single-source parts, the highest quality and delivery reliability are crucial to the success of the company and its renowned customers.

The Challenge

The IT infrastructure at Ammann Components has grown over time and consisted of several isolated systems:

Three-part challenge: IT infrastructure

This technological fragmentation led to significant organizational challenges:

Lack of transparency
During the current fiscal year, there was only a very vague picture of the operating result.

Time-delayed data
It took weeks to prepare the revised annual financial statements. Generating up-to-date information on liquidity and profitability was extremely time-consuming.

Manual sources of error
To compensate, various Excel lists with manual corrections were maintained, which further compromised data quality and increased uncertainty.

Lack of foresight
With a lack of foresight, management navigated through a volatile market environment without having an early warning system in place to respond proactively to changes.

The solution

Together, we implemented a modern and cost-effective business intelligence solution based on Google Cloud Platform (GCP) in just three weeks.

Data extraction & storage

Financial data is exported manually from Abacus and stored securely in Google Cloud Storage. The architecture is already designed for future full automation via FTPS or Rest API.

Data preparation & logic

BigQuery forms the core of the architecture. In combination with dbt (Data Building Tool), raw data is converted into structured models and the business logic is mapped in a modular way, guaranteeing a high-performance, quality-assured database.

Manual entries

Variable data such as allocation keys are flexibly maintained directly by users via a seamlessly integrated Google Sheet.

Visualization & Reporting

Reporting is done via interactive dashboards in the free version of Looker Studio. Users can intuitively filter KPIs and contribution margins and analyze them in detail.

Automated data process

Google Cloud Workflows automates the entire data process—from transfer and processing in BigQuery to final delivery in the dashboard.

Organizational implementation

The organizational implementation of the project is divided into three phases/weeks using a diagram.
"What radar would have been for the Titanic is what the new reporting tool is for us. We now have a clear view ahead, a high response speed, and genuine planning reliability. We definitely should have made the decision to go ahead with this project earlier." —
Markus Halder from NC Manufacturing
Markus Halder
Managing Director, AMMANN Components

Conclusion

By implementing the new reporting solution, Ammann Components has realized significant economic added value. The company is now able to act quickly and decisively based on daily updated data, instead of relying on reports that are weeks old.

The main advantages

Management always has a clear view of the financial situation and can make strategic decisions based on solid data.

Daily updated KPIs allow deviations to be identified immediately and countermeasures to be initiated, which is essential in a volatile market.

Detailed insights into contribution margins and cost structures per profit center enable targeted control and optimization of operational business.

The running costs for the Google Cloud infrastructure amount to just 5-10 Swiss francs per month, while the reporting tool (Looker Studio) is free of charge.

The project has laid the foundation for a data-driven corporate culture and can be flexibly expanded to connect additional systems (e.g., time tracking, PPS, ERP) in the future and leverage potential in the areas of AI and forecasting.

Read the Ammann Components success story now

Published by:

Christiane Grimm

AUTHOR:IN

How did you like the article?

How helpful was this post?

Click on the stars to rate!

Average rating 5 / 5.
Number of ratings: 9

No reviews yet! Be the first to rate this post.

Other interesting articles