Telephone Call Records All Paths Analysis

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 phone calls. Do the targeted phone numbers have calls that connect them through intermediaries? If so, we want the family of associated phones to investigate further.

Sentinel Visualizer Analysis

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

  1. After opening the database, from Sentinel Visualizer's Home Page, click [New Visualizer].
    New Visualizer

  2. On the Visualizer toolbar, to open a diagram, click [Open].
    Open Diagram

  3. Select the diagram titled Largest Network and click the [Open] button.
    Open Largest Network Diagram

  4. This is an example network (a subset of the entire database) that was discovered within the ~4,000 rows of call records (Excel spreadsheet).
    Call Records Largest Network Diagram

  5. Explore the network. You can zoom-in (Ctrl + Mouse Scroll Button up) to see phone and people are connected to each other.
    As you click on phone numbers and relationships, they are highlighted green. The connected entities are highlighted in blue. You can customize the colors under Options. Details of the selected items appear in the bottom window pane, on the [Details] tab.
    Call Records Entity Details

  6. To view the entire network on the screen, select the [Zoom] button from the toolbar and select [Fit to Page].

    Visualizer Zoom Fit to Page Visualizer Fit to Page

  7. To rotate the diagram to better fit your screen, click the [Transform] button on the toolbar and select [Rotate Right 90°].

    Rotate Diagram Rotate Diagram

  8. The database identifies Targeted phone numbers with a metadata value. You can select them by using the Data Refinement feature and pressing the [Display Selections] button.
    On the far right side of the visualizer, in the Entities tab. In the Date Refinement Filter section, click the [...] button to open the Entity Filter window.
    Click the [Metadata/Lookups] tab. In the Metadata Type drop-down, choose Targeted. In the Entity Type drop-down, choose Yes and click [OK].

    Visualizer Entities Entity Filter Metadata Lookup

  9. Click the [Display Selections] button in the Data Refinement Filter panel to select them. The diagram shows the highlighted targeted phones in Green.
    Targeted Phones

    Note: If you click the Enable Filters check box, only the Targeted entities would remain visible.

  10. On the far right side of the visualizer, click the [Links] tab.
    Select the [All Paths] radio button. The lines that connect those two targeted phones are highlighted in red. This illustrates the paths between the two targeted phones.
    Link Targeted Phones

  11. To view only the paths connected to the two targeted phones, check the box under the Filter icon.
    Filter Links

  12. To see more paths that are linked to the two targeted phone numbers, change the number of Entities Between by clicking the up arrow.
    Visualizer Links All Paths Between Entities

  13. 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 information.
    Click the [Layout] drop-down on the visualizer toolbar. Select [Elliptical] and click [One Ellipse].

    Visualizer Layout Elliptical Visualizer Layout Elliptical

  14. Export the list of entities on your diagram into an Excel spreadsheet by clicking [Output] on the visualizer toolbar and selecting [Excel List of Entities].

    Export the Entities to an Excel Spreadsheet Entities to Excel Spreadsheet
    In some cases, an investigation may not be allowed to search an entire database (fishing expeditions).
    However, if there are pre-defined targeted phone numbers, identifying the family of connected entities among them may be justified for additional research.
    Sentinel Visualizer makes it easy to quickly identify and prioritize these high value targets, while protecting the privacy of others.

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