Welcome to the Pro Center

Show Notes: Most databases have some kind of geographic data and there is a growing need to present topographical information in a reporting solution. There are two important components of geographic data: its geographic position and its attributes or properties. In other words, spatial data (where is it?) and attribute data (what is it?). This session provides information about working with geographic data from start to finish, the step-by-step means of preparing and presenting geographic data, and how you can "clean up" and validate your geographic data or create interactive reports. This session will begin with the tasks necessary to model a dimensional data structure to maintain and present geographic data. We will discuss various requirements that can affect a data model such as granularity, surrogate keys, slowly changing dimensions. Real life examples and solutions will provided to give better context to each step in the process.

After the data structure has been created we will focus on how to best “clean” and validate the geographic data. We will focus on using SSIS to obtain latitude and longitude and then how this can be converted SQL Server spatial types.

Finally we will cover presenting this data using SSRS and Power Map and how to create dynamic and aesthetically pleasing graphical reports. This portion of the session concentrates on presenting reports using the geographic data type that answer specific questions such as:

Events that occurred at a specific address, zip code, and even block range and events within a mile radius.

Learning Objectives:
Each attendee will leave with the knowledge and toolset necessary to:
1. Use SSIS to validate address data and obtain a longitude and latitude from a mailing address
2. Convert a longitude and latitude to a geographic data type in SQL
3. Create dynamic and complex reports using the map component in SSRS
4. Creating reports using Power Map in Excel

Tip: double-click the video to enable full-screen.
comments powered by Disqus

   Topic Area (Click to change):

Related content: