Before you Begin

This 15-minute tutorial shows you how to use a connection to an Oracle Autonomous Data Warehouse to create a multiple table dataset and visualizations.

Background

This tutorial uses a connection to Oracle Autonomous Data Warehouse from Oracle Analytics. You create a dataset using the sample SH schema in Oracle Autonomous Data Warehouse, and then you create visualizations to analyze the sales history data of an electronics store.

What Do You Need?

Create an Oracle Autonomous Data Warehouse Dataset

This section shows you how to create a dataset from a connection to Oracle Autonomous Data Warehouse. The sample SH schema uses well-defined relationships so that you can create the dataset with the Auto Join Tables option enabled.

  1. Sign in to Oracle Analytics.
  2. On the Home page, click Create, and then click Dataset.
  3. In Create Dataset, click your Oracle Autonomous Data Warehouse connection.
  4. In the Connections panel, expand the SH schema.
  5. Hold down the Ctrl key, click the CUSTOMERS, SALES, PRODUCTS, COUNTRIES and TIMES tables, and then drag and drop them on the Join Diagram.
  6. Click Save. In Save Dataset As, enter Sales_History, and then click OK.


    Description of sales_history.png follows
    Description of the illustration sales_history.png

Create Your First Visualization

  1. Click Create Workbook.
  2. In the Data pane, expand the PRODUCTS folder.


    Description of oac_adw_data_set.png follows
    Description of the illustration oac_adw_data_set.png
  3. Hold down the Ctrl key, select PROD_NAME and PROD_CATEGORY from the PRODUCTS folder and drag the data elements to the canvas.


    Oracle Analytics creates a table visualization.

  4. Expand the SALES folder. Hold down the Ctrl key, select AMOUNT_SOLD and QUANTITY_SOLD from the SALES folder and drag the data elements to the table visualization.
  5. Expand the TIMES and expand the TIME_ID folders. Hold down the Ctrl key, select Year from the the TIME_ID folder, and then drag the data element to the table visualization.
  6. In the Grammar pane, select Scatter Scatter icon from the visualization type list List icon.


    Description of scatter_vis.png follows
    Description of the illustration scatter_vis.png
  7. In Category (Points), select TIME_ID (Year) and move it to Color. Select PROD_CATEGORY and move it to Shape.
    Description of sales_summary.png follows
    Description of the illustration sales_summary.png
  8. Click Properties Properties pane icon, click Auto in the Title row, select Custom, and then enter Sales Summary.
  9. Click Save. In Save Workbook, enter Sales History WBK in Name, and then click Save.

Create a Visualization to Sales for Each Month

In this section you create a visualization that answers the question, "What are my monthly sales by dollar and quantity sold?"

  1. In the Data pane, hold down the Ctrl key, and select the following:
    • AMOUNT_SOLD
    • QUANTITY_SOLD
    • Month
  2. Drag the data elements next to the existing visualization, and release when a thick green line appears in the canvas.

    Oracle Analytics automatically creates a Stacked Area visualization.

    Description of sales_by_month.png follows
    Description of the illustration sales_by_month.png
  3. Click Visualization Type Visualization Type icon, and select Combo Combo visualization icon.
  4. In the Grammar panel, right-click QUANTITY_SOLD, and select Bar.
  5. Click Properties Properties icon. In the General tab, click Auto in the Title row, click Custom, and then enter Sales by Month.
    Description of bar_sales_by_month.png follows
    Description of the illustration bar_sales_by_month.png
  6. In the Sales by Month visualization, click Menu Menu icon, select Add Statistics, and then click Trend Line. Click Save.
    Description of sales_by_month_trend.png follows
    Description of the illustration sales_by_month_trend.png

Learn More