280 likes | 516 Vues
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
E N D
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 • Working with Shared Components • Working with ATOM Data Feeds • Embedding Reporting into Applications • Developing with the Microsoft Chart Controls
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
Introducing Maps • Map Overview • Data Sources
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
Map OverviewExample Titles Legend Viewport Point Layer Tile Layer (Bing Maps) Color Scale Distance Scale
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
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
Using the Map Wizard • Spatial Data Sources • Options • Map Visualization • Data Visualization
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
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
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
Map Visualization in Map Wizard Spatial Query Map Gallery
Data Visualization in Map WizardSpatial Query Marker type Marker sizes Marker color
Data Visualization in Map WizardMap Gallery Marker color
Using the Map Wizard SQL10R2UPD01-DEMO-02 Demo
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
Configuring the Map Data Region • Layer Properties • Map Elements • Distribution Options • Display Option Precedence • Viewport
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
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
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
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
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
Visualizing Data with Maps SQL10R2UPD01-HOL-03 Lab
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/
© 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.