00 353 1 2790020sales@olas.ie Olas: Professional, Direct, Clever & Helpful
Blog
Home / Case Study / Utilising Maps to Chart your Data

Utilising Maps to Chart your Data

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.

Map1

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.

Map2

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.

Map3

Call us on 01-2790020 today for a no charge chat on how we can map your business needs.

Contact Us

Drop us a line, include your contact details and we will get back to you as soon as possible.