Before You Begin

This tutorial shows you how to create a map visualization with a heatmap layer in Oracle Analytics.

Background

You can create a map visualization with a heatmap layer to identify significant measures such as sales, profits, and losses in regions, product categories and other attributes important for your business. Your map visualization can use latitude and longitude, map-related data such as country and city, system background maps, or custom map layers.

What Do You Need?

Create a Dataset

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

  1. Sign in to Oracle Analytics.
  2. On your home page, click Create and click Dataset.
  3. In Create Dataset click Drop data file here or click to browse. In File Open, select the sample_states_metrics.xlsx file, and then click Open.
  4. In Create Dataset Table from sample_states_metrics.xlsx, click OK.
  5. Click Save. In Save Dataset As, enter sample_states_metrics and then click OK.
  6. In the Join Diagram, click Measure Measure icon in the Latitude column and select Attribute.
  7. Click Measure Measure icon in the Longitude column and select Attribute.


    Description of lat_long_attributes.png follows
    Description of the illustration lat_long_attributes.png
  8. Click Save.

Create a Map Visualization

In this section, you create a workbook and a map visualization using the sample_states_metrics dataset. You change the default map data points to use a heatmap layer type.

  1. Click Create Workbook. Close the Insights panel.
  2. In the Data pane, hold down the Ctrl key, select Latitude, Longitude, and Sales. Right-click, select Pick Visualization and select Map Map visualization icon.
  3. In the Grammar pane, move Longitude to Category (Location) under Latitude.
  4. If Sales shows up in Size, move it to Color in the Grammar pane.


    Description of lat_long_sales_map.png follows
    Description of the illustration lat_long_sales_map.png
  5. In the Grammar pane above Category (Location), click Layer options Layer options icon, select Layer Type, and then click Heatmap.


    Description of sales_heatmap.png follows
    Description of the illustration sales_heatmap.png
  6. Click Properties Properties icon. In Properties, click Map.
  7. Click Off to enable Zoom controls in the map visualization. Click zoom in Zoom in control to view a portion of the map.


    Description of zoom_in_view.png follows
    Description of the illustration zoom_in_view.png
  8. Click Save Save icon. In Save Workbook, enter a Name, and then click Save.

Create a Density Heatmap Layer

In this section, you create a map visualization using city filtered by region to depict sales density on the heatmap layer.

  1. Click Create Canvas. Click the Visualizations Visualizations pane icon pane.
  2. In the Visualizations pane, double-click Map Map Visualization icon.


    Description of empty_map_vis.png follows
    Description of the illustration empty_map_vis.png
  3. Click the Data data pane icon pane, select City and drag it Category (Location) in the Grammar pane.


    Description of city_data_points_map.png follows
    Description of the illustration city_data_points_map.png
  4. In the Grammar pane above Category (Location), click Layer options Layer options icon, select Layer Type, and then click Heatmap.
  5. Click Properties Properties icon. In Properties, click Map map vis icon.
  6. Click Off to enable Zoom controls in the map visualization. Click zoom in Zoom in control to view a portion of the map.
  7. In the Data pane, select Region and drag it to the workbook filter bar. In Region, click Eastern Europe, Northern Europe, Southern Europe, and Western Europe. Click outside the filter dialog.


    Description of city_heatmap.png follows
    Description of the illustration city_heatmap.png
  8. Click Save Save icon.

Learn More