4 Enrich and Transform Data

Data preparation involves cleansing, standardizing, and enriching your dataset before you visualize the data.

You enrich and transform data to improve its quality and get it ready to visualize. Better quality data gives you better quality insights.

Topics:

• About Data Enrichment and Transformation in Oracle Analytics

• Enrich and Transform Your Data

• Accept Enrichment Recommendations

• Transform Data

• Replace Missing or Null Values in a Dataset

• 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

• Add Columns to a Dataset

• Create Calculated Data Elements in a Workbook

• Edit the Data Preparation Script

• Enrich and Transform Reference