Data import

Importing Data from Excel

Frequently, part or all of the data you want to analyze and manage come from other software applications. Other times, clients have already stored historical data on spreadsheets or on data bases.

The OpenMet system incorporates a module for importing large volumes of data from MS Office Excel in a way that allows them to run on the Business Intelligence module. This module permits:

Importing all kinds of data from MS Office Excel
Complete freedom in questions, control panel and related Key Performance Indicators
The best services to help you in the implementation and management of the diagnostic project, the selection of the methodology, the design of the control panels or the survey
Automatic transfer of answers to the Business Intelligence setting in order to exploit results in real time

Automatic merging of similar data (whose origin is from a control panel)

Aggregate view of scattered results
Different data from different languages can be analyzed in a uniform way
Different data from partial content can be analyzed in a uniform way
Different data coming from different sources (electronic surveys, paper, Excel,…) can be analyzed as a single survey