Before You Begin

This 10-minute tutorial shows you how to duplicate a multiple table dataset to create a new dataset, apply changes to the dataset, blend two multiple table datasets, and then visualize the data.


In this tutorial, you start with the Sales_History multiple table dataset, duplicate it, remove and add some tables, and save the dataset with a new name, Costs. You create a project with the Costs datasets, add the Sales_History dataset to the project, and then to analyze the data.

This is the second tutorial in the Prepare and Analyze Datasets series in Oracle Analytics. Read the tutorials in the order listed.

What Do You Need?

  • Access to Oracle Analytics
  • Ability to connect to a relational data source such as Oracle Autonomous Data Warehouse or Oracle Database
  • Access to the Sales_History dataset

Duplicate the Sales_History Dataset

  1. Sign in to Oracle Analytics.
  2. On the Home page, select the Sales_History dataset, click the Actions menu, and then select Duplicate.
  3. Select Sales History-Copy, click the Actions menu Actions menu icon, and then select Inspect.
  4. In Name, enter Costs to replace Sales_History-Copy, click Save, and then click Close.
  5. On the Home page, select the Costs dataset, click the Actions menu Actions menu icon, and then select Open.

    Description of sales_history_costs.png follows
    Description of the illustration sales_history_costs.png
  6. In the Join Diagram, hover over the following tables, and then click the X to delete each table:
    • SALES
  7. In the Connections panel, expand the SH schema, hold down the Ctrl key, select the COSTS and PROMOTIONS tables, and then drag them to the Join Diagram.
  8. In the Join Diagram, drag the tables to the COSTS table to create joins.

    Your dataset should look similar. You can move the tables to appear in a different order in the Join Diagram.

    Description of costs_data_set.png follows
    Description of the illustration costs_data_set.png
  9. Click Save Save icon.

Blend the Datasets

  1. In the Costs dataset, click Create Workbook.
  2. In the Visualize page, click Add Add icon, and then click Add Dataset.
  3. In Add Dataset, click Sales_History, and then click Add to Workbook.
  4. Click Data to see the joins between the datasets.

    Description of blended_data_sets.png follows
    Description of the illustration blended_data_sets.png
  5. Click the number on the line between the datasets to edit the joins.
  6. In Blend Data, click the X in the CHANNEL_DESC row to remove this match.
  7. Click Both in the question about which dataset to delete the conformance, and then click OK.

    The number on the match line represents the number of matches between the datasets. Reducing the number of matches between the dataset could improve performance during queries.

    Description of edited_joins.png follows
    Description of the illustration edited_joins.png

Analyze the Data

  1. Click Visualize.
  2. In the Data panel, under the Costs dataset, expand the PRODUCTS and COSTS tables. Under the Sales_History dataset, expand SALES.
  3. Hold down the Ctrl key, and select the following:
    • PROD_SUBCATEGORY from PRODUCTS under the Costs dataset
    • UNIT_COSTS from COSTS under the Costs dataset
    • QUANTITY_SOLD from SALES under the Sales_History dataset
  4. Right-click, select Pick Visualization, and then select Table.

    Description of prod_unit_cost_qnty_sold.png follows
    Description of the illustration prod_unit_cost_qnty_sold.png
  5. In the visualization, click the Menu Actions menu icon, select Edit, and then select Duplicate Visualization.
  6. Select AMOUNT_SOLD from SALES under the Sales_History dataset, drag it to Rows to replace QUANTITY_SOLD.

    Description of two_vizs.png follows
    Description of the illustration two_vizs.png

Learn More