Before You Begin

This tutorial shows you how to create a map visualization that uses lines connecting the latitude and longitude of source and destination points.

Background

Oracle Analytics uses a dynamic lines map layer to shows the connections between points. Your data source must contain source and destination columns along with the related latitude and longitude columns for each source and destination.

When there are multiple sources and destinations, you can use filters to specify the specific source or destinations shown in the map visualization.

What Do You Need?

Create a Dataset

In this section, you use the airlines_route.xlsx file to create a dataset.

  1. Sign in to Oracle Analytics.
  2. On the Home page, click Create and select Dataset.
  3. In Create Dataset, click Drop data file here or click to browse. In File Upload, click airline_routes.xlsx and click Open. In Create Dataset Table from airline_routes.xlsx, click OK.
  4. In the Join Diagram, select Source Airport Latitude, click Measure measure icon, and then select Attribute attribute icon.
  5. Select Source Airport Longitude, click Measure measure icon, and then select Attribute attribute icon.
  6. Select Target Airport Latitude, click Measure measure icon, and then select Attribute attribute icon.
  7. Select Target Airport Longitude, click Measure measure icon, and then select Attribute attribute icon.


    Description of lat_long_col_attributes.png follows
    Description of the illustration lat_long_col_attributes.png
  8. Click Save Save icon. In Save Dataset As, enter airline_routes in Name and click OK.

Create a Map Visualization

In this section, you use the airline_routes dataset to create a map visualization with dynamic lines.

  1. Click Create Workbook. Close the Insights panel.
  2. Click the Visualizations Visualizations pane icon pane. In the Visualizations pane, drag the Map map visualization icon visualization to the canvas.


    Description of map_no_data.png follows
    Description of the illustration map_no_data.png
  3. In the Grammar grammar panel icon panel next to Layer 1, click Layer Options Layer options icon, select Layer Type, and then select Dynamic Line.
  4. Click the Data Data pane icon pane.
  5. In the Data pane, hold down the Ctrl key, select Source Airport Latitude and Source Airport Longitude. Drag the data elements to Category (Start Node) in the Grammar panel.
  6. In the Data pane, hold down the Ctrl key, select Target Airport Latitude and Target Airport Longitude. Drag the data elements to Category (End Node) in the Grammar panel.


    Description of all_routes.png follows
    Description of the illustration all_routes.png

Filter the Data

In this section, you create a workbook filter to improve the map visualization's usefulness.

  1. In the Data Data pane icon pane, select Source_Airport and drag it to the workbook filter bar.
  2. In the SOURCE_AIRPORT filter, enter LAX in Search and click LAX to move it to the Selections list. Click outside the dialog.


    Description of lax_destinations.png follows
    Description of the illustration lax_destinations.png
  3. Click Properties Properties icon. In Properties, click Auto in the Title row and select Custom. Delete the default title and enter Los Angeles Airline Destinations.
  4. Click Layers Layers icon.
  5. In the Size row, click 8 and use the slider to reduce the line to 3.
  6. Click Grammar Grammar icon.
  7. Click Data Data pane icon. In the Data pane, select DESTINATION_AIRPORT and drag it to Color in the Grammar panel.


    Description of lax_routes_color.png follows
    Description of the illustration lax_routes_color.png

Change the Dynamic Line Type

  1. In the workbook filter bar, click SOURCE_AIRPORT. In the SOURCE_AIRPORT filter dialog, click Clear.
  2. In Search, enter BHM, click BHM and then click outside the dialog.
  3. In Properties, click General Properties General icon. In the Title Row, enter Birmingham, AL to replace Los Angeles in the Title.
  4. In Properties, click Layers Layers icon. In the Line Shape row, click Straight and select Curved.
  5. In the Directional Arrows row, click Off to add arrows to destinations on the dynamic lines.
  6. In Properties, click Map Map icon. In the Zoom Control row, click Off to add zoom controls to the visualization.


    Description of bhm_destinations.png follows
    Description of the illustration bhm_destinations.png

Learn More