Before you Begin

This 15-minute tutorial shows you how to add a custom image as a map background, and use latitude and longitude coordinates to visualize data points using a heatmap layer in Oracle Analytics.

Background

In Oracle Analytics, you can add an image as a map background to use instead of the default Oracle BI map background. In the map visualization created with the custom image background, you apply a heatmap layer to assist in analyzing the data.

In this tutorial, you use a supermarket floor layout image as the map background. You also use a spreadsheet that contains data points of shopping carts, collected by devices in the store that reveal customer traffic as the shopping carts move throughout the day. You also learn how to use a visualization as a filter.

Adding an image as a map background requires access to the Console Maps page. Contact your administrator for assistance if you don't have permissions to upload an image to use as for a map background.

You need to define the size of the image using latitude and longitude coordinates. The supermarket image is a rectangle that is twice as wide as tall (4963 by 2563 pixels). Convert your image size from pixels into values representing the size of the image, from -90 to +90 range for latitude, and -180 to +180 for longitude.

What Do You Need?

Add Custom Image Map Background

  1. Sign in to Oracle Analytics.
  2. On the Home page, click Navigator Navigator icon, and then click Console.
  3. On the Console page, click Maps.
  4. In Maps, click Backgrounds. Expand Image Backgrounds, and then click Add Image (click, or drag and drop image file) Add Image icon.
  5. In File Upload, locate and select the supermarket.jpg file, and then click Open.
  6. In the supermarket Image Background page, click Auto in the Coordinates list, and then select Custom (lat, long).
  7. In the top row with the green dot in the top right End of image coordinates, enter 45 Latitude, and then enter 90 in Longitude.


    Description of supermarket_image.png follows
    Description of the illustration supermarket_image.png
  8. In Image Background, click Preview.


    Description of supermarket_preview.png follows
    Description of the illustration supermarket_preview.png
  9. Click Save.


    The Maps Image Backgrounds page lists the supermarket image.

    Description of maps_background.png follows
    Description of the illustration maps_background.png
  10. Click Go back Go back icon. Click the Navigator Navigator icon, and then click Home.

Create a Dataset

  1. On the Home page, click Create, and then select Dataset.
  2. In Create Dataset, click Drop file here or click to browse. In File Upload, locate and select the shop_floor_traffic.xlsx file, and then click Open.
  3. In Create Dataset from shop_floor_traffic.xlsx, click OK.
  4. Click Save Save icon. In Save Dataset As, enter shop_floor_traffic in Name, and then click OK.
  5. Click the shop_floor_traffic tab.
  6. In the Pos Y column, click Measure Measure icon, and then select Attribute.
  7. In the Pos X column, click Measure Measure icon, and then select Attribute. Click Save Save icon.


    Description of shop_floor_traf_prepare.png follows
    Description of the illustration shop_floor_traf_prepare.png

Visualize the Data

  1. Click Create Workbook.
  2. From shop_floor_traffic dataset, hold down the Ctrl key, select Pos Y and Pos X. Right-click, select Pick Visualization, and then click Map Map icon.
  3. Click Grammar Grammar icon. Select Pos X in Color and move it to Category (Location) above Pos Y.


    The map visualization shows the data points using the latitude and longitude values on the default (Oracle BI) background.

    Description of data_points_default_map.png follows
    Description of the illustration data_points_default_map.png

Apply the Custom Image Map Background

  1. Click Properties Properties icon. In Pos X, Pos Y properties, click Map Map icon. Click Default (Oracle DataViz) in the Background row, and then select supermarket.


    The data points are too close together to analyze the supermarket traffic.

    Description of supermarket_background.png follows
    Description of the illustration supermarket_background.png
  2. In Pos X, Pos Y properties, click Data Layers Data Layers icon. Click Auto (point) in the Layer Type row, and then select Heatmap.


    The heatmap layer provides a better picture of the store's traffic as measured by cart location. The red and orange to yellow areas show the highest concentration of shoppers.

    Description of heatmap_layer.png follows
    Description of the illustration heatmap_layer.png

Create a Visualization as a Filter

  1. From shop_floor_traffic, hold down the Ctrl key, and select ID and Time of Day.
  2. Right-click, select Pick Visualization, and then select Horizontal Bar Horizontal Bar icon.


    Description of heatmap_time.png follows
    Description of the illustration heatmap_time.png
  3. In the ID by Time of Day visualization, click Menu Menu icon, and then select Use as Filter Use as Filter icon.
  4. In the ID by Time of Day visualization, select Noon to 3PM to view the changes in the heatmap.


    Description of noon_to_3pm.png follows
    Description of the illustration noon_to_3pm.png
  5. In the ID by Time of Day visualization, select 6PM to 10PM to view the changes in the heatmap.


    Description of 6_to_10pm.png follows
    Description of the illustration 6_to_10pm.png

Learn More