Territory Organization on Areas
In this workbook we show you how easy it is to create a territory structure with locations based on postal codes. In addition, all territory analyses are presented and an attractive export sheet is generated.
The workbook contains the following sheets:
Planning at area level
On this sheet, you can see a two-stage territory structure with Territories and Regions. The coloring of the Territories is set hierarchically to the superior Regions; so that a simple visual assignment of Territories to the Regions is possible. The Locations of the territories and regions have the same colors as the levels. Additionally, the locations have identified relationships to the Territory locations and Region locations while the Turnovers for Maintenance, Paper, and Cartridges per region are displayed using Bar Charts. The label representing each bar chart region stays below, while the percentage distribution stays above. The Color Legend above the Bar Charts serves to inform the product divisions. The Table Objects for the table "Territories+Customer Base" and "Regions+Customer Base" on the left side of the sheet provide further information on the individual Regions, such as the number of customers and the "Total Turnovers". Since the colors of the territories are in the table object, it can also be a replacement for a legend. Alternatively, you can make a Territory legend, Regions, visible in the Contents control window.
In the data window on the right-hand side, you can switch between the territory work tables "Territories+Customer Base" and "Regions+Customer Base" in the upper area. In the lower area you can switch between the imported table "Customer master", the query "Complete assignment" and the work table "Postal code areas+Customer master".
How you can recreate this map:
- Data for the territory structure (e.g. names of areas and allocations) on the basis of postal code areas.
- Planning Mode and create a Create new territory structure using the wizard.
- Create locationseach for the areas and regions in a separate step.
- In the control window Territory organization via the context menu of the territory locations Show territory locations to superordinate locations Create.
- To the Territory Work Table "Territories", aggregate the customer data of the Customer Master table via Query Edit.
- Selection of the analysis Column diagram for the Regions layer with the settings: Selection of the data column "sales paper", "sales cartridges" and "sales maintenance", with corresponding color design. Set the property Data labeling to "Value" for the labeling of the columns under Details. Mark the column diagrams in the map mark and place them outside the regions and align them align.
- Color Legend for the analysis column chart and set it as the heading over the individual diagrams.
- Table Object for the Territory Work Table "Territories+Customer Base" and make it appealing.
- Table Object for the District Work Table "Regions + Customer Base" and make it appealing.
- Area Legend for the regions.
- Text Box for heading and footnote.
The following tables were used:
- Customer Base
- Territories+Customers
- Regions+Customer Base
District analyses
This sheet contains the four types of district analyses: Distance Zones, Catchment Areas, Key Areas, and Supply Level based on the Territories level. The Territory locations are additionally represented on the map by a gray house. The analyses, via the Territory Organisation control window, become created in the context menu of the levels. Alwaya create a befitting Color Legend and Histogram for the respective district analysis to illustrate the distribution of the individual value classes. Finally, place a Scale on the map to ensure a better estimation of the distances on the map.
The Content control window allows you to switch between district analyses by clicking the round radio buttons. The district analyses are part of a Mutual visibility group, so only one analysis is visible at a time. The legends, histogram, and headings change automatically as they are in a Simultaneous visibility group with the respective district analysis. The symbols for the locations of the customers can also be made visible on the map.
How you can recreate this map:
- Drag the level "Areas" and "Area locations" of the Territory structure from the control window Area organisation onto the map.
- Select analysis distance zones in the layer context menu area locations, column settings (distance to location) and maintain colors that are class user defined classified (7 zones 20 km wide).
- Select the analysis Catchment areas in the context menu of the level Territory locations, set the property Calculation with Territory comparability to Territory-related evaluation (percentage), set the data column to "Total sales", retain the color settings and the classes.
- Select the analysis key areas in the context menu of the level areas, set the property Calculation with comparability of territories to territory-related evaluation (percentage), set the data column to "Total sales", keep the settings of the color and the classes.
- Select the analysis Coverage level Starting from the Territory locations, set the property Calculation of Capacity to "50" and select Distance to location as column, keep colors and classes.
- Insert Color legend andHistogram for each territory analysis and Content the Headline adjust if necessary.
- Text Box for the heading for each analysis.
- Simultaneous visibility group for each analysis with the corresponding heading, the histogram and legend are already internally linked to the analysis.
- Alternating visibility group for the territory analyses, so that only one territory analysis with the explanations is visible at a time.
- Select the analysis symbols with the settings: Analysis first couple, select the column "Classification" and classify according to feature, determine symbol, color and size for the respective feature.
- Combined Legend for the analysis Insert symbols.
- Scale for further designs.
- Group for the individual territory analyses and move one heading, one legend and one histogram each.
The following tables were used:
- Customer Base
-
Postal Code Areas + Customer Base
Export sheet with report
This sheet shows you an optimized representation of a map with a Report for exports to other formats, such as EasyMap Xplorer, Image files, or Office formats. To view the report, right-click on Report on regions in the Contents control window and select Show Report Preview from the context menu.
On the map, the Territories - Surfaces as well as the Territory Locations and Region Locations are visible. The customers are visualized as symbol analysis and classified according to the customer category A, B and C. Two circles with a radius of 20 and 40 km respectively can be seen starting from the Region locations and, if required, can be made visible in the Content control window.
On the left side, you will find other types of processed information. The Customer Classification block consists of Table objects, Graphic files, and Texts. The block turnover indicators consist of Individual charts and Legends. The key figures of the territory are in a Table Object. An Inset map, which highlights the section where the region is situated, you will find below. Graphic files and Texts serve to explain the locations.
How you can recreate this map:
- Drag the level "Areas" and "Area locations" of the Territory structure from the control window Area organisation onto the map.
- Select the Symbols analysis, Setting: link Color, Size and Symbols, Symbol via column "Classification" with one color, shape and size each for the three attributes.
- Selection of the analysis Circles, two separate analyses for the radius 20 km and 40 km, in the settings Data column none set and at Radius enter the respective value, Border color set to black, in the details the Fill set to no color.
- Report on regions create, Controlling level: Regions - Surfaces, Set Output Details, Link Data.
- Report heading 1 by setting own texts around the macro for {Report.ElementName} {Report.CurrentName}.
- For an attractive grouping of the individual objects on the sheet, insert Groups and use them as Frame. To do this, set the Color of the Frame to a subtle gray in the properties of the group. Then move the other objects.
- The Customer Classification group consists of three Graphics and a Text for a legend replacement of the symbol analysis, four modified Tabel Objekten that only show the sum and the column caption, and a Text for the heading.
- The Turnover indicators group consists of two Individual Pie charts with a legend for one of the two Pie charts and an Individual Bar chart. Here, you can set the heading from the heading of the indívidual Bar chart. The individual Bar chart uses the "Regions + Customer Base" table. It evaluates three products (maintenance, paper, and cartridges). The label indicates the absolute turnover figures. The individual pie chart to the left also uses the "Regions + Customer Base" table. It also evaluates the same three products (Maintenance, Paper, and Cartridges). The label, however, indicates the percentage turnover ratio. The individual pie chart on the right also uses the "Regions + Customer Base" table but only shows the sum of turnovers per region.
- The territory key figures are in a Table Object that has been accordingly modified in the "Territory + Customer Base" table.
- Inset Map add and make the settings according to our tips and tricks Report with inset map.
- Graphics and Texts are used for the explanations of the Regional Manager and Sales Representatives.
- As Graphic add a company logo and move it to the desired position.
The following tables were used:
- Customer Base
- Regional Locations
- Territories+Customers
- Regions+Customer Base