What is the google mapping process

Know where - the location analysis with Google Maps

Dear data analysts,

Those who do something “on site” these days or want to get an idea “on site” often mean: at the customer's or where others work. It has almost been forgotten that the phrase comes from a technical language, namely the language of the miners. For them, their place of work is “on site”, at the end of the tunnel, where mining is carried out and the route is driven forward. It's dusty, dark and hot on site. Language critics occasionally rail against this move from technical language to common language, but in business jargon we can live with this inaccuracy. For us, it is more important that we know what is happening there, on site, where work is done and what is done - and often enough: where exactly the places are and what it looks like. Where are you, our branches, customers, patients, workshops, service centers, etc.? Thanks to Google Maps, it is not difficult for us to get a picture of the situation, at least from a bird's eye view. And thanks to the new Location analysis of DeltaMaster it is not difficult to establish a connection to controlling data and to mark not just one but many places in Google Maps. We'll show you how to do this in these clicks!.

Best regards
Your team from Bissantz & Company

As of version 5.4.6, in DeltaMaster an analytical process that you can literally use to bring business intelligence to the streets: the Location analysis. The module integrates Google Maps in DeltaMaster. It shows markings in the electronic road maps or satellite images from Google, which show, for example, the addresses of branches, branches, customers, suppliers, workshops, service centers, real estate, patients and the like.

The Location analysis is the second method in DeltaMaster, with which geographical connections can be examined. The first is that Geo-analysiswhich has long been a part of DeltaMaster is.

The Geo-analysis shows how a certain analysis value is distributed over the area, in the figure, for example, the change in sales from the previous period. Geo-analysis is therefore ideal for examining key figures along regional structures that are reflected in a geographical area, for example the sales organization, sales and procurement markets, catchment areas and the like. In contrast to this, the Location analysis not about areas, but about points (geographic coordinates) on a map. This module is particularly useful for two types of questions:

  • Distribution or concentration: In the map or satellite view of Google Maps, you can quickly see where something is happening. Concentrations can be recognized with the naked eye by the accumulation of markers on the map. A branch retailer, for example, may wonder whether and which competitors are in the vicinity of their own locations. For this purpose, their locations would also have to be recorded in the database, which is often not too difficult because you can find out the addresses from freely accessible sources. Spatial distances can also be estimated.
  • Environment “on site”: Sometimes it is informative to know what it looks like at the location and its immediate surroundings. Is it possible to reach a location on foot from a train station, a subway station, a public parking lot, a sight? Where are rivers, bridges, motorways, expressways, railway lines that open up logistical possibilities or limit walking and driving routes? The satellite view from Google Maps is particularly suitable for this.

To explain how the module works, we have created a small sample application that is shown on the first page. To do this, we recorded and processed the addresses of 191 supermarkets in the urban area of ​​Munich. We will briefly outline this process below.

Before doing your own experiments with the Location analysis of DeltaMaster the module must be activated: The use of Google services requires a separate user agreement. That's why it is Location analysis although in everyone DeltaMaster-Installation from version 5.4.6 available, but must be activated. For licensing and activation, please contact your DeltaMaster-Contact Person. We have summarized some of the information below.

A detailed documentation of the Location analysis can be found in the DeltaMaster deltas! 5.4.6; Here we want to concentrate on the most important usage and setting options.

Get to the data

The Location analysis can be used both with OLAP analysis models and in purely relational models (without OLAP cube, see DeltaMaster clicks! 04/2010). For the sake of simplicity, we decided on the latter in the example application: We entered the addresses in an Excel table. However, the analysis cannot work with the addresses alone - instead, the geographic coordinates are required as latitude and longitude. This information must be determined in advance, for example again with the help of Google. The determination of the coordinates (geocoding) is not part of the Location analysis of DeltaMaster, but we are happy to support you with our own processes and tools. Some operational upstream systems, for example for CRM or in logistics, already include the geographic coordinates in the master data so that they can be easily adopted.

Accesses the Excel table with the addresses and geographic coordinates deltamaster direct to (ImportWizard or. TableWizard). We model the branches as a separate dimension. The latitude and longitude are recorded as member properties. In our relational example model, these are the fields with a yellow column header. The postal code region and number is for the Location analysis itself not required; we have inserted the columns in order to create another dimension that opens up further filter options.

Location analysis settings

If the required data is available, it is necessary to set up the analysis. In particular, must DeltaMaster know in which dimension the objects to be displayed are and where the coordinates were recorded.

To do this, select the Settings the Location analysis on the tab Mapping first the Tuesdaydimension, the hierarchy and the level from you for the locationuse analysis want. deltamaster then shows their element properties in two selection lists. With these you specify in which element properties the Latitude and Degrees of longitude are stored. These settings apply to everyone Location analyzes in the current analysis file.

This completes the basic setup of the analysis process - from now on it is DeltaMaster able to enter markings in the map views obtained from Google.

Filter locations in the View window

As in other cockpits, reports and analysis methods, the objects displayed are based on the elements selected in the window view. In the figure, we have selected the postcode region 81 in the "Area" dimension, which includes the west, south and east of Munich. Accordingly, only the locations located there are shown.

