Enrich a Dataset

Before you deploy your visualization, you may want to enrich and transform your data. For example, you might rename data columns or add calculations to make the information more user-friendly.

To enrich a dataset:

1. Select a table from the bottom bar.
   
   
   
   
2. Select columns and use the enrich and transform tools to enhance your data.
3. Use the Recommendations panel for suggested enrichments.
4. Use the Options menu at the top of each column to apply common transformations such as Rename, Uppercase, and Trim.
5. From the Options menu at the top of a column, select Edit to enhance columns with functions and expressions from the Oracle Analytics functions library. For example, aggregates, strings, expressions, and math functions.
6. Select Add Preparation Step in the Data Panel to add a column based on a custom transformation. You can build your column using functions and expressions from the Oracle Analytics functions library. For example, aggregates, strings, expressions, and math functions.
7. Use the Properties pane at the bottom of the Data panel to review and change a column's type and aggregation. For example, you might select Treat As and change from an attribute to a measure, or change the default aggregation type from Sum to Average.
8. Use the Quality Insights tile above each column to explore and enrich your data.
9. Use the Review auto Treat-as recommendations option to change the default column type identified by the semantic profiler. For example, if the semantic profiler identifies a column with numeric IDs such as 1078220 as a measure, you can change the column to an attribute.

See About Data Enrichment and Transformation in OACfor more information.