BI Mapping in Microsoft SQL Server
Microsoft® SQL Server™ is a business intelligence solution which incorporates the ability to use spatial data and create maps to geographically analyse your own information. Users are often unfamiliar with the mapping element within their system. The allmapdata team can help you import geographic data and make the most of this functionality without the need to buy a separate map-based system, such as a GIS.
Within SQL Server you can run map-based reports and queries, ranging from identifying the count and density of customers in particular areas, to viewing sales territories or identifying regional trends with shaded maps.
Plotting your corporate data on a map is known as ‘geocoding’ and brings the rows and columns of data to life in a geographic context, helping you to better understand where your customers are located and which areas are performing well. For example, binding the geographical co-ordinates of United Kingdom unit postcodes (e.g. TW8 8JA) to your existing customer file that has the postcode, but no geographical information, will enable you to view the customers in the correct locations on the map.
We can also provide postcode boundaries formatted specifically for use in SQL so you can create powerful trend analysis maps depicting frequency of product return, number of prospects, volume of product ordered or number of deliveries made etc.
Spatial data is available for many different countries and can be provided in both the SQL Server Spatial database (*.bak) format and ESRI Shapefile format to make it easy for you to get started on map analysis inside your SQL Server system.