Before you Begin

In this 10-minute tutorial, you learn how to upload a custom knowledge reference file to create semantic types for classification and enrichment in your datasets, and verify the availability of the custom semantic types.

Background

You can add a custom knowledge reference file to create semantic types for classification and enrichment of the data you use in Oracle Analytics. Your custom semantic types augment the system knowledge semantic types used to identify and profile data used in Oracle Analytics. You could add custom semantic types that are relevant to business such as product names, codes, and other types of alphanumeric data. Your custom semantic types can provide enrichment and transformation recommendations for your user datasets with information such as customer knowledge and product information.

If you have misspellings of supplier, manufacturer, place names, or other misspellings in your data, you can use a custom knowledge reference file to standardize those names during data preparation. After uploading your custom knowledge reference file with standardized names, Oracle Analytics automatically detects the columns containing the keys, and provides a recommendation to standardize all of the applicable names in the dataset.

What Do You Need?

Upload Your Custom Knowledge Reference File

  1. Sign in to Oracle Analytics with your administrator credentials.
  2. On your home page, click the Navigator Navigator icon, and then click Console.
  3. In the Console, click Data Enrichments.
  4. Under the Custom Knowledge list, click Add Custom Knowledge Add icon. Locate and usp_drug_classification2.csv file, and then click Open.
  5. In Create Custom Knowledge usp_drug_classification2, enter a Name or keep the default name, and then click OK.
  6. Click Go back Go back icon.

Test Your Custom Semantic Types

In the section, you add a data source to verify that your custom semantic types are available for use in transformations or enrichments.

  1. Click the Navigator Navigator icon, and then click Home Home icon.
  2. On your home page, click Create, and then select Dataset.
  3. In Create Dataset, click Drop data file here or click to browse. In File Upload, select the medicare_partd_provider_file.xlsx, and then click Open.
  4. In Create Dataset Table from medicare_partd_provider_file.xlsx, click OK.
  5. Click Save Save icon. In Save Dataset As, enter medicare_partd_provider_file in Name, and then click OK.


    Description of prepare_recs.png follows
    Description of the illustration prepare_recs.png
  6. Click the medicare_partd_provider_file tab.
  7. Select the pres med column.


    The recommendations list shows enrichments that you can apply to the prescription medication (pres med) column. Oracle Analytics provides these enrichment recommendations using the semantic types in the custom knowledge reference that you added through the Console.

    Description of pres_med_recs.png follows
    Description of the illustration pres_med_recs.png

Learn More