Improving Accessibility to Data with Business Intelligence

To better understand why certain types of crime are concentrated in different parts of the village, the Village of Woodridge, IL Police Department was looking for a way to show the locations of the current calls for service, as well as information from their police database, in a spatial environment. While creating a static map product periodically would have been one option, a more dynamic option would be to integrate this data into the village’s web-based mapping application, MapOffice™, using Business Intelligence. Business Intelligence allows the police department to view these different data sources dynamically, side-by-side on a map and visualize trends that may not be readily apparent when looking at the data in a spreadsheet or other tabular format. 

Business Intelligence is a technology that allows connections to be made to a variety of data sources that include spreadsheets, databases, dispatch systems, and Enterprise Resource Planning (ERP) systems. The Woodridge police department benefits from this type of connection since their service call data and police database are stored in different places. Now, when police staff use MapOffice™, they can see multiple data sources together, including call data, locations where illegal property trespasses have occurred, and where patrolling location of interest are located. Officers can also access this information in the field using laptops in their patrol cars.

Business Intelligence connections in MapOffice™ is a powerful technology that allows multiple sources of data to be integrated into a single location, which can provide deeper insight into common questions.