The VizMap application
VizMap is the collection of components that allow you to create a data driven application that will merge google visualization and google mapping straight out of Excel. This consists of several components, which are all integrated in the Excel Driving application, and many of which can be seen in other roles throughout this site.
- GeoCoding parameters. This describes how to deal with the response from various geoCoding providers and how to incorporate this in the VizMap application. This is the same as was introduced in the section on GeoCoding
- Application specific parameters. These describe the data to be shown on the map, which visualizations to embed in the map Popup Windows, where to position them, what data to include, and any tailoring information required to construct specific web page look and content. There will be one of these for each VizMap application, and from this a self contained web application will be generated.
- Master/Transaction joining application. When creating these kind of applications, there is often a join of transactions to master data and look up data required. The googlemapping.xlsm workbook also contains a capability to do this using Data Manipulation Classes covered elsewhere on this site.
- Excel/Json Conversion. Data and parameters are communicated from Excel to the Web applications and web services used using jSon. We use the cJobject serialization capability covered elsewhere on this site.
Here is how to setup your own VizMap application, and a deep dive into how it works.