Before You Begin

In this 10-minute tutorial, you learn how to apply enrichments to your dataset using a custom knowledge reference file that was uploaded by your Oracle Analytics Administrator.

Background

A custom knowledge reference file enables creating semantic types that can provide classification and enrichment recommendations for your data. The custom semantic types augment the system knowledge semantic types used to identify and profile data. For example, after your Administrator uploads the custom knowledge reference file with standardized names, Oracle Analytics automatically detects the columns containing the related data, and provides recommendations to standardize all of the applicable names in the dataset.

Using system knowledge references and any applicable custom knowledge references, Oracle Analytics provides enrichment and transformation recommendations for your dataset. System knowledge includes the names of cities, countries, provinces, and states.

In this tutorial, you create a dataset, apply custom knowledge enrichment recommendations, and create visualizations with the enriched dataset.

What Do You Need?

Create a Dataset

  1. Sign in to Oracle Analytics.
  2. On the Home page, click Create, and then click 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.
  6. Click the medicare_partd_provider_file tab.


    The Recommendations list shows the total number of enrichments that you can add to the dataset.

    Description of create_custom_know.png follows
    Description of the illustration create_custom_know.png

Apply Enrichment Recommendations

  1. In the medicare_partd_provider_file dataset, select the provider zip column. In the Recommendations list, click Enrich provider zip with State.


    Oracle Analytics uses system knowledge to profile the data providing the recommendations for the provider zip column.

    Description of provider_zip_state.png follows
    Description of the illustration /provider_zip_state.png
  2. Select the pres med column. In the Recommendations list, select Enrich pres med with usp_class.


    The usp_class enrichment provides a way to identify the prescription medications by class.

    Description of pres_med_usp_classpng follows
    Description of the illustration pres_med_usp_class.png
  3. Click Save.

Analyze the Data

In this section, you use the enriched dataset to find the providers that are outliers in prescribing opioids.

  1. Click Create Workbook.
  2. In the Data panel, hold down the Ctrl key, select provider_zip_State and total_claim_count. Right-click, select Pick Visualization, and then click Map .
  3. Click Properties Properties icon. In Properties, click Map Map Properies icon. Click Default (Thematic) in the Map Background row, and then select Oracle BI.


    The map shows the distribution of prescribed medications by state. California, Texas, and Florida have medical providers who write the most prescriptions.

    Description of pres_med_map.png follows
    Description of the illustration pres_med_usp_class.png

Filter the Data

In this section, you use the pres_med_usp_class data element to filter on opioids, and then find the medical providers who are writing the most prescriptions for opioids.

  1. Click Add Filter Add Filter icon. From the list, select the pres_med_usp_class column, and then enter opioid to search for the opioid class of medications. Click to select each opioid usp class or click Select All.


    Oracle Analytics updates the map visualization with the filter on opioids. Florida has the highest level of prescriptions for opioids followed by New York, California, and Texas.

    Description of opioid_providers.png follows
    Description of the illustration opioid_providers.png
  2. Right-click Florida, and then select Keep Selected.


    Description of drill_to_florida.png follows
    Description of the illustration drill_to_florida.png
  3. In the Data panel, hold down the Ctrl key, select total_claim_count and provide in. Drag and release the data elements on the canvas when a thick green line appears next to the map visualization.


    The bar visualization shows that Dr. Heroinsky prescribes opioids more often than other providers in Florida.

    Description of florida_providers.png follows
    Description of the illustration florida_providers.png

Learn More