Analyze

This workbook contains various analyses on different tables. In addition to maps on German postal codes, this workbook also contains evaluations on Austrian and Swiss postal codes. So that you can assign the tables to the correct countries, the sheets and tables are provided with a two-character country abbreviation.

The workbook contains the following sheets:

Distribution of sales DE
Trade and transport DE
Purchasing Power Europe
Population pyramids AT
Boston Grid CH
Radio station AT

Distribution of sales DE

This sheet shows you a Heatmap sales potential and the sales trend in postal zone 2 of Germany. There is also an inset map section of Hamburg. The Color legend of the heatmap, depicts where there is a high sales concentration and where not.

Via the Content control window, you can also display the sales distribution as Area Shading, Total Turnover or as Symbols, Customers. All three analyses are based on the same data column of the table "Customer Base DE" and can be selected by clicking on the radio button, as these are in the same visibility group. The map view is reduced to the essential by deleting the topographic levels such as motorways, federal roads, rivers and bodies of water.

Trade and transport DE

This sheet shows the relationship between dealers and transport chains displayed via Relations analysis and Symbols analysis. The postcode areas in postal zone 2 serve as the map basis. In the Content control window, you can switch between the dealer relationship with dealer locations and the transportation chain with logistics centers by selecting one of the analyses for relations. The relations analyses and symbols analyses are both Mutual visibility and Simultaneous visibility grouped and show you the interaction of the different visibility groups. To better estimate the distances between the locations, a Scale is inserted on the sheet.

Since the Relations analysis is the focus of attention, topographical levels are, therefore, not included in the map. The Internet map in grey tones provides better spatial orientation.

List of used settings

How you can recreate this map:

Dealers relationships: Select the Relations analysis with the data column "Distance (in km)" to ensure a uniform dashings. Color the attributes after the data column "Dealers". Based on "Distance (in km)", choose a user-defined classification, and then specify the line width in five value classes.
Dealers locations: Select the Symbols analysis with the data column "Dealers". Then customize your classification according to attribute, color, shape and size.
Transport chains: Selection of analysis Relations with column "TEU", four classes with a user-defined classification.
Logistics centers: Selection of the analysis Symbols with the data column "Location" and a classification according to characteristic.
A combined legend was inserted for the dealer locations as well as for the relations of the transport chain.
The analyses of the traders (symbols and relationships) were packed into a Simultaneous visibility group. A further simultaneous visibility group was formed for the logistics centres and the transport chain, then to form a mutual visibility group with the other simultaneous visibility group.
Drag a Internet map onto the map and select the BKG WebAtlasDE.light in grayscale.
Insert a Scale from the control window Objects onto the sheet and in the settings select the Number of Sectors to 5 with a Total Width 50 km and a Sector Width of 10.
Insert Text for header and footer.

The following tables were used:

Transport chain - DE
Dealer relationships - DE

Purchasing Power Europe

The map shows a section of Europe postal regions of Slovakia, Ukraine, Hungary, and Romania. The purchasing power of hay per Million Euro represents the coloring of an area.

The table object summarizes the most important key figures for the individual countries. To make the table on the map more compact, we created a query on the imported table, using the purchasing power indices for 2-digit postal code regions and then aggregated them for the individual countries.

Population pyramids AT

This sheet shows the age distribution by gender and the population distribution at the level of the Austrian postal code regions. Several Area Shadings and Bar Charts were combined here. For a better understanding of the data, Tooltips, which display information when running the mouse over the map, were added.

At the level of the regional postal codes of AT, there is an Area Shading for the overall view. However, the Area Shading changes to the postal codes level of AT; when you zoomed into the map. You can only achieve this visibility change with the Automatic Zoom; by setting the Area Shadings to different Level of Visibilities. The color legend varies according to the different analysis level of Visibilities, and it only appears when the associated analysis is displayed. By zooming into the map, you can easily see the behaviors of the Area Shadings.

The Bar chart analysis is used twice to obtain the age distribution of men and women. The chart depicting women grows to the right while for the men to the left. Create a population pyramid by aligning the two bar charts. Both Color legends are positioned next to each other, enabling the use of only one label for both diagrams. This way, the map does not appear too overloaded.

A Stand-alone chart highlights the difference in the age between men and women.

List of used settings

How you can recreate this map:

Select the Area Shading analysis at the level of the region postal codes and in the Settings: Using the "Inhabitants" data column, select the classification Equidistributed, insert Tooltip with the number of inhabitants.
Select the Area Shading analysis at the level of the territory postal codes and in the Settings: Using the "Inhabitants" data column, select the classification Equidistributed, insert Tooltip with the number of inhabitants.
In the Content control window, adjust the Scale Ranges to match the two Area Shadings.
Select the Column Chart analysis and in the Settings: Select all data columns for the age groups of men, Color gradient from light blue for the youngest to dark blue for the oldest age group, in the Details set the alignment of the bars to the left.
Select the Column Chart analysis and in the Settings: Select all the data columns for the age groups of the women, Color gradient from light red for the youngest to dark red for the oldest age group, in the Details set the alignment of the bars to the right.
Select the Stand-alone of the object, and in the Settings: Select the table "Population data Austria", Pie Chart, Number of data columns to 2, select the data column "Age from 85 (each for men/women)" and set the Color, Size and Format of the chart.
Color Legend Add the Area Shadings and Bar Charts. Then position the Men and Women Bar Charts legends next to each other.
Text Box for header and footer.

The following tables were used:

Population data - AT

Boston Grid CH

This sheet depicts a Boston Grid analysis containing the "average income" and "population density" as the variables for the postal code areas of postal zone 9 in Switzerland and Liechtenstein. It is easy, for example, to identify areas with a high average income and a high population density. Create an Area Shading and a Histogram for each of the variables. Set the three surface analyses to the mutual visibility settings. To better understand the data, Tooltips, which display information when running your mouse on the map, were added to the analyses.

Radio station AT

This sheet shows broadcasting areas and radio houses of different radio stations in the Austrian postcode zone 3. Overlaps of the broadcasting areas are shown by means of area hatching within Lower Austria. For area hatching, the areas with several assignments must also be available several times as single rows in the table, because this is the only way to display an area hatched. The radio stations are shown as symbol analysis. In addition, population figures are visible in counting diagrams.