1 / 11

Power Map Preview

Power Map Preview. … with New Zealand data MVP Community Camp 2014 Auckland Ingeborg Hawighorst – MVP MS Excel. Project Codename “ GeoFlow ” Map Excel data with Bing maps Discover insights Share stories. What is Power Map?. Office 365 ProPlus

ouida
Download Presentation

Power Map Preview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Power Map Preview … with New Zealand data MVP Community Camp 2014 Auckland Ingeborg Hawighorst – MVP MS Excel

  2. Project Codename “GeoFlow” • Map Excel data with Bing maps • Discover insights • Share stories What is Power Map?

  3. Office 365 ProPlus • Power Map Preview for Excel 2013http://www.microsoft.com/en-nz/download/details.aspx?id=38395(Power Map preview for Office Professional Plus 2013 will disable in May) • Windows 7 or higher • A reasonably modern computer, lots of memory, fast graphics • Internet connectivity • Data with geographic elements • Power Query (optional) What do I need to run it?

  4. A screenshot Most demos and videos are based on US data.

  5. Data must be in a simple table structure • PowerQuery can help shape the data Data format

  6. Find data for a NZ based demo • Transform data with PowerQuery • A big thanks to Bob Phillips, UK based Excel MVP for his help • Mind the gap – NZ place names need some TLC Challenges

  7. Sample files can be downloaded. Watch out for the slide with the links. Demo

  8. The video can be viewed at http://youtu.be/o2yUrNTaKQo The journey • Map GPS co-ordinates over time

  9. The video can be viewed at http://youtu.be/pvs87UK2API SceNZ

  10. Power Query downloadhttp://www.microsoft.com/en-us/download/details.aspx?id=39379 • Power Query Info (Language specs, formulas, help)http://office.microsoft.com/en-001/excel-help/learn-about-power-query-formulas-HA104003958.aspx • Power Map Preview downloadhttp://www.microsoft.com/en-us/download/details.aspx?id=38395 • Includes “Getting Started with Power Map Preview” • Bob Phillips BI Blog– featuring advanced Power Query techniqueshttp://wessexbi.wordpress.com • Power BI Bloghttp://blogs.msdn.com/b/powerbi/ • Sample files and this presentationhttps://onedrive.live.com/redir?resid=FE479525195477F7!1714&authkey=!AFkawAlN8cZHvOI&ithint=folder%2c.txt • … or my site www.teylyn.com – twitter @IngeborgNZ Links and resources

More Related