Most often assigned to the technical department, data preparation or “Data Prep” is the most structuring and time-consuming phase of Business Intelligence.
It should ideally be entrusted to a Business Analyst. Thanks to its very intuitive ergonomics, NEOFI Analytics encourages functional users to prepare the data they wish to analyze themselves.
Contact an expert
NEOFI changes the way traditional data preparation is done by providing a fast and straightforward visual way to clean, combine and shape data.
Collect data saved in the Cloud, in database or extracted from a spreadsheet then aggregate the most heterogeneous data without writing a line of code.
Using the rules engine built into NEOFI Link, NEOFI Analytics identifies data quality issues: null, incorrect, inconsistent, unreadable values, etc. then suggests that you correct or delete them to make your preparation homogeneous and coherent.
Data structuring can be done by dividing columns, pivoting rows, deleting fields, and a combination of 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 appropriate join keys from various datasets.
The final output of the aggregated dataset is displayed for review. Then validation allows the automatic preparation of the dataset, which has the structure and content planned for possible expanded analysis.
Once the data is structured, cleaned, enriched and validated, it is published to be used with NEOFI's Data Visualization
