Case study · Specialty chemicals · Excel reporting replaced
The international subsidiaries worked with individual Excel files without a common data basis. The result is a reporting dashboard based on a Power App that consolidates all five companies.

At a glance
Starting point
Unimatec's European headquarters worked with five separate Excel files that were distributed manually to the respective companies every month. KPIs were named differently, there was no common data basis and no way to consolidate. There was also no permissions and approval concept and no logging of entries and changes.
Solution
Together with Digital Touch, a new dashboard concept based on a Power App with automated workflows was developed and implemented. Key components are a unified input form for all companies, standardized KPIs, a permissions and approval concept, complete logging and the consolidation of all companies in one central overview. Analysis is done uniformly in EUR and JPY, and the data is transferred to Excel automatically.
Result
The solution creates a common data basis and enables consolidated analysis across all five companies. Changes to KPIs must be justified and are transparently documented. The dashboard replaces the manual, fragmented Excel landscape and brings comparability, efficiency and reliability to international reporting.
Working with Digital Touch was very professional, friendly and team-oriented from the start. We were particularly impressed by the personal exchange, the technical know-how and the fast, reliable implementation of changes.
More references
In a free consultation we'll show you how this project was delivered – and what parts of it fit your situation.