Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Resources
• Conventions

New Features for Oracle Data Visualization Users

• New Features for Oracle BI EE 12c (12.2.1)
• New Features for Oracle BI EE 12c (12.2.1.1)
• New Features for Oracle BI EE 12c (12.2.1.2)
• New Features for Oracle BI EE 12c (12.2.1.3)
• New Features for Oracle BI EE 12c (12.2.1.4)

1 Getting Started with Data Visualization

• About Oracle Data Visualization
• What is the Data Visualization Home Page?
• Getting Started with Samples

2 Exploring and Analyzing Data in Visualization Canvases

• Typical Workflow for Visualizing Data
• Creating a Visualization Project and Adding Data
• Adding Data from Data Sets to Visualization Canvases
  • Adding Data to Blank Canvases
  • About Adding Data to the Visualization Grammar Pane
  • About Adding Data to the Visualization Assignments Pane
• Adding Advanced Analytics to Visualization Canvases
• Creating Calculated Data Elements in a Data Set
• Undoing and Redoing Edits
• Refreshing Visualization Content
• Adjusting the Visualization Canvas Layout
• Changing Visualization Types
• Adjusting Visualization Properties
• Assigning Color to Visualize Data
  • Managing Color Settings
• Formatting Numeric Data Properties
• Applying Map Layers and Backgrounds to Enhance Visualizations
  • Enhancing Visualizations with Map Backgrounds
  • Using Color to Interpret Data Values in Map Visualizations
  • Adding Custom Map Layers
  • Updating Custom Map Layers
  • Making Maps Available to Users
• Sorting and Selecting Data in Visualization Canvases
• About Warnings for Data Issues in Visualizations

3 Creating and Applying Filters for Visualizing Data

• Typical Workflow for Creating and Applying Filters
• About Filters and Filter Types
• How Visualizations and Filters Interact
• About Automatically Applied Filters
• Creating Filters on a Project
• Creating Filters on a Visualization
• Moving Filter Panels
• Applying Range Filters
• Applying Top or Bottom N Filters
• Applying List Filters
• Applying Date Filters
• Building Expression Filters

4 Using Other Functions to Visualize Data

• Typical Workflow for Preparing, Connecting and Searching Artifacts
• Modifying Text Columns
  • Converting Text Columns to Date or Time Columns
  • Adjusting the Display Format of Date or Time Columns
  • General Custom Format Strings
• Building Stories
  • Capturing Insights
  • Creating Stories
  • Viewing Streamlined Content
• Identifying Content with Thumbnails
• About Composing Expressions
• Using Data Actions to Connect to Canvases and External URLs
  • Creating Data Actions to Connect Visualization Canvases
  • Creating Data Actions to Connect to External URLs From Visualization Canvases
  • Applying Data Actions to Visualization Canvases
• Searching Data, Projects, and Visualizations
  • Indexing Data for Search and BI Ask
  • Visualizing Data with BI Ask
  • Searching for Saved Projects and Visualizations
  • Search Tips

5 Adding Data Sources for Analyzing and Exploring Data

• Typical Workflow for Adding Data Sources
• About Data Sources
• Connecting to Database Data Sources
  • Creating Database Connections
  • Creating Data Sets from Databases
  • Editing Database Connections
  • Deleting Database Connections
• Connecting to Oracle Applications Data Sources
  • Creating Oracle Applications Connections
  • Composing Data Sets from Subject Areas
  • Composing Data Sets from Analyses
  • Editing Oracle Applications Connections
  • Deleting Oracle Applications Connections
• Creating Connections to Dropbox
• Creating Connections to Google Drive or Google Analytics
• Creating Generic JDBC Connections
• Creating Generic ODBC Connections
• Creating Connections to Oracle Autonomous Data Warehouse Cloud
• Creating Connections to Oracle Big Data Cloud
• Creating Connections to Oracle Talent Acquisition Cloud
• Adding a Spreadsheet as a Data Source
  • About Adding a Spreadsheet as a Data Set
  • Adding a Spreadsheet from Your Computer
  • Adding a Spreadsheet from Dropbox or Google Drive
• Creating a Binning Column When Preparing Data

6 Managing Data that You Added

• Typical Workflow for Managing Added Data
• Managing Data Added from Data Sources
  • Managing Data Sets
  • Refreshing Data that You Added
  • Updating Details of Data that You Added
  • Deleting Data Sets from Data Visualization
• Modifying and Adding Uploaded Data Sets
  • Modifying Uploaded Data Sets
  • Adding Data to a Project
  • Removing Data from a Project
  • About Editing Data Sets
• Blending Data that You Added
• About Changing Data Blending
  • Changing Data Blending

7 Using Data Flows to Create Curated Data Sets

• Typical Workflow for Creating Curated Data Sets with Data Flows
• About Data Flows
• About Editing a Data Flow
• Creating a Data Flow
• Adding Filters to a Data Flow
• Adding Aggregates to a Data Flow
• Merging Columns in a Data Flow
• Merging Rows in a Data Flow
• Creating a Binning Column in a Data Flow
• Creating a Sequence of Data Flows
• Creating a Group in a Data Flow
• Adding Cumulative Values to a Data Flow
• Customizing Data Flow Step Names and Descriptions
• Executing a Data Flow
• Saving Output Data from a Data Flow to a Database
• Running a Data Flow

8 Importing and Sharing

• Typical Workflow for Importing and Sharing Artifacts
• Importing and Sharing Projects or Folders
  • Importing an Application or Project
  • Sharing a Project or Folder as an Application
• Sharing Visualizations, Canvases, or Stories
  • Sharing a File of a Visualization, Canvas, or Story
  • Printing a Visualization, Canvas, or Story
  • Writing Visualization Data to a CSV or TXT File

A Frequently Asked Questions

• FAQs for Data Visualization Projects and Data Sources

B Troubleshooting

• Troubleshooting Data Visualization Issues

C Accessibility Features and Tips for Oracle Data Visualization

• Keyboard Shortcuts for Data Visualization

D Data Sources and Data Types Reference

• Supported Data Sources
• Limited Support for Some Databases
• Oracle Applications Connector Support
• Data Visualization Supported and Unsupported Data Types
  • Unsupported Data Types
  • Supported Base Data Types
  • Supported Data Types by Database

E Expression Editor Reference

• SQL Operators
• Conditional Expressions
• Functions
  • Aggregate Functions
  • Analytics Functions
  • Calendar Functions
  • Conversion Functions
  • Display Functions
  • Evaluate Functions
  • Mathematical Functions
  • Running Aggregate Functions
  • String Functions
  • System Functions
  • Time Series Functions
• Constants
• Types