In the last article we mentioned how we would be showing you how to use maps to represent your data within your reports. Now we will show you how to achieve this.
Over the last year, more and more of our clients have been asking us how they can plot their data on a map as easily as possible but at a minimal cost.
Utilising Microsoft Excel 2013, this task has been made quite straight forward.
By allowing users to render their data with Microsoft Bing Maps (Microsoft’s alternative to Google Maps), a simple but highly effective charting solution is provided.
The following visualisation allows us to display sales by location for April, May and June.
As part of Microsoft’s Business Intelligence offering, Microsoft Power View (along with Microsoft Power Pivot) provide a means to report on data from small to extremely large enterprise level datasets, thus allowing for quick but effective analysis.
Microsoft Power View is an interactive data exploration, visualisation, and presentation experience that will encourage intuitive ad-hoc reporting. Users can easily develop their own reports against their Business Intelligence (BI) data without the need for expensive reporting software.
Within a few minutes, your users can have an effective location based reports displaying the strength of your metric in proportion to other values by the size of the circle – the larger the value, the larger the circle.
Your data doesn’t need to be one dimensional however – in the following example, we’re plotting sales for April, May and June against each other on the same map.
We believe that you’ll agree that the visualisation is effective.
Call us on 01-2790020 today for a no charge chat on how we can map your business needs.