Welcome to EMC Consulting Blogs Sign in | Join | Help

John Brookmyre's Blog

BI Mashups - Let's go Geo

Gartner have highlighted mashups as a growth area for 2009 and predict that "by 2012, one-third of analytic applications applied to business processes will be delivered through coarse-grained application mashups" in the Five Predictions report. I have been looking at harnessing the power of mixing geographic visualisation techniques with Business Intelligence. Below is a video of a mashup I put together using MOSS, PerformancePoint, Windows Live Earth and Google Earth (or you can access the video directly from here):

Time Interest point
00:00 MOSS Report Centre
00:22 Oil and Gas Report
00:48 Report and Windows Live Earth
03:18 Google Earth
Thanks to Howard Van Rooijen's patience, I have also been coming out of my comfort zone and looking at some ADO  / .Net point clustering code which Howard and Steve Wright put together:
This means that you can cluster multiple points for the same location together, i.e. we can have a size weighting as well as using the visual icon to display information- I'm thinking heat maps on maps! Drop me a line if you are interested to see how this was done. Howard has also been working on an Open Source project called StyleCop for reSharper which ensures QA on code and much more, check it out here.

As always feedback would be welcome,


Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



jamie.thomson said:

""by 2012, one-third of analytic applications applied to business processes will be delivered through coarse-grained application mashups""

A suitably vague and ambiguous prediction that no-one can ever disprove cos no-one knows what the F it means. Analysts - what a waste of pigging money!!!

Sorry...had to get that off my chest!

February 19, 2009 10:54 AM

jamie.thomson said:

Now I've got that off my chest....great work JB!

February 19, 2009 10:56 AM

Matt Harris said:

I put my money on 'french' mash-ups being much more useful than 'coarse-grained' ones...

February 19, 2009 12:48 PM

joshunger said:

How do you see a user configuring a Virtual Earth report?  Where is the lookup from "Redmond, Washington" to a latitude and longitude or a polygon of points?  Has the administrator already entered that Redmond, Washington resolves to specific set of points?

March 20, 2009 6:52 PM

john.brookmyre said:

Hi Joshunger,

Thanks for the comment. The geo information would have to be stored in the data, i.e. for your dimension New York there would be a Long and Lat associated with it. For the reports you would need something similar too, i.e. say North East you would need to have a centre long / Lat and a zoom level or a polygon.

Hope that helps, if not drop me a line, John.Brookmyre@EMC.com,


March 22, 2009 9:44 PM

Leave a Comment


This Blog



Powered by Community Server (Personal Edition), by Telligent Systems