Using Path Analyzer - Teradata Analytic Apps - 1.0

Teradata® Analytic Apps User Guide

Teradata Analytic Apps
User Guide

    Develop the Scenario

  1. Before using Path Analyzer, consider the problem you need to address. To help you better understand how to use Path Analyzer, this topic incorporates the following example:
    Issue Description
    Problem Customers are canceling their service.
    Question What actions (events) are leading my customers to cancel their service?
    Goal To identify customers who are likely to cancel their service and proactively consider a solution.
  2. Identify the event table and events needed to address the question. Using the example scenario, the event table is titan_telco_events, and the event is CANCEL SERVICE.
  3. Access Path Analyzer

  4. Access AppCenter and select Vantage Path Analyzer.
  5. Select the Vantage database and enter your database login credentials, then click SELECT.
  6. Define the Parameters

  7. Define the path parameters. Using the example Service Cancellation scenario, you might populate the parameters as follows:
    Parameter Description Example
    Top paths to show Defines the number of pattern-matching paths to display.
    Typical values are 25, 100, or 500.
    The larger the number the more unique paths display.
    Event table Source table to be analyzed. titan_telco_events
    Event A Initial event in the search pattern.

    Select Any event to include all events.

    Any event
    Event B Ending event in the search pattern.

    Select Any event to include all events.

    Minimum event count Minimum number of events in the path pattern. 2
    Maximum event count Maximum number of events in the path pattern. 5
  8. Click RUN.
  9. Analyze the Tree Diagram

  10. Review the tree diagram. Using the results of this example, you can do the following:
    • Determine that BILL DISPUTE is the dominant factor driving customers to CANCEL SERVICE.
    • Export a list of customers who are on the path to churn.
    • Add the results to a predictive model such as Modeler.
    • Use this information to work with business teams to address the root cause.

  11. Expand or collapse path nodes, show the dominant path, or review underlying SQL query.
    Action Steps
    Select dominant path Click SELECT DOMINANT.
    View user paths Click EXPAND ALL.

    Click COLLAPSE ALL to reduce number of paths.

    Expand path Click .
    Collapse path, after it is expanded Click .
    Display number of records Click Show Count Labels.
    View underlying SQL query Click SHOW SQL to review or copy underlying SQL query.
    View results in a table Click .
    View results as a path Click .
    Reverse Event A and Event B Click , then click RUN.
    Show and hide parameter sidebar Click .
  12. [Optional] Export Results

  13. Export records into an existing table that contains the structure entity_id, path.