Quality data obtained in the reports, can be analyzed in various ways and help you to improve your products and processes. The Analytics function in Operations1 already offers you extensive functions for this.

If individual visualizations and graphs or the connection with data from other systems are important, a data export and the connection of a BI tool such as PowerBI, Qlik or tableau can be useful.

By default, the reports can be exported as .csv or .xlsx file. When opening a CSV-file in Microsoft Excel, please make sure that you open it via the "Data" section and the "From Text/CSV" button within it. If larger amounts of data are involved, an export via the Operations1 API or our CLI tool is realized in a structured data format.

The fastest and easiest way to import report data from Operations1 into an external database and display it via a BI tool is a pure cloud-based setup. Using our REST API and a connector (Logic App, Azure function, ...), the data is stored in a database (SQL, NoSQL). This is connected as a standard data source with the corresponding analysis tool, which offers individual display options.

If you want to store the data in an on-premise database and connect it to the corresponding BI tool, our middleware (CLI tool) serves as a connector to Operations1. On the local side, a script (e.g. Python, JavaScript, etc.) is required, that uses a start-job to retrieve the data from Operations1 at regular intervals and then transfers it to the database.

If you are interested in an implementation, feel free to contact our Service & Support Team. In most cases, the involvement of our experts and IT will be necessary.