Before You Begin

This tutorial shows you how to create a Sankey visualization to depict flows with thick and thin link lines from a source to a target in Oracle Analytics.

Background

You can use a Sankey visualization to show flows such as website traffic flow, project funding to project costs flow, inventory movement, mechanical process efficiency, budget flow, and population migration between states or between countries.

In this tutorial, your data for a Sankey visualization contains source, target, and value columns. The value column represents the weight of the relationship (value) between the source and target columns. Thick and thin lines depict the weight, the thicker the line the larger the value. The data source must contain one record per row.

You can also create a Sankey visualization In Oracle Analytics with a data source that contains two or more attributes and a measure.

In this tutorial, you create a Sankey visualization with a spreadsheet of prepared data.

What Do You Need?

Create a Dataset

In this section, you create a dataset that has been prepared with values representing the number of links between the source and the target. The number of links between a source and target result in a larger value.

  1. Sign in to Oracle Analytics.
  2. On the Home page, click Create. In Create, click Dataset.
  3. In Create Dataset, click Drop data file here or click to browse. In File Upload, select the sample_income_stmt.xlsx file and click Open.
  4. In Create Dataset Table from sample_income_stmt.xlsx, click OK.


    Description of sample_income_stmt_jd.png follows
    Description of the illustration sample_income_stmt_jd.png
  5. Click Save. In Save Dataset As, enter sample_sankey in Name and click OK.

Create Sankey Visualization

In this section, you use the sample_sankey dataset as the data source for the Sankey visualization.

  1. Click Create Workbook. Close the Auto Insights panel.
  2. In the Data Data pane icon pane, hold down the Ctrl key, select Source, Target, and Value. Right-click, select Pick Visualization, and then select Sankey sankey vis icon.


    Description of sankey_line_width.png follows
    Description of the illustration sankey_line_width.png
  3. In the Grammar grammar pane icon pane, select Value in Size (Link) and move it to Color (Link).


    Instead of width, Value is represented by shade from light to dark. The Sankey visualization has a Value scale showing the range of values.

    Description of sankey_group_by_value.png follows
    Description of the illustration sankey_group_by_value.png
  4. Click Properties Properties icon. On the General tab, click Value in the Group By row and select Column.


    Description of sankey_group_by_column.png follows
    Description of the illustration sankey_group_by_column.png
  5. Click Properties Properties icon. On the General tab, click Column in the Group By row and select Value.
  6. In the Data Data pane icon pane, hold down the Ctrl key, select Source, Target, and Value. Right-click, select Pick Visualization, and then select Table Table icon.
  7. In the table visualization, click Menu visualization menu icon, select Sort By, and then select Custom.
  8. In Sort Order, select Value from the Sort By list, select High to Low, and then click OK.


    Description of sankey_n_table.png follows
    Description of the illustration sankey_n_table.png

Learn More