Crime Analytics

Alteryx helps you solve impossible problems!

Overview:

The data used here is downloaded from the free source entity regarding the crimes happening in UAE.

An additional Column was added: Gender (0-> Female, 1-> Male)

Business Challenge or Problem:

• Data Manipulation
• Prediction – What are the chances that the convict of the same gender will commit the same crime?

Working Solution:

Crime by Emirates- Input File

Types of Crime -Input File

Each crime is allotted a score which helps in the calculation of black points

Emirates List -Input File

Data Merging, Joining and Manipulation

• The input files have been merged together as it has the same format.
• The scores of emirate list and Type of crimes ae joined based on the keys-emirate and crime name respectively.
• Crime index- Denotes the number of black points which will be added to the account holder of the convict- is calculated by the value multiplied with the crime and emirate score and 100 to get the no of black points generated.

Prediction:

Using boosted model,

The Target specified:

• Gender

Predictors specified:

• Type of crime
• Emirate
• Value and crime index
• Year

X predicts the % of chance of that gender committing the type of crime the next time.

For e.g., In the year 2000, a male committed crime against the firearms law in Abu Dhabi, and that led to 18 black points in his account. He is 51% likely to commit the same crime in future.

Related Articles

Insurance Analytics

Most of the data workers use Alteryx platform to find more answers quicker! Overview: One of the nation’s leading dedicated […]

Data Analytics Companies vs Freelancers

When presented with the options, many businesses are unsure whether to hire a data analysis company, or go with a freelancer. Find out the pros and cons.

data analysis

data analyst

data analytics companies

freelance data analysts

Reduce Admin Work by Outsourcing Data Entry

Data entry is a specialized and time-consuming task. So how can you reduce admin work? Find out here.