Telephone Call Data Records (CDR) Database with Targeted Phone Numbers

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 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
    The 74 targeted phone numbers are displayed on a diagram in the Visualizer:
    Visualizer Diagram

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

  6. Click the [Get Links] button on the toolbar and select [Between Selected]. Between Selected allows you to select multiple entitles 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 Menu Get Links Between Entities Dialog

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

  7. To only view the phones connected to targeted phones, click the [Entities] tab and select 'Linked Entities' in the Show/Hide panel. These are the most suspicious phones in your database.
    Linked Entities

  8. 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 Menu Visualizer Fit to Page Display

  9. 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 Menu Option Automatically apply incremental layout option on phone network


Results

From the original list of 74 targeted phone numbers, Sentinel Visualizer's advanced analytics quickly revealed the most suspicious ones. This helps you prioritize your limited time and resources on the highest priority suspects.

  1. Sentinel Visualizer discovered 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:
    Phones linked thru Additional Phones
  1. 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