Excel Maps, Geoanalysis, GIS System

The Excel Map application is a perfect tool for visualising territorial division of a company or organisation. Especially, when the division is aligned with administrative boarders (provinces, municipalities). The Excel Map enables to create any hierarchy, like macro-regions, regions or areas of responsibility of individuals.  Based on our expertise on the structure of the application and data visualisation:

• we design maps which depict territorial division and allow to report data on such a map
• we use data from IT systems (especially postcodes or addresses) in order to present business indicators (e.g. achievement of sales target, generated sales revenue, product distribution)
• we optimise territorial division in accordance with business needs
• we adjust source data for depicting them on a map
• we automate the reporting process in the application with the use of macros
• we create additional interactions

The Excel Map is not only an application which enables to visualise data on the map of Poland divided into provinces, poviats and municipalities but also an universal map that allows the creation of maps of any area. After receiving or indicating a contour map (e.g. of a city, area of local authority or other areas), we have the ability to transform it into an Excel Map with all required functionalities, like cartogram, bubble chart or postcodes. In this way we created maps of the biggest Polish cities with division into districts (Warsaw, Poznan, Cracow, Wroclaw, Katowice, Szczecin, Torun) or maps of warehouses and buildings. Such map can be used for visualising, analysis of data or regular reporting. The activities which we perform include, among others,:

• Vectorisation of contour maps or drawing them on the basis of guidelines
• Programming of maps in Excel
• Development of mechanisms of source data export and their visualisation

By using different mapping technologies we can provide any, even the most advanced data analysis which will combine a map and analyses of numerical data in the form of an interactive interface. Users of the report can touch any point of their data, select on the map using a rectangular, circular or lasso region and filter data while keeping an uninterrupted view on the map of the area.  We can also prepare an interactive report, ready to be embedded on a website, which includes designed interactions. The available interactions can be tested on an exemplary visualisation placed below. We have completed projects from this area which involved questions including:

• Presentation of tens of thousands of commercial points divided into networks and channels together with their turnover
• Drawing ranges in kilometres and assignment of commercial points to the closest traders
• Optimisation of routes of traders and route management
• Solving the multi stop problem
• Creating flow map (of goods, fleet, routes) on the map
• Analysis of marketing data with division into provinces, poviats, municipalities, districts, postcodes, and even quarters of the streets in big cities with reference to the number of residents and marketing potential
• Data visualisation of nationwide research and survey
• Creation of geographical breakdown of company’s commercial structure
• Reports on maps of buildings (warehouses, shopping centres, office centres) – e.g. flow of people or goods

Gecoding is the process of assigning coordinates (geographical latitude and longitude) to postal addresses.  This activity is the first step to depict information and data on maps. In the process of geocoding we base on proven algorithms and a multimillion base of addresses. We can also cope with incomplete addresses (e.g. spelling mistakes, no postcode or just a postcode).

We create dedicated GIS solutions in the form of web applications for individuals and companies having greater needs regarding management of spatial data, their visualisation and reporting. The GIS software allows the creation of any set of analyses and reports and the map, creation of own layers and their management, and work via a desktop application or a website. The service has the greatest range of options of changing background maps, automatic geocoding or presentation of data on the map. GIS services are highly tailored to user’s needs, both when concerning matching the application with the requirements and adjustment of the model for settlement of the project (licence fee or software as a service). Our solutions are not only browsers, but also the entire systems for input, storing and verification of data and their exchange with other systems. Our systems automatically report changes, make summaries and statements.