2-645.mix.pptx

Visualizing Business Data on any Device with Bing Maps

1.0x

2-645.mix.pptx

Created 2 years ago

Duration 0:00:00
lesson view count 319
Visualizing Business Data on any Device with Bing Maps
Select the file type you wish to download
Slide Content
  1. Ricky Brundritt

    Slide 1 - Ricky Brundritt

    • Program Manager
    • Bing Maps Customer Advisory Team
    • Visualizing Business Data on any Device with Bing Maps
    • 2-645
    • //build/ content is being presented by Microsoft Office Mix The video for this session will be available shortly
  2. Submit an evaluation for each Breakout Session you attend.

    Slide 2 - Submit an evaluation for each Breakout Session you attend.

    • BE ENTERED INTO THE DAILY PRIZE DRAWING!
  3. Visualizing Data on Bing Maps without writing code

    Slide 3 - Visualizing Data on Bing Maps without writing code

    • Business Intelligence Visualization Techniques on Bing Maps
    • Using Bing Maps in Cross Platform Apps using HTML5
    • Agenda
  4. Slide 4

    • is the industry’s intelligence engine
    • Across Microsoft
    • Across Devices
    • With the industry
    • #BingSolutions
  5. Visualizing data on Bing Maps without writing code

    Slide 5 - Visualizing data on Bing Maps without writing code

  6. Q: What percentage of business data is often thought to have a spatial relevance (location)?

    Slide 6 - Q: What percentage of business data is often thought to have a spatial relevance (location)?

    • Bing Maps Trivia # 1
  7. A: It is often said that approximately 80% of all business data has some sort of spatial relevance

    Slide 7 - A: It is often said that approximately 80% of all business data has some sort of spatial relevance

    • Bing Maps Trivia # 1
  8. Cloud Service that works in Excel, Web Browsers, and Mobile

    Slide 8 - Cloud Service that works in Excel, Web Browsers, and Mobile

    • Easily visualize your data on Bing Maps without writing code
    • Microsoft Power BI
    • https://www.powerbi.com/
  9. Available with Power BI for Office Professional Plus 2013

    Slide 9 - Available with Power BI for Office Professional Plus 2013

    • Features:
    • Visualize millions of rows of data on a 2D or 3D map in Excel
    • Data can be displayed as 3D bar charts, heat maps, clustered points, administrative boundaries
    • Story boards & timelines
    • Custom maps
    • Power Maps for Excel 2013
  10. Power BI & Power Map

    Slide 10 - Power BI & Power Map

    • Demo
  11. Power View (a feature of Power BI)

    Slide 11 - Power View (a feature of Power BI)

    • Available in Excel 2013 for Desktop, SharePoint 2013, Power BI
    • Dynamics CRM 2013/2015
    • SharePoint 2013
    • SQL Server Reporting Services
    • 2008 R2 and above
    • Other out of the box solutions
  12. Business Intelligence Visualization Techniques on Bing Maps

    Slide 12 - Business Intelligence Visualization Techniques on Bing Maps

    • Section
  13. There are several ways to uniquely represents different types of data on Bing Maps:

    Slide 13 - There are several ways to uniquely represents different types of data on Bing Maps:

    • Custom Pushpins Icons
    • Size of icon
    • Color of icon or shape
    • Line Style – solid or dashed
    • Pushpins, Polylines, and Polygons
  14. Improves the user experience

    Slide 14 - Improves the user experience

    • Makes the map easier to see by grouping overlapping data points together
    • As you zoom in the groups break apart
    • Ideal for view large data sets
    • Pushpin Clustering
  15. Slide 15

    • Point based data is represented such that the color intensity increases based on density of points.
    • Each data point is given a radius.
    • As data points overlap the color intensity increases.
    • Color intensity is mapped to a color gradient.
    • Radius can either be a constant physical distance, or scale with each zoom level based on a preferred pixel radius.
    • Density Heat Maps
  16. A combination of clustering and heat maps

    Slide 16 - A combination of clustering and heat maps

    • Clusters represented using color coded geometric shapes that fit together evenly
    • Commonly used shapes:
    • square, triangle, hexagon
    • Data Binning
  17. Geographical areas are color coded based on a data metric.

    Slide 17 - Geographical areas are color coded based on a data metric.

    • Useful Tip:
    • Use a hierarchy approach by showing larger regions when zoomed out and smaller ones as you zoom in. Country -> State -> County -> Zip Code
    • Thematic Maps
  18. Clustering, Heat Maps and More

    Slide 18 - Clustering, Heat Maps and More

    • Demo
  19. Q: How big would a single JPEG of the world be at zoom level 19 (30cm/pixel resolution)?

    Slide 19 - Q: How big would a single JPEG of the world be at zoom level 19 (30cm/pixel resolution)?

    • Bing Maps Trivia # 2
  20. A: Really Big! The Image would be 134,217,728 pixels x 134,217,728 pixels in size (2^19 * 256)

    Slide 20 - A: Really Big! The Image would be 134,217,728 pixels x 134,217,728 pixels in size (2^19 * 256)

    • Road Map: ~275TB
    • Aerial Map: 500TB+
    • Bing Maps Trivia # 2
  21. Overlay data as an image.

    Slide 21 - Overlay data as an image.

    • Turn data into an image or use an existing georefenced image
    • Chop image up into smaller images called tiles that align with map tile conventions
    • Name the tiles using a standard convention used by tile layers (quadkey or XYZ)
    • Tile Layers
  22. Static – Tiles are created ahead of time and hosted online

    Slide 22 - Static – Tiles are created ahead of time and hosted online

    • Pros: Simple architecture and fast rendering.
    • Cons: Can require a lot of storage. Not easy to update data.
    • Useful Tool: Microsoft Map Cruncher
    • Dynamic – Tiles are created on demand on the server
    • Pros: Ideal for Big Data and/or constantly changing data sets. Easy to update. Requires less storage for tiles.
    • Cons: Architecture a little more complex. Can use a lot of compute power server side.
    • Useful Resource: Whitepaper and Code Samples available from Bing Maps team.
    • Fun Fact: Bing Maps road map tiles are generated dynamically.
    • Types of Tile Layers
  23. Dynamic Tile Layer Service

    Slide 23 - Dynamic Tile Layer Service

    • Or
    • Bing Maps Spatial Data Services
    • Microsoft Azure
    • Hosted Service
    • Tile-Render
    • Cache
    • Microsoft Azure
    • Storage / CDN
    • Mapping
    • API & Services
  24. Dynamic Tile Layers

    Slide 24 - Dynamic Tile Layers

    • Demo
  25. Using Bing Maps in Cross Platform Apps using HTML5

    Slide 25 - Using Bing Maps in Cross Platform Apps using HTML5

  26. Slide 26

    • Bing Maps Cross Platform approaches
    • Native .NET Code
    • Pros: Best Performance, Offline maps available for Windows Store/Phone
    • Cons: Limited to certain platforms (Windows Store/Phone, WPF)
    • Hybrid App using HTML/JavaScript
    • Pros: Greater reach (All of the above plus; Web, iOS, Android and more)
    • Cons: Loading of tiles can be slow when on a wireless connection
    • Using Web Services
    • Pros: Ideal when you don’t need an interactive map
    • Cons: Limited to a few use cases
  27. Write once, use everywhere!

    Slide 27 - Write once, use everywhere!

    • Several development paths:
    • Embed mobile website into WebBrowser/WebView control in custom apps
    • Use Apache Cordova for easier development
    • If creating a Xamarin based app, embed map inside of HybridWebView control
    • Tips:
    • Enable High-PPI maps
    • Use the Windows Bing Maps JavaScript SDK for JavaScript based Windows apps
    • Hybrid app using HTML5 and JavaScript
  28. Bing Maps in an Apache Cordova App

    Slide 28 - Bing Maps in an Apache Cordova App

    • Apache Cordova Based App
    • JavaScript, HTML, CSS
    • Bing Maps
    • Apache Cordova exposes native features, such as sensors, through JavaScript code and hosts the web app inside of a WebBrowser/WebView control.
  29. Embed web app inside of HybridWebView control in Xamarin app.

    Slide 29 - Embed web app inside of HybridWebView control in Xamarin app.

    • Bing Maps in a Xamarin Hybrid App
    • Xamarin Based App
    • HybridWebView Control
    • C#
    • JavaScript, HTML, CSS
    • Bing Maps
  30. Cross Platform Hybrid Bing Maps apps

    Slide 30 - Cross Platform Hybrid Bing Maps apps

    • Demo
  31. Q: What new online Microsoft tool can you use to visualize your data on a map without having to write code?

    Slide 31 - Q: What new online Microsoft tool can you use to visualize your data on a map without having to write code?

    • Bing Maps Trivia # 3
  32. A: The Microsoft Power BI Public Preview

    Slide 32 - A: The Microsoft Power BI Public Preview

    • https://www.powerbi.com/
    • Bing Maps Trivia # 3
  33. Use Power BI to visualize data on a map without writing code

    Slide 33 - Use Power BI to visualize data on a map without writing code

    • Use Bing Maps in your apps
    • Check out session 757 on the Windows 10 maps
    • Follow Bing Maps on Twitter @bingmaps
    • Check out the Bing Maps blog: http://blogs.bing.com/maps
    • Call to Action