Advantages and applications of Apparo Fast Edit


Is your production of reports and measures effective?




  • 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?
  • Apparo Fast Edit gives you the opportunity to better integrate the reporting system in the work processes. The data output of the reports is now part of the cross-departmental Workflows. The ability of data entry or data import from Excel into eg IBM Cognos or Qlik reports/dashboards facilitate many processes. With e.g. a Cognos Workflow becomes the reporting a planning tool for and the management of master data using Cognos or Qlik will become an essential element of your data maintenance.


    In larger offices, data is always manually collected and further processed using Excel.
    In best-case scenarios, the source data is taken from a business intelligence system or other IT systems.

    This data is often collected manually using Excel and then sent to various departments via email.

    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 Fast Edit is the ideal solution for recurring data entry.

    Data records can be assigned customised statuses such as:

  • Open
  • Closed
  • Accepted
  • Under review

  • 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 Fast Edit 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.)

  • Data quality
  • 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:


    icon_camera_01-transWatch the data entry workflow video >>


    icon_pdf_01-transRead a success story >>


    icon_pdf_01-transMore information about workflows >>


    icon_pdf_01-transUse Case: Workflow with e-mail notification>>