Creating data driven applications straight out of Excel get it now
This article will cover these main topics
- How to create rich applications which pulls together Google Maps ,Google Visualization, Twitter and Google Earth.
- Use the generated web applications as standalone web pages.
If you just want a to try it, then you can download an example application (googleMapping.xlsm) and come back here later. For a quick start see Step by Step Guides
Here are 4 ready made VizMap applications created by the example Excel Workbook.
- A Customer/Orders theme.
- A Concert Venues/Artist theme.
- A Dictators/Palaces theme
- British Royal Family and their homes
Or try a Google Earth Version.
Or one with Google Earth, twitter and Org Charts
and the same thing using Google Maps
You can select either just by changing a parameter in your worksheet.
I haven't spent much time on populating these with accurate data but hopefully you can see the general approach from these web pages. You can read the Excel Ramblings Blog entry on this topic here.
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.
Here is a popped up info window from a VizMap application that simulates an organization with multiple sites. You can see that not only is there an org chart there are also selected tweets based on the location within some radius.
- 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.
- Creating a VizMap Application
- Tailoring Output
- VBA - the Excel code walkthrough
- Complete Excel Address Data with Google Mapping API
- Setting up VizMap VBA module
- Vba to join master and transactional data
- Vba to generate VizMap Application
- Creating VizMap framework without Excel
- Providing VizMap Data without Excel
- Creating a tabbed Google Mapping InfoWindow
- Embedding Google Analytics in your VizMap application
- Using Google Maps
- Using Google Visualization DataTables
- Using Google Visualization DataViews
- Using Google Visualization charts and tables
- Using Google Earth
- Click events in Google Earth
- Flying around with Google Earth
- Using Twitter in Earth and Maps