|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/automating-link-charts/
课程评论：没有评论
课程名称：自动生成关联图 课程概述：许多犯罪和情报分析师往往需要花费数小时或数天来制作庞大的关联图。在本课程中，我们将介绍如何利用警察记录管理系统中常见的数据结构来自动生成关联图。这些技术适用于任何关联图程序，但本课程将使用NodeXL，这是一个免费的Microsoft Excel插件，另有提供下载链接。此外，我们还将广泛使用Microsoft Access。学生不需要任何先前的技术培训或编程经验。本课程从基础开始，介绍关系数据库以及常见的警察部门记录管理系统如何组织数据，并教你如何编写简单的SQL查询。学生将学习如何将一系列SQL查询包装成MS Access宏，以创建两个工具。第一个工具是犯罪嫌疑人搜索工具，帮助你解决执法机构中常见的脏数据和重复数据问题。这个工具允许你输入一个姓名或部分姓名，搜索你的主名称列表，你可以查看返回的个人信息，并选择一个或多个作为分析的目标。接下来，我们将创建第二个宏，该宏根据你的选择执行一系列SQL查询，为该个人生成边列表。生成的边列表可以方便地复制粘贴到任何关联图工具中。原本可能需要几个小时的工作，现在几秒钟即可完成！最后，我们还将简要介绍NodeXL中的可视化选项。
Many Crime and Intelligence analysts spend hours or days creating expansive link charts. In this course, we'll cover how to automate the creation of link charts using data structure common to police records management systems. These techniques are applicable to any link chart program but for the purposes of this course, we'll use NodeXL which is a free plugin for Microsoft Excel and available at the link below. Additionally, we will make extensive use of Microsoft Access. Students need no prior technical training or programming experience. This course starts from scratch, providing an overview of relational databases using common police department records management systems. You'll learn how these systems organize data and how to write simple SQL queries. Students will then learn how to package a series of SQL queries in an MS Access macro to create two tools. The first is an offender search tool that will allow you to overcome dirty data and duplicate data issues common in law enforcement agencies. This tool simply allows you to type in a name, or a partial name, and search your master names list. You can then review the individuals returned and select one or more that you identify as the target of your analysis. We will then move into creating a second macro that takes your selection and runs a series of SQL queries to create an edge list for that individual. The edge list can then be copied and pasted into any link charting tool. A task that may have taken hours now takes only seconds! We'll conclude with a brief overview of visualization options in NodeXL.
