Archive for the ‘Power Map’ Category
Power Map was released as part of Office 2013 SP1. You can read the announcements here:
One important point to note here is that Power Map will only be available to Office 365 customers. If you have a standalone version of Excel, or have a regular (ie not Office 365) Professional Plus license, you will no longer be able to use Power Map. See:
If you have a subscription for Microsoft Office 365 ProPlus, Office 365 Midsize Business, or for the Office 365 Enterprise E3 or E4 plans, you’ll have access to Power Map as part of the self-service business intelligence tools. To determine which subscription you have, see Office 365 ProPlus and Compare All Office 365 for Business Plans.
If you have Office 2013 Professional Plus or a standalone version of Excel 2013, you’ll be able to download and use the Power Map Preview for Excel 2013 until May 30, 2014. After that date, the preview will no longer work in any non-Office 365 subscription version of Excel.
So, yet more evidence that you need an Office 365 subscription and a streamed installation of Office to get all the latest BI functionality.
UPDATE: Meagan Longoria has the details on what’s new in this release here:
Last week a new, preview version of Power Query was released to work with the Power BI public preview (John White, whose blog has a lot of good Power BI information, has the details here); today, a new version of Power Map was released too. You can download it here:
Here are some of the new features, in no particular order:
- You can now overlay certain geographical regions onto a map. For example, with the following table in the Excel Data Model:
In Power Map you can create a new layer type of Region and see each country shaded by their sales value:
The Region shapes are sourced from Bing; you can’t upload your own shapes unfortunately. I have no idea what regions Bing does know about, but it clearly knows about English county boundaries (though it doesn’t know about postcode boundaries):
- You now have the option of seeing a ‘Flat Map’. Here’s the map above shown in flattened form:
- You can now control the colours used in a layer:
- You can add annotations with images in:
- You can now record tours from within Power Map and save them to an MP4 file.
- Calculated columns and hidden columns can now be referenced in a layer.
There are plenty of other changes – I’ll update this post if I’ve missed any other major ones – but in addition the app seems smoother and faster, as well as being (slightly) easier to use.