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.