Before you Begin

This tutorial shows you how to adjust the size of data points in map visualizations in Oracle Analytics.

Background

In this tutorial, you associate latitude and longitude data columns with a map background, create a map visualization, and adjust the size of the data points in the map visualization.

When the data point bubbles are all the same size and use a graduated color scale, it's hard to see any data differences. You can mitigate this issue by changing the size of the bubbles that represent the data points.

What Do You Need?

  • Access to Oracle Analytics
  • Download donation.xlsx to your computer

Create a Dataset and Specify the Location Columns

In this section, you create a dataset using the donation spreadsheet file. When numerical data is loaded, it's treated as a measure. You need to change the Treat as value property in the SCH_LATITUDE and SCH_LONGITUDE columns to attributes so that you can associate them with a latitude and longitude map layer.

  1. Sign in to Oracle Analytics.
  2. On the Home page, click Create, and then click Dataset. In Create Dataset, click Drop data file here or click to browse, select the donation.xlsx file, and then click Open.
  3. In Create Dataset Table from donation.xlsx, click OK.
  4. In New Dataset, click the donation tab.
  5. Click the SCH_LATITUDE column. In Properties, click Measure in the Treat As row, and then select Attribute. In the SCH_LATITUDE column, click Options Options icon, select Location Details.
  6. In Location Details: SCH_LATITUDE, when the Map Layer field contains Latitude, Longitude and the Location Type contains Latitude, click OK.
  7. Click the SCH_LONGITUDE column. In Properties, click Measure in the Treat As row, and then select Attribute. In the SCH_LONGITUDE column, click Options Options icon, select Location Details.
  8. In Location Details: SCH_LONGITUDE, when the Map Layer field contains Latitude, Longitude and the Location Type contains Longitude, click OK.


    Description of geo_cols.png follows
    Description of the illustration geo_cols.png
  9. Click Save Save icon. In Save Dataset As, enter donations in Name, and then click OK.

Create a Map Visualization

In this section, you create a map visualization with data points for total donations at the latitude and longitude locations.

  1. In the donations dataset, click Create Workbook.
  2. Close the Auto Insights panel.
  3. In the Data panel, hold down the Ctrl key, select SCH_LATITUDE, SCH_LONGITUDE, TOTAL_DONATIONS, and then drag them to the canvas.


    The data points cover most of the lower United States making the size of the donation at each location hard to determine.

    Description of donations_map.png follows
    Description of the illustration donations_map.png

Modify the Map and Data Point Size

In this section, you change the map background and default colors to enhance the data points, and enable zoom control in the map visualization.

You don't need to implement the map background and default color changes to change the data point size.

  1. Click Properties Properties icon. Click Map Map icon tab.
  2. Click Off in the Zoom Control row to enable zooming in the visualization.
  3. In the Background Map row, click Default (Oracle BI), and then select Oracle Maps.
  4. Click Zoom in Zoom in icon to focus visualization to show the densest data points.
  5. In the visualization, click Menu, select Color, and then select Manage Assignments to change the color gradient used with the data points.
  6. In Manage Color Assignments under Series (Measures), click Presets Presets icon, and then select Viridis. Click Done.


    Description of map_new_colors.png follows
    Description of the illustration map_new_colors.png
  7. In the Properties panel, click Data Layers Data layers icon.
  8. Click 18 in the Size row, use the slider to move to 6 pixels or enter 6 in the field.


    Description of smaller_data_points.png follows
    Description of the illustration smaller_data_points.png

Configure Data Point Measure Size

  1. Use Zoom in Zoom in icon to focus the map visualization on the Chicago area or another dense data point area.


    Because all of the data points are the same size, it's hard to tell which locations have the most donations.

    Description of chicago_datapoints.png follows
    Description of the illustration chicago_datapoints.png
  2. Click Grammar Grammar pane icon. In the Data panel, drag NUM_DONORS to Size in the Grammar pane.
  3. Click Properties Properties icon. Click Data Layers Data layers icon.
  4. In Min Size, enter 4 to replace the 5. In Max Size, enter 25 to replace 20.


    The size minimum and maximum updates the data points using larger bubbles for locations with a larger number of donors.

    Description of total_donors_donations.png follows
    Description of the illustration total_donors_donations.png
  5. Click Save to keep your workbook for review at another time.

Learn More