Most often handled by the technical department, data preparation, or "Data Prep," is the most structuring and time-consuming phase of Business Intelligence. Ideally, it should be entrusted to a Business Analyst.
Thanks to its highly intuitive interface, NEOFI Analytics encourages business users to prepare the data they wish to analyze themselves.
Contact an expert
NEOFI is changing the way traditional data preparation is done by offering a quick and direct visual way to clean, combine and shape data.
Collect data saved in the Cloud, in a database or extracted from a spreadsheet, then aggregate the most heterogeneous data without writing a single line of code.
Using the rules engine integrated into NEOFI Link, NEOFI Analytics identifies data quality issues: null, incorrect, inconsistent, unreadable values, etc., and then offers to correct or delete them to make your preparation homogeneous and consistent.
Data structuring can be done by splitting columns, pivoting rows, deleting fields, and a combination of even the most complex possibilities. NEOFI Link can suggest transformations by highlighting sections of data.
You can aggregate, harmonize, or merge datasets from different sources to obtain a single, comprehensive dataset containing all the necessary information. NEOFI uses machine learning to identify the appropriate join keys for the various datasets.
The final rendering of the aggregated dataset is displayed for verification. Validation then enables the automatic preparation of the dataset, which is equipped with the structure and content intended for potential further analysis.
Once the data is structured, cleaned, enriched and validated, it is published for use with NEOFI's Data Visualization
