CDR Targeted Phone Numbers Database

Background

Telephone call data records contain a list of phone calls, people, which phone numbers they own, and a list of target telephone numbers. To create the database:

  1. We imported the call data records into Sentinel Visualizer’s database.
  2. We imported the names and numbers “on top of” of the call records.
  3. We imported the targeted phone numbers.

For more information on this database, watch: Telephone Call Data Record Video

Objective

There are lots of targeted phone numbers to investigate. Where do we start? It’d be ideal to know if any of them call each other directly or through other phones that are not in our targeted list.

Sentinel Visualizer Analysis

Here are some steps to explore the power and features of Sentinel Visualizer while performing the analysis.

  1. On the Sentinel Visualizer Home Page, click [Entity Search] located in the Search panel.
    Entity Search

  2. Click the [Advanced] button.
    Entity Search Advanced

  3. Click the [Metadata/Lookups] tab. In the Metadata Type drop-down, choose Targeted. In the Entity Type drop-down, choose Yes and click [Search].
    Entity Search Metadata Lookups

  4. Sentinel Visualizer displays the 74 phone numbers that are targeted. Click [All to Visualizer] located at the bottom of the Entity Search page.
    Entity Search Matches Found

  5. The 74 targeted phone numbers are displayed on a diagram in the Visualizer.
    Visualizer Diagram

  6. Click on the diagram and press [Ctrl + A] to select all entities. The selected entities are highlighted in green.
    Select All Entities

  7. Click the [Get Links] button on the toolbar and select [Between Selected]. Between Selected allows you to select multiple entites to add the fewest entities and relationships connecting them.
    Select the 'Least number of entities to connect every pair' option and click [OK].

    Get Links Between Selected Get Links Between Entities

    The diagram shows two targeted numbers and added five entities to connect a different pair of targeted numbers.
    Get Links Between Entities

  8. To view only the paths that connect the four targeted phones, click the [Entities] tab and select 'Linked Entities' in the Show/Hide panel.
    Linked Entities

  9. Optional: To view the entire diagram on the screen, select the [Zoom] button from the toolbar and select [Fit to Page].

    Visualizer Zoom Fit to Page Visualizer Fit to Page

  10. Sentinel Visualizer offers a variety of automated layout functions that make it easy to quickly organize networks into different configurations. Visit Sentinel Visualizer's Layout Options for more choices.
    Click the [Layout] drop-down on the toolbar, select [Incremental] and click [Tiled Networks] to see the two disconnected networks more clearly:

    Incremental Layout Filled Rectangle


Results

Sentinel Visualizer's advanced analytics discovered that a pair of targeted numbers (ending in '1987' and '6835') do not call each other, but are connected through 5 intermediaries who are not in the target list. This suspicious group warrants further investigation:
Linked Targeted Phone Numbers

Sentinel Visualizer also discovered two of the targeted numbers are talking directly to each other:
Linked Targeted Phone Numbers

Export the List of Phone Numbers (Entities) to Microsoft Excel

From the original call data records with thousands of phones and calls between them, and 74 targeted numbers, Sentinel Visualizer prioritizes the high value activity to two pairs of targeted numbers and adds 5 additional suspects. Start your investigations there. Easily export the 9 entities on your diagram into an Excel spreadsheet by clicking [Output] on the visualizer toolbar and select [Excel List of Entities].

Export the Entities to an Excel Spreadsheet Entities to Excel Spreadsheet



Microsoft Certified Partner

Microsoft Partner Netework

Partners Welcome

Do you provide services to government and commercial customers seeking analytic solutions?
Contact us

In-Q-Tel Portfolio Company

InQTel Portfolio Company
Learn more

Discover

Sentinel Visualizer Comparison to IBM's i2 Analyst's Notebook