Oracle Analytics

To accelerate the data analytics process and support decisions with actionable information, the application includes a code-free, drag-and-drop interface enables anyone in the organization to build interactive data visualizations without specialized skills.

Oracle Analytics offers more than 35 out-of-the-box native data connection choices, including JDBC (Java Database Connectivity). Users can securely create, manage, and share data connections with individuals, teams, or the entire organization. It can access data wherever it is located: public cloud, private cloud, on-premises, data lakes, databases, or personal datasets, such as spreadsheets or text-based extracts.

Its self-service data preparation capabilities lets users ingest, profile, repair, and extend datasets, local or remote. Data quality insights provides a quick view of data to identify anomalies and help with corrections. The custom reference knowledge capability enables Oracle Analytics to identify more business-specific information and make relevant data enrichment recommendations. Users can build visual dataflows to transform, merge, and enrich data and save results in Oracle Analytics storage, a connected relational database (e.g. Snowflake or MySQL), or Oracle Essbase.

The solution is used to produce trusted and consistent information across the enterprise with a business representation of data using a shared semantic model, without compromising governance. Users access data through nontechnical business terms, predefined hierarchies, consistent calculations, and metrics. Users can create views across data sources visually explore them using native queries that deliver high performance. And configure the balance of live and cached connections to ensure high-performance data access. The application supports multiple data visualization tools, such as Microsoft Power BI, and retains a consistent and trusted view of enterprise metrics.