Before You Begin

This 10-minute tutorial shows you how to format and enrich data to remove unused columns, and enrich the existing data.

Background

You can add information to data using enrichment recommendations in the Oracle Analytics Cloud or Oracle Analytics Desktop. For example, in this tutorial you add longitude and latitude data to customers' address zip codes. You can also implement data format changes to improve how data is represented in a visualization. In this tutorial, sales data is a measure but is represented by a number with more than 2 decimal places. You can change the sales data to use a currency format.

After transforming and enriching the data set, you use the data set in this tutorial to create visualizations.

This is the second tutorial in Preparing Data Sets in Oracle Analytics. Read the tutorials in the order listed.

• Transform Data in Oracle Analytics Cloud
• Enrich Data in Oracle Analytics Cloud

What Do You Need?

• Access to Oracle Analytics Cloud or Oracle Analytics Desktop
• Access to the accountinfo_sales data set

Enrich Data with Geographic Coordinates

1. On the Home page, click Data in the search bar, enter accountinfo_sales and the click Search.
2. In accountinfo_sales, click Options , and select Open.
3. In Results, select the zip column, click Enrich zip with Lat (latitude).
4. In Recommendations, click Enrich zip with Lon (longitude).

   

Change Data Properties

When the data is loaded, the columns might not use your expected format. For example, a column containing a number is treated as a measure rather than as an attribute. In this data set, phone number area code is a number. As a result when you extracted area code from the customer phone, it is a measure rather than an attribute.

In this section, you change the Sales and phone_number_area_code data columns to use the preferred data format.

1. In Results, select the Sales column. In Properties, click Number Format . In Number Format, click Auto, and then select Currency.
2. Click Apply Script.

   The changes are complete when the Apply Script progress indicator disappears.

3. Click Back .

Visualize Transformed and Enriched Data

The Data Elements pane shows the transformed and enriched data elements that you can use to create visualizations.

1. On the Home page, click Create, and then click Project. In Add Data Set, click accountinfo_sales, and then click Add to Project.
2. From the Data Elements pane, drag Sales to the canvas, and then drag state to the canvas.

   A bar visualization is created with sales as the Y-Axis and state as the X-Axis. It looks like sales are the largest in California.

   

3. In the visualization, click Menu , select Sort, and then select state by sales High to Low.

   

4. Click Visualization Type , and select Map.
5. In the map visualization Properties, click Auto in the Title row, and then select Custom. In Title, enter Sales by State.

   

6. In the visualization, select Menu , and then select Duplicate Visual.
7. Click Visualization Type , and select Area.
8. Drag the data elements from the Data Elements pane to the drop targets in the Grammar pane, as shown in the table:

   Data Element	Drop Target
   Sales	# Values
   Gender	Category
   product line	Color

9. In the area visualization Properties, click Auto in the Title row, and select Custom. In Title, enter Sales by Gender and Product Line.

   

Want to Learn More?

• Accept Enrichment Recommendations
• Edit Column Properties
• Edit the Data Preparation Script