Case study · Specialty chemicals · Excel reporting replaced

Unimatec Chemicals

Digital clarity instead of Excel chaos in international reporting

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.

Branche
Specialty chemicals
Mitarbeitende
Standorte
Abgelöst
Excel reporting
Dauer
5
companies on one data basis
2
currencies: analysis in EUR and JPY
€0
ongoing third-party license

At a glance

  • Five separate Excel files replaced by a consolidated Power App dashboard
  • Consolidated analysis of all five companies in EUR and JPY
  • Complete logging of all entries and changes with approval processes

Starting point

Where the company stood

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

What we built together

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.

Eingesetzte Lösungen
  • Power App dashboard
  • Automated workflows
  • Unified input form
  • Permissions and approval concept
  • Complete logging
  • Consolidation in a central overview

Result

What has changed since go-live

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.

Jascha Kort
Accounting Department, Unimatec Chemicals Europe GmbH · quote translated from German

Do you use this system too?

How the migration to standard Microsoft 365 works

Feature comparison, coverage, the five-step process and the License calculator – all on one page.

Go to the replacement page

More references

More projects on standard Microsoft 365

All references →

An intranet like this for your company?

In a free consultation we'll show you how this project was delivered – and what parts of it fit your situation.