Project: Creation of a searchable database of crime in the USA

Problem: The client wanted to create a marketing campaign to increase product sales. The client required access to statistics from a massive data set. Specifically, to target marketing activities on areas of cities in which there was a high level of thefts and break-ins.

Solution: First, establish viable open source information about the crimes committed in the US and selected suitable sources for further processing.

Develop a proprietary database system that collected information on crimes from selected open sources.

Prepared reporting that contained information relevant to the remit.

Outcome: The client received concise, reliable data which suited their targeting strategy.

Technological stack: Python 3.6.