2-645: Visualizing Business Data on any Device with Bing Maps

For years business and location intelligence have been two separate and distinct processes. With the rise of social media and Big Data these two areas have grown ever closer together. So much so that Microsoft now provides mapping tools in nearly every single one of its products. In this session we will take a look at the various tools available for working with Location based Business Intelligence data. In addition to this we will also take a look at how to create custom cross-platform apps that visualize business data on Bing Maps.

1.0x

2-645: Visualizing Business Data on any Device with Bing Maps

Created 2 years ago

Duration 0:55:21
lesson view count 76
For years business and location intelligence have been two separate and distinct processes. With the rise of social media and Big Data these two areas have grown ever closer together. So much so that Microsoft now provides mapping tools in nearly every single one of its products. In this session we will take a look at the various tools available for working with Location based Business Intelligence data. In addition to this we will also take a look at how to create custom cross-platform apps that visualize business data on 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
  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. Available with Power BI for Office Professional Plus 2013

    Slide 8 - 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
  9. Cloud Service that works in Excel, Web Browsers, and Mobile

    Slide 9 - 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/
  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