Before you Begin

This 10-minute tutorial shows you how to create a map, change the map's name, background color, and colors representing the sales data element. You also add zoom controls to the map view.

Background

You can create maps to visualize data such as sales by city and country, products purchased in a specific region, and determine where you might need to add sales resources.

What Do You Need?

  • Access to Oracle Analytics Cloud or Oracle Analytics Desktop
  • Download world_cities_data.xlsx to your computer

Create a Dataset

In this section, you create a Dataset and workbook with a spreadsheet data source.

  1. Sign in to Oracle Analytics.
  2. On the Home page, click Create, and then click Dataset.
  3. In Create Dataset, click Drop data file here or click to browse. In Open File, select the world_cities_data.xlsx file, and then click Open.
  4. In Create Dataset Table from world_cities_data.xlsx, click OK.
  5. Click Save. In Save Dataset As, enter world_cities_data in Name, and click OK.


    Description of world_cities_data_set.png follows
    Description of the illustration world_cities_data_set.png
  6. In world_cities_data, click Create Workbook.

Create a Map View

In this section, you select data elements and pick a map visualization to represent the data.

  1. Review the insights about your dataset, and then close the Auto Insights panel.
  2. In the Data panel, hold down the Ctrl key, and then select Country and Sales. Right-click, select Pick Visualization, and then select Map Map view icon.


    Description of default_map.png follows
    Description of the illustration default_map.png

Change the Map

In this section, you change the map background.

  1. Select the map visualization. In the visualization's properties, click Auto in the Title row, select Custom, and then enter World Sales.
  2. In Properties, click Map Map Properties. Click Default (Thematic) in the Background Map row, and then select Oracle BI.


    Description of oracle_bi_map.png follows
    Description of the illustration oracle_bi_map.png

Add Zoom Controls

In this section, you add Zoom Controls to increase (+) or decrease (-) the size of the map.

Change Map Color

In this section, you change the default color used to represent sales data points. You can implement different color options by entering the web color number representing the color that you want to use, or by selecting Manage Assignments from the Color menu.

  1. In the map view, click Menu Menu icon, select Color, select Manage Assignments. In Manage Color Assignments, click Default (Redwood), and then select a Series Color Palette such as Southwest.
  2. Click Edit Edit icon to select a color in the palette, and then click Done.


    Description of new_sales_color.png follows
    Description of the illustration new_sales_color.png

Learn More