How quickly and correctly you get your measures from the subsidiaries or the branch offices?
Simultaneous working, workflow, full traceability?
How fast are new measures implemented into your applications?
How high is the effort of your staff members during the collection and preparation of data?
In every larger office, data is collected manually and further processed by Excel. In the best case, the original data comes from a business intelligence system or other IT systems.
This data is often collected manually by Excel and often sent to other departments via e-mail.
This process has the following advantages:
Extremely flexible in its definition
Easy to use
But the disadvantages far outweigh the advantages:
It's nearly impossible to maintain an overview:
- Who has yet to enter data? - Which data needs to be updated? - When you have several Excel files floating around, each version is bound to be different. Who currently has the most recent version? Or could there be several versions, each of which is only partially updated?
Data quality: there’s no verification process and typos cannot be prevented
Various data records cannot be accessed simultaneously by different departments, as an Excel file can only be sent as a whole – as a result, one department has to wait for data to be entered by another
Creating a single data record for documents and images is not possible
Security – is everyone allowed to view and make changes to everything?
Who entered what data and when?
This becomes even more critical when goals change. Additional data needs to be collected at short notice. But is everyone using the most recent Excel file?
In conjunction with a business intelligence system, Apparo Flow is the ideal solution for recurring data entry.
Data records can be assigned customised statuses such as:
Because all changes made to data can be recorded, it's possible to determine the current status.
In conjunction with a business intelligence system, Apparo Flow offers the following benefits:
Work progress can be determined at any time:
a. What still needs to be done? b. What's already been done?
Who is responsible for which data entries and changes:
a. Which user entered what? b. When? c. And how? (Via Excel data import, manually, etc.)
All data entries can be evaluated for correctness. Other IT systems can be accessed to determine which data is valid.
Example of a procurement workflow with e-mail for status change: accept/deny: