Geo Data Analysis on Dashboards

Explore options to visualize, drill-down and slice your geographicaly related data. Kyubit dashboards is great place to analyze data related to countries, regions, cities or additionally custom created locations in Kyubit application.

Display Measure as Color Gradient

Presents values from analysis or query results as a single color gradients on the selected geo map. Simple way to visualize influence of the selected values geographically.

Display dominant series with separate colors

In this mode each country/region is displayed with the separate color, depending on the series with highest value. This is convenient way to quickly identify which series of values is most influential in specific country/region. For example, election results. To enable this option, open Tile -> Edit -> Options -> (check) Dominant Series Colors

Display values related to specific geographic locations

To display values related to cities or any other geographic locations related to your data, use data set 'Markers' defined in Tile -> Edit -> Options -> Markers section. Kyubit with setup automatically deploys 7300 largest cities in the world. If your data includes places and geo location not included in initial set of 7300 biggest cities, you can easily add locations in 'Geo Location Management' application section (explained below).

Geo Locations Management

To manage all geo locations in Kyubit application, go to Administration -> Geo Locations section. Kyubit Administrator has rights to add, change or delete geo locations in the system. After Kyubit BI setup, automatically 7300 largest cities are loaded to Geo locations, while administrator can manage all entries at any time. In the Geo Location section administrator can search all geo locations by location name or country/group field, quickly visualize all geo location from same country/group, delete existing or add new geo location entries that will be immediately ready for usage in geo location visualizations and analysis.

Adding multiple Geo Locations

If there are many geo locations with known name and geographical position you wish to add more quickly, it is possible to directly add new rows in Kyubit internal database 'KyubitAnalysisDB', table 'GeoLocations', which is straightforward to comprehend and maintain.

'Quick Explore' with Geo Data

Set dimension of interest to become 'Quick Explore' dimension for particular geo map on the dashboard. While configuring Dashboard tile choose one of the available dimensions from analytic data source (OLAP cube or Analytic Model).

Drill down Geo map data

If Geo map use OLAP data, Geo map tile has option to drill down geo map areas to its child geo map representation. Continents are drill down to countries, countries are drill down to regions. Analyzing geo data on dashboard becomes perceptual and comprehensive. Within few clicks users isolates and observes data in geographical form, that could be easily exported to PDF file or share with other users.

Available Geo maps

With every new version of Kyubit Business Intelligence application, more countries and regions are available to use by Geo Maps feature on the dashboards. All Continents and largest countries with their regions are available, but also Kyubit will provide Geo maps for other countries and regions of your interest. Please, contact us for more details when country or region of your interest will be available.

Currently available maps: Contintents, World, Europe, North America, South America, Asia, Africa, Oceania, USA, Russia, India, France, Germany, UK, Netherlands, Norway, Spain, Switzerland, Italy, Australia, Thailand, Austria, Australia, Turkey, Saudi Arabia, Denmark, Egypt, Portugal, Brazil, Hong Kong, Indonesia and Ohio State (US).
More countries and regions are expected soon.
Check latest section of Dashboards user manual to see all countries/regions and codes and names that could be used to render SQL and OLAP data.