Analysis
The study of public disorder and crime where crime reduction, prevention, and apprehension of criminals is the goal.
CRIME ANALYSIS
Terminology for the format of CAD and Case Numbers.
JULIAN DATE
This operator searches for a pattern of letters/numbers.
LIKE
Excel's built-in, preprogrammed formulas.
FUNCTIONS
NIBRS Code 220
BURGLARY
The study of reported crime, calls for service, and other related information in order to inform short-term operational crime control activities and problem-solving.
TACTICAL CRIME ANALYSIS
DISPOSITION C12
CITY CITATION(S) ISSUED
A query nested within the WHERE clause of another query.
SUBQUERY
The process of merging one value to another to form a text string.
CONCATENATE
This professional organization was formed in 1990 to help Crime Analysts around the world improve their skills and make valuable contacts, to help law enforcement agencies make the best use of crime analysis, and to advocate for standards of performance and technique within the profession itself.
THE INTERNATIONAL ASSOCIATION OF CRIME ANALYSTS (IACA)
The study of crime and law enforcement information integrated with sociodemographic and spatial factors to determine long-term “patterns” of activity, to assist in problem-solving, and to research and evaluate responses and procedures.
STRATEGIC CRIME ANALYSIS
The date in which RMS changed from Tiburon to Central Square (formerly TriTech).
May 1, 2018
A clause for the SELECT statement specifying that duplicate rows should be eliminated in the results.
DISTINCT
This formula allows you to quickly search for an item to return related information/data.
VLOOKUP
The process of converting the coordinates of a map or an image from one system to another, typically by shifting, rotating, scaling, skewing, or projecting them.
TRANSFORMATION
The process of systematically collecting, cleaning, transforming, describing, modeling, and interpreting data.
DATA ANALYSIS
A Felony Warrant in which the District Attorney has formally charged the defendant with the crime.
J/K - WARRANTS
This will combine rows from different tables even if the join condition is not met.
OUTER JOIN
A tool to calculate, summarize, and analyze data that allows you to see comparisons, patterns, and trends in data
PIVOT TABLE
Those unfamiliar with the Crime Analysis profession often compare it to Steven Spielberg's 2002 film in which a specialized police department, known as "Precrime", apprehends criminals by the use of foreknowledge.
MINORITY REPORT
The process of investigating social structures through the use of networks and graph theory.
SOCIAL NETWORK ANALYSIS
The six (6) MPD Core Values.
COMPETENCE, COURAGE, INTEGRITY, LEADERSHIP, RESPECT, RESTRAINT
This operator combines the result set of two different queries. The number of columns and their datatypes in the two queries must match.
UNION/UNION ALL
One must go here to create a "drop-down list".
DATA VALIDATION
DAILY DOUBLE
The number of municipalities that border the City of Milwaukee to the East?
SEVEN (7)
Brown Deer, River Hills, Glendale, Whitefish Bay, Shorewood, St. Francis, Cudahy