Table of Contents
- Title and Copyright Information
- Preface
- 1 Get Started with Oracle Analytics Desktop
-
2
Connect to Data Sources
- About Data Sources
- Manage Connections to Data Sources
- Connect to an Oracle Database
- Connect to Oracle Autonomous Data Warehouse
- Connect to Oracle Autonomous Transaction Processing
- Connect to an Application in Oracle Fusion Cloud Applications Suite
- Create a Connection to Oracle Essbase
- Connect to NetSuite
- Connect to Oracle Talent Acquisition Cloud
- Connect to Google BigQuery
- Connect to Dropbox
- Connect to Google Drive or Google Analytics
- Create JDBC Connections
- Create Generic ODBC Connections
- Connect to Snowflake Data Warehouse
-
3
Connect to Your Data Using Datasets
- What Are Datasets?
- About Opening Datasets
- View Available Connections
- Data Sources Available for Use in Datasets
- About the Dataset Editor
- Create a Dataset From a Connection
- Add Multiple Connections to a Dataset
- Add a File to a Dataset Created From a Connection
- Understand Dataset Table Joins
- Add Joins Between Dataset Tables
- Disable Auto Joins in Datasets
- Modify or Fix Joins in a Dataset
- Add Joins When Table Columns Don't Match
- Delete Joins from a Dataset
- Include a Dataset Table in Data Source Queries
- What is Preserve Grain?
- Specify Which Table Determines Grain
- Rearrange the Order of a Dataset's Tables
- What are Quality Insights?
- Explore Your Data Using Quality Insights
- About Removing or Restoring Dataset Columns
- Remove or Restore a Dataset Table's Columns
- Filter a Dataset Table
- Specify Whether a Dataset Table Is Cached or Live
- View a Dataset Table's Original Formatting
- Create Datasets from Files
- Create a Dataset from a Subject Area in Oracle Fusion Cloud Applications Suite
- Create a Dataset from an Analysis in Oracle Fusion Cloud Applications Suite
- Create a Dataset from an Essbase Connection
- Add a Table to a Dataset Using a SQL Statement
-
4
Enrich and Transform Data
- About Data Enrichment and Transformation in Oracle Analytics
- Enrich and Transform Your Data
- Accept Enrichment Recommendations
- Transform Data Using Column Menu Options
- Transform Data Using Replace
- Convert Text Columns to Date or Time Columns
- Adjust the Display Format of a Date or Number Column
- Create a Bin Column When You Prepare Data
- Configure Columns Properties in a Dataset
- Hide or Delete a Column
- Restore a Hidden or Deleted Column
- Edit the Data Preparation Script
- Add Columns to a Dataset
- Create Calculated Data Elements in a Workbook
- Enrich and Transform Reference
- 5 Create Datasets Using Data Flows
- 6 Manage Datasets
-
7
Visualize and Analyze Data
- Begin to Build a Workbook and Create Visualizations
- Open a Workbook in Edit Mode
- Configure a Workbook to Open in Edit Mode
- Work with a Workbook's Datasets
- Build a Visualization by Adding Data from the Data Panel
- About Visualizaton Types
- Enhance Data in Visualizations with Advanced Analytics Functions
- Use Spark Charts to Examine Trends
- Sort Data in Visualizations
- Undo and Redo Edits
- Create a Custom Error Message for Visualizations with No Data
- About Refreshing a Workbook's Data
- Refresh a Workbook's Data
- Pause Data Queries in a Workbook
- Work with Canvas Properties
- Copy and Paste a Visualization or Canvas
- Copy and Paste a Visualization's Data
- Work with Multiple Visualizations on a Canvas
- Change Visualization Types
- About Visualization Properties
- Adjust Visualization Properties
-
Highlight Important Data Events
with Conditional Formatting
- What Can I Do With Conditional Formatting?
- Apply Conditional Formatting to a Visualization
- Example - Compare a Measure to a Set of Thresholds
- Example - Compare a Measure to a Target or Goal
- Example - Compare a Measure to a Complex Expression Value
- Example - Compare a Measure to a Percentage of a Value
- Filtering and Animating Visualizations Using a Slider Dashboard Filter
- Apply Color to Visualizations
- Format Numeric Values of Columns
- Format Numeric Values of Visualizations
- Set Currency Symbols for Visualizations
- Add Notes to Visualizations
- Sort, Drill, and Select Data in Visualizations
- Analyze Data with Explain
- About Warnings for Data Issues in Visualizations
- Set Workbook Thumbnails
- Set Visualization Loading Overlay Opacity
-
8
Filter Your Data
- About Filters and Filter Types
- How Datasets Interact with Filters
- How the Number of Datasets Affects Filters
- About Automatically Applied Filters
- Filter Data in a Workbook
- Specify a Filter's Selection Values
- Enable or Disable the Limit By Setting from the Filters Bar
- Filter Data in a Visualization
- Create On-Canvas Filters
- Filter Data Using a Dashboard Filter Visualization
- Change the Scope of Filters Between the Main Filter Bar and Visualizations
- Use a Visualization as a Filter
- Apply Different Filter Types
-
9
Apply Map Backgrounds and Map Layers to Enhance Visualizations
- About Map Backgrounds
- Enhance Visualizations with Map Backgrounds
- Use Different Map Backgrounds in a Workbook
- Interpret Data Values with Color and Size in Map Visualizations
- Add Custom Map Layers
- Update Custom Map Layers
- Apply Multiple Data Layers to a Single Map Visualization
- Use an Image as a Map Background and Draw Map Layer Shapes on the Image
- Assign a Map Layer to a Data Column
- Auto Focus on Data for a Map Visualization
- Configure Zoom in Map Visualizations
- Review Location Matches for a Map Visualization
- Create Heatmap Layers on a Map Visualization
- Create Cluster Layers on a Map Visualization
- Represent Point Data With Custom Icons on a Map
- Select Points or Area on a Map
- Represent Line Data Using Size and Color on a Map
- Make Map Layers and Backgrounds Available to Users
- Use a Map Background as the Default
- Add Map Backgrounds
-
10
Use Data Actions
- Create Data Actions to Connect Visualization Canvases
- Create Data Actions to Connect to External URLs from Visualization Canvases
- Create Data Actions to Connect to REST APIs from Visualization Canvases
- Use Data Actions to Connect to Oracle Business Intelligence Publisher Reports
- Invoke Data Actions from Visualization Canvases
-
11
Create Custom Data Action
Plug-ins
- About Data Action Plug-ins and the Data Actions Framework
- Choose the Best Data Action Class to Extend
- Generate Data Action Plug-ins from a Template
- Generated Folders and Files
- Extend a Data Action Base Class
- Choose Which Data Action Inherited Methods to Override
- Test, Package, and Install Your Data Action
- Use an Upgrade Handler for Knockout Model Changes
- Upgrade Data Action Plug-ins
- Data Action Plug-in File Reference
- 12 Use Other Functions to Visualize Data
-
13
Use Oracle Analytics Predictive Models and Oracle Machine Learning Models
- Create and Use Oracle Analytics Predictive Models
- Use Oracle Machine Learning Models in Oracle Analytics
- Apply a Predictive or Registered Oracle Machine Learning Model to a Dataset
- 14 Import, Export, and Share
- A Frequently Asked Questions
- B Troubleshoot Visualization Issues
- C Accessibility Features and Tips
- D Data Sources and Data Types Reference
- E Data Preparation Reference
- F Expression Editor Reference
-
G
Oracle Analytics Desktop SDK Reference
- Oracle Analytics Desktop SDK
- Create the Visualization Plug-in Development Environment
- Create a Skeleton Visualization Plug-in
- Create a Skeleton Skin or Unclassified Plug-in
- Develop a Visualization Plug-in
- Run in SDK Mode and Test the Plug-in
- Validate the Visualization Plug-in
- Build, Package, and Deploy the Visualization Plug-in
- Delete Plug-ins from the Development Environment