Telephone Call Records: All Paths Analysis

Free Trial


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


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 to show and transform the layout and perform the analysis.

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

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

  1. 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

  2. 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

  3. 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

  4. 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

    [Stretch to Fit] can be used to adjust the diagram to fit the dimensions of your window.

  5. The database identifies Targeted phone numbers with a metadata value. Select them with the Data Refinement feature and pressing the [Select Filtered] button.

    • On the right panel, Entities tab, go to the Date Refinement Filter section, and 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 then click [OK].
    Visualizer Entities Entity Filter Metadata Lookup

  6. Click the [Select Filtered] button in the Data Refinement Filter section to select them. The diagram shows the highlighted targeted phones in Green.
    Targeted Phones

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

  7. 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

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

  9. 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

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

    Visualizer Layout Elliptical Visualizer Layout Elliptical

  11. 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 Network

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