Extending a PerformancePoint dashboard with Bing Maps and Silverlight
We have a map not where we’re pulling in information from the Bing Map service, which is a web hosted service that Microsoft provides, and we’re putting our data on the maps within our application.
Here we have the same kind of sales information, and we can change metrics, like clicking here on Average Selling Price. But in addition to the rest of our visualizations we’re customizing this by showing the geographical boundary of the regions that our stores are organized into.
If I’d like to use the filters I can certainly do that. I can choose, for example, just one category of light duty cogs, and see how the sales of light duty cogs have done over the country by region. I can see that three regions are doing well; one of the regions is not as well as the others.
This provides a new dimension on top of a standard numeric report. Let’s take that a bit further.
What I’ll do now is choose from my filters a particular state. As I apply that I get a map that zooms in on California. This is an interactive map; it’s not just a static picture, but I can see my data overlaid on the state of California. These are all my stores, and their KPI status within any of these KPIs that I have defined.
If I want to look at which stores are doing best in terms of maintaining gross margins, I can do that.
This gives me a much richer picture than I would see if I as just looking at a list of stores with their data points.
I can drill in on this and see even more detail. Maybe what I’d like to do is bring this up and look at it closer. If I click on the heading I get a full screen view, and some more control including additional navigation components. I can look at then entire state. I see a few red spots, so maybe I’d like to zoom in on that and look at it.
If I hover over a point I can get more information about individual stores. We have a lot of interactivity, a lot of data displayed on this map.
Maybe I’d like to look at a satellite photo of that store and see what’s located around it–like this auto facility here. I can zoom out.
When I’m finished looking at that I can certainly go back to the dashboard where I started and choose a different state that interests me, or a different metro area, like the Chicago metro.