Data Modeling and Preparation

You can use Oracle Utilities Analytics Visualization to perform various data modeling and preparation tasks.

Task

Description

Analyze the performance of visualization components

Use built-in Performance Tools to analyze statistics such as query time, server time, and streaming time for visualization components in workbooks. See Developer Reference.

Auto-join option in datasets with multiple tables

Use the Auto Join Tables option to turn off or on automatic join creation in datasets. By default, joins are created automatically when you drag and drop tables onto the Join Diagram. In some cases it's useful to turn auto joins off and build joins manually. See Disable Auto Joins in Datasets.

Add multiple tables to a data set

Perform self-service data modeling with datasets by adding multiple tables to a dataset from one or more relational data source connections. See Data Sources Available for Use in Datasets Containing Multiple Tables and Create a Dataset from a Connection.

Add local subject area data sources to datasets that contain multiple tables

Add local subject area data sources to datasets that contain multiple tables. See Create a Dataset from a Local Subject Area.

Reload datasets on a schedule

Schedule data reloads for any dataset with one or more tables set to automatically cache data. View information about the dataset reloads, such as history and schedule details. See Schedule a Dataset Reload and View a Dataset Reload Schedule's Details.