In mode Miner transfer the corresponding object to the by double-clicking on a marker view (Analysis chain technology). In such a sequence, the location analysis becomes an entry point, for example to identify a specific customer, for whom further analyzes and cockpits can be called up, such as a “customer profile” or a scorecard.

Matter of opinion

There are few words to say about how to use the maps from Google Maps. The usual operating methods also apply within DeltaMaster, for example moving the map section using drag & drop and zooming with the mouse wheel or the displayed controls. The context menu and the menu offer further options I would like at.

In all user levels, from Reader until Miner, it is possible between the Card typesmap, satellite, Hybrid and terrain to switch.

The context menu makes it easier to use by looking at the map center on the markers so that all currently selected elements can be seen. The zoom level is adjusted automatically if necessary. In the context menu of the marker there are two special functions for the respective individual object: On the one hand, the map can be zoomed in on the clicked one Zoom markers and center. The larger the step, the closer the view of the object - 0 shows the world map, 21 a few blocks. On the other hand, the card can be automatically set so that a certain Radius (in kilometers) is visible. This is particularly interesting if, for example, you want to examine the immediate vicinity of a branch.

As in almost all analysis methods, you can use the menu view select combined representations. The table shows all of the member properties and measures that you have entered in the Settings selected (see following section).

The map is synchronized with the table: If you point to a line with the mouse, only the associated marker is displayed on the map; all others are hidden.

Eventual Assignment error can also be accessed via the menu view discover. These are objects that could not be entered on the map - mostly because the latitude or longitude is missing or invalid.

The functions described up to now are likely to be of great use for many applications: Finally, you can visualize the "places of the event" from a database in Google Maps. For DeltaMaster the analysis is only just beginning. In particular, these two functions increase the informative value of the representation:

  • The locations can be grouped into categories using different markers.
  • Additional information can be displayed for each location in the “tool tip” or an extended information window (“HTML balloon”). This makes it possible to integrate business indicators from the data model into the display.

Both options are available in the properties (Context menu, menu I would like) groomed. This is possible at all levels, from Reader until Miner.

Categories by adjusting the markers

The markings on the map do not all have to look the same. Rather is DeltaMaster able to use different symbols for the elements depending on the data. This allows the objects to be divided into categories and the relationship between them can be recognized. For example, you could mark your own branches and those of the competition differently, differentiate between customer types, identify the private and commercial use of real estate, group them according to branch codes and the like.

Evaluates to categorize and assign symbols DeltaMaster element properties in turn. In our example we differentiate the supermarkets into discounters and full-range retailers and according to the respective retail chain. Accordingly, we have defined the element properties "Type 1" and "Company 1" and stored there which type of trade or chain the individual supermarkets belong to.

Which element properties can be used for categorization (and for display in "Tooltips" and information windows, see below), you first select in the mode Miner in the Settings the Location analysis on the tab Element ownsheepten / analysisvalues out. Only those properties (and analysis values) that are selected here are in the dialog properties to disposal. This approach has with the step concept of DeltaMaster to do: The Apositions are only in mode Miner edit that properties however in all stages, from Reader until Miner. Thus, a user on the level Miner determine which element properties are to be offered to the users at the other levels, thus relieving them of some of the complexity of the data model.

What the markers look like is in the properties the was standinglocation analysis regulated (context menu, menu I would like): On the tab marker place them Form / content as well as the Behindbase color firmly.

Let's stick with it for now Form / content. If you select your own marker, all objects are drawn with the same symbol. That is true even if you are for Standard marker decide; these are available in two sizes. To categorize, set that the markers according to an element property should be determined and choose which one.

In our example, the element property "Type1" stores whether the supermarket in question is a full-range retailer or a discounter. Again, there are two alternatives to choose from:

  • For the standard sets (Letters A-Z and Numbers 0-99) counts DeltaMaster for each element property value, how many elements have that attribute. The numerically largest group is then marked with “A” (108 discounters), the second largest with “B” (83 full-range retailers) etc. The allocation of symbol and type as well as the respective quantities are in one Learea identified via the context menu or the menu I would like can be shown and hidden. The legend is synchronized with the map: If you point the mouse over an entry, only the associated objects are displayed, for example all full-range retailers.
  • A particularly fine control of the symbols is with the Url property possible. This is an element property that explicitly specifies the image to be used as a marker. The URL can refer to a file in the file system (path and file name, relative file names in relation to the "Markers" directory, see below) or to an image on an intranet or Internet server.

In our example, we have set the element property marker with the initial letters of the retail chains (or another “prominent” letter if the initial letter is ambiguous). The pictures come from the with DeltaMaster supplied symbol set, we just copied them into a separate directory.

Supplied with DeltaMaster contain several symbol collections from which DeltaMaster automatically selects the symbols specified in the properties and which you can also put together into your own collections. The image files are located in the "resMarkers" subdirectory of the installation directory of DeltaMaster, for example in "C: ProgramDeltaMaster 5.4.6resMarkers".

For standard markers and the markers from standard sets that depend on element properties, you can specify the required Background color in the Settingsfirmly select or again bind to an element property that Color property. The symbols supplied are available in the standard colors shown.

This gives you a large selection of different symbols and colors to identify your objects differently. If these are not sufficient, you can use your own image files (preferably in the PNG or GIF formats, both of which are transparent) and save them as Url property specify.

Colors and symbols can be used in parallel to differentiate the objects according to two characteristics. In the illustration opposite, the automatically assigned letters of the standard marker set identify the retail chain, while the automatically selected colors indicate the type of retail (full-range or discounter).

Additional information in "tool tips" and "HTML balloons" (information window)

Also in the properties (Context menu, menu I would like) you control which information is called "Tool tip"And / or in a larger" speech bubble ", the so-called information window or"HTML balloon"Should be displayed when the user hovers over it with the mouse. This allows deep integration with your analysis model: All element properties and analysis values ​​(see above) that were "activated" during setup can be displayed in this way. The element properties and the analysis values ​​are inserted into the "tool tip" or the information window via variables. The available variables can be found in the Note. If a property or a key figure is missing here that you need, add it to the Settings added (see above).

For example, the variable “{en}” is replaced with the name of the element in question.

While the "Tooltip" always outputs pure text, it is in the info window ("HTML balloon“), It is possible to format the output individually and to embed external elements, for example images. The text in the corresponding input field is interpreted as HTML code, so that all options that HTML offers are open to you.

Use of the analyzes

Like any other analysis, a user can use the level Miner Expert also location analyzes as a report in the Briefing folder save it and make it available to other users. For this one is enough Reader-, Viewer-, Pivotizer- or AnalyzerLicense. Saved as an analysis template, bind the Location analysis in combination cockpits.

When exporting to Microsoft Word or PowerPoint, the analysis is inserted into the document as a "screenshot". The "tool tips" and the information windows cannot be transferred. Therefore it may be advisable to go on a combined view to toggle so that you can look up the locations in parallel in a table. When exporting to Microsoft Excel, only the data is transferred that is displayed in the tabular view of the analysis process. The map is also integrated as a fixed image in HTML mails. The "tool tips" are also exported, the information windows ("HTML balloons") not. With the DeltaMaster report server the export can be automated.

Licensing and legal framework

Even if we have all used Google Maps many times and for free: The integration of the service in DeltaMaster is Not free of charge and requires legal regulations. A paid license from Google is required to use the interface to Google Maps. Some companies already use Google Maps in connection with their own applications and have their own so-called "Google Maps API Premier Key". This can also be used for DeltaMaster be used. We would be happy to explain how this works to you individually. DeltaMaster-Customers who do not have their own "Google Maps API Premier Key" can purchase one or use a license via a proxy server that we have acquired specifically for this purpose. This intermediary server retrieves the desired map data from Google Maps. The terms of use for Bissantz & Company and Google Inc. are regulated in a separate user agreement.

The DeltaMaster-Licensing is simple: the user level is required for creating location surveys Miner Expert needed; alternatively, a separate licensing as an extension of the level is also possible Miner professional intended. The use of data stored in the briefing book Locationanalysis- Reporting is in stages Reader, Viewer, Pivotizer and Analyzer possible without special licensing for the DeltaMaster-Module Location analysis. In mode Miner professional will the Location analysis only offered if a separate license is available for it. In mode Miner Expert is the Location analysis always visible. However, it can only be used if the licensing for Google Maps has been set up. Otherwise a corresponding information text will appear. Google Maps licensing - and an internet connection - are required in all cases.


The Location analysis of DeltaMaster with their integration of Google Maps, fascinating possibilities to bring business intelligence closer to the action and to expand the analysis beyond the business indicators to the operational conditions. The module is characterized by the following features.

  • Integration of Google Maps as an analysis or report
  • Markers become dynamic according to the current element selection in the window view set.
  • Analysis chain technology (level Miner): A double click on a marker transfers the object to the view. In this way, further analyzes can be initiated directly from the map view.
  • Instead of the standard markers known from Google, you can display your own symbols on the map.
  • Data-driven design of the markers: symbols and colors can be linked to element properties (member properties) in order to express the affiliation to categories or other characteristics, for example own branches and those of the competitors.
  • Object-specific data from the analysis model can be displayed in "tool tips" or in HTML-formatted information windows, for example business figures from sales controlling.
  • The map view is synchronized with the table view: If the user points with the mouse on an entry in the table, the associated marker is highlighted on the map.
  • Interactive legend: All markers of a category are highlighted without changing the view when the user hovers over the category in the legend with the mouse.
  • Export of map views with markings to Microsoft Office, as a PDF file or as HTML e-mail
  • Automation of report export with the DeltaMaster report server
  • works for OLAP models as well as for relational models, for example Excel files or Access databases
  • Creation of reports in the stage Miner Expert, Also used in Reader, Viewer, Pivotizer and Analyzer

If you have the Location analysis To experience it live or to try it out, simply get in touch with your contact person.