Displaying Data in GeoMap

Objective

After completing this lesson, you will be able to apply geomaps to graphically represent geographic data in a Web Intelligence document.

Geomaps

A geographical chart in Web Intelligence is a strong and interactive tool that lets you show business data on a map.

Instead of displaying data in tables or charts, a geographical chart plots measures such as sales, profit, or customer count against geographic dimensions like countries, states, or cities.

This changes raw, location-based data into a clear visual story. You can easily spot regional trends, outliers, and patterns.

You can qualify your data using either the name of a location or its latitude and longitude.

Screenshot 1: Three US maps compare Geo Choropleth, Geo Bubble, and Geo Pie visualizations, each representing regional data values with color, bubble size, or pie charts.

Geo-Qualifying an Object Using a Location's Name

To define your dimension type object as a geographical object, select the dimension from the Objects tab. Then, select More OptionsGeo-Qualify By Name.

Web Intelligence matches each value in the object to a geographic location.

The search engine groups values into three categories and matches them to locations using matching rules:

  • Resolved: Only one location matches at 100 percent. The system automatically assigns this location to the value.
  • Unresolved: Several locations match at 100 percent or between 86 and 99 percent. No clear match is found. You must select the most appropriate location.
  • Missing: No location is found, or all locations match at less than 85 percent. Search for the location you want to assign in the geographical database.
The Geo-Qualify By: Name option is selected from the State field menu, mapping state names to geographic locations in the summary table.

Geo-Qualifying an Object Using a Location's Latitude and Longitude Coordinates

To define your dimension type object as a geographical object, select the dimension from the Objects tab. Then, select More OptionsGeo-Qualify By Latitude / Longitude.

Latitude and longitude coordinates must be available as dimensions, attributes, or variables. The latitude and longitude coordinates do not need to be the same type of object. For example, you can use latitude as a dimension and longitude as a variable. Both coordinates must be of the Number data type.

Insert a Geographical Chart

To insert a geographical chart, use the Quick Access, Build, and Main panels.

A red error message states no dimension with geographic mapping is defined, with instructions to assign the State field as the geographic location.

Let's Summarize What You've Learned

  • Use geographical charts in Web Intelligence to compare data by location.
  • Geo-qualify data using either location names or latitude and longitude coordinates.
  • The system categorizes matches as resolved, unresolved, or missing based on location accuracy.

Design Web Intelligence Reports: Charts

Business Example

Your manager asks you to analyze sales trends over the past few years, broken down by quarter, using a column chart and to analyze the distribution of sales by state using a geo choropleth to identify the best-performing states.