1 / 28

SQL Server 2008 R2 Reporting Services 03 – Visualizing Data with Maps

SQL Server 2008 R2 Reporting Services 03 – Visualizing Data with Maps. SQL10R2UPD01-DECK-03 [Presenter Name] [Presenter Title] [Company Name]. Module Overview. What's New in Reporting Services Developing Reports with the New Features Visualizing Data with Maps

quilla
Download Presentation

SQL Server 2008 R2 Reporting Services 03 – Visualizing Data with Maps

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. SQL Server 2008 R2 Reporting Services 03 – Visualizing Data with Maps SQL10R2UPD01-DECK-03 [Presenter Name] [Presenter Title] [Company Name]

  2. Module Overview • What's New in Reporting Services • Developing Reports with the New Features • Visualizing Data with Maps • Working with Shared Components • Working with ATOM Data Feeds • Embedding Reporting into Applications • Developing with the Microsoft Chart Controls

  3. Agenda • Introducing Maps • Using the Map Wizard • Demo: Using the Map Wizard • Configuring the Map Data Region • Demo: Configuring Map Layers • Lab: Visualizing Data with Maps

  4. Introducing Maps • Map Overview • Data Sources

  5. Map OverviewMap Data Region • Add map data region from BIDS Toolbox or Report Builder 3.0 ribbon • Use Map Wizard or cancel wizard and manually configure map elements

  6. Map OverviewExample Titles Legend Viewport Point Layer Tile Layer (Bing Maps) Color Scale Distance Scale

  7. Data Sources • SQL Server spatial data type • Point: Exact location defined as (X,Y) coordinate • Line: Connected sequence of points • Polygon: Two-dimensional shape having same start and end point • Bing map tiles • Provides road, aerial, or hybrid view as background for map layers • Requires report server configuration to support Bing Maps Web Services • ESRI shapefile • Complies with Environmental Systems Research Institute spatial data format • Contains data in a pair of files defining geometric or geographic shape and attributes for those shapes Tip: You can use multiple data sources in a single map by adding one layer for each data source

  8. Agenda • Introducing Maps • Using the Map Wizard • Demo: Using the Map Wizard • Configuring the Map Data Region • Demo: Configuring Map Layers • Lab: Visualizing Data with Maps

  9. Using the Map Wizard • Spatial Data Sources • Options • Map Visualization • Data Visualization

  10. Spatial Data Sources • Map Gallery • Spatial data embedded in reports • Default location: Program Files\Microsoft SQL Server\Report Builder 3.0\MapGallery • ESRI shapefile • Data defining geographical or geometrical shapes (SHP) and data for shape attributes (DBF) • Data embedded in report or retrieved atruntime from report server • SQL Server spatial query • SQLGeometry or SQLGeography data typesfrom SQL Server database • Each row of results stored as one map element

  11. Map Wizard Overview

  12. Options in Map Wizard Spatial Query Layer type: Polygon, Point, or Line Specify resolution and center Embed map data Crop (optional) Add Bing Maps layer Tile type: Road, Aerial, or Hybrid

  13. Options in Map Wizard Map Gallery Specify resolution and center Embed map data Resolution Crop (optional) Add Bing Maps layer Tile type: Road, Aerial, or Hybrid

  14. Map Visualization in Map Wizard Spatial Query Map Gallery

  15. Map Spatial to Analytical Data

  16. Data Visualization in Map WizardSpatial Query Marker type Marker sizes Marker color

  17. Data Visualization in Map WizardMap Gallery Marker color

  18. Using the Map Wizard SQL10R2UPD01-DEMO-02 Demo

  19. Agenda • Introducing Maps • Using the Map Wizard • Demo: Using the Map Wizard • Configuring the Map Data Region • Demo: Configuring Map Layers • Lab: Visualizing Data with Maps

  20. Configuring the Map Data Region • Layer Properties • Map Elements • Distribution Options • Display Option Precedence • Viewport

  21. Layer Properties • Drawing order • Sequence in Map Layers window determines drawing order • Bottom layer draws first; top layer draws last • Visibility • Properties are configurable in Layer Data • Layer can be hidden by expression or zoom level • Minimum and maximum zoom levels are optional • Transparency percentage allows visibility “through” layers • Data • Spatial data source and fields configurable in Layer Data • Analytical dataset and matching fields are optional

  22. Map Elements • Define appearance of labels • Label text • Placement • Font properties , including fill, borders, and shadow • Configure interactivity • Drillthrough to another location or report • Provide tooltip text • Specify marker properties • Type • Size

  23. Distribution Options • Apply to rules for color, size, or type • Divide data into ranges • Equal intervals regardless of data distribution • Equal distribution, with each range containing same number of items • Optimal distribution based on internal algorithm • Custom distribution for user-defined ranges

  24. Display Option PrecedenceLowest to Highest • Layer options • Map element options • Rules affecting color, size, width, and marker type • Options to override individual embedded spatial data on a layer

  25. Viewport • Coordinate system • Planar: two-dimensional coordinates • Geographic: latitude and longitude angles • Projection • Handles geographic data in two-dimensional space • Affects area, shape, distance, and direction • Center and Zoom • Supports specific center coordinates, expression-based, or specific map elements • Allows adjustment of zoom values for some centering options only • Resolution • Determines whether resolution favors performance or map detail • Accepts specific resolution size for smallest detail to display Viewport

  26. Visualizing Data with Maps SQL10R2UPD01-HOL-03 Lab

  27. Resources • Working with Map Report Items • http://msdn.microsoft.com/en-us/library/ee210581(SQL.105).aspx • Bing Maps Tile System • http://msdn.microsoft.com/en-us/library/bb259689.aspx • SQL Spatial Tools • http://sqlspatialtools.codeplex.com/ • Shape2SQL - Convert shapefile to spatial data http://www.sharpgis.net/page/Shape2SQL.aspx • Shapefile Resources: • US Census Bureau Website • http://www.census.gov/geo/www/tiger/ • Global Administrative Areas Spatial Database http://biogeo.berkeley.edu/gadm/ • Digital Chart of the World Data Server • http://www.maproom.psu.edu/dcw/

  28. © 2010 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

More Related