Prepare and enrich capabilities help business users transform data sets from raw data gathered from source systems into data that can support analytics stories.
Data from source systems is often not ready for business analytics. Business users are required to transform and enrich their data sets to create all the calculations, dimensionality, and other relevant data to support their reporting needs. This process is the last mile of data preparation that business users must undertake before starting their analytics. Users typically begin with data exports and then complete the last mile of data preparation in spreadsheets. Spreadsheets, however, are not secure and increase the potential for introducing human error. Users should be able to perform all necessary last-mile data preparation and enrichment tasks within a single secure platform that provides tracking and scheduling and removes reliance on individuals or bespoke, ungoverned spreadsheets processes.
Whether importing data from files or connecting to existing sources, the Quality Insights capability accelerates the preparation of data for analysis. Using the power of the semantic profiler in Oracle Analytics, Quality Insights provides a visual representation of your data's quality, helping to rapidly identify issues. These indicators are based on null values, data type inconsistencies, and semantic type classifications. Each column in your data has a contextual visual to show the distribution of the represented data. Make inline edits to quickly address any issues, rename columns, and use the scrollable mini map to easily traverse long lists.
Data flows provide business users with a code-free capability to transform data sets into the information needed for analytics. Connect multiple data sources into cohesive subject areas, whether your sources are in the cloud, on-premises, or personal data extracts. Enrich data through a variety of transformation capabilities, including training and executing machine learning models. Results can be saved in Oracle Analytics storage, a connected RDBMS, or Oracle Essbase. Once built and tested, data flows can be shared with other users or scheduled for regular execution.
Add additional columns to data sets to create calculations. Simple drag-and-drop capabilities with Excel-like formulas allow business users to create sophisticated data sets with all the metrics needed. When more complex transformations require custom logic, Oracle Analytics allows users to experience the full potential of regular expressions (also known as Regex) through pattern matching of column text in data preparation or data set editors.