Skip to main content

Creating customer risk segments using a decision table

Archived

7 Tasks

25 mins

Visible to: All users
Beginner Pega Customer Decision Hub 8.4 Pega Marketing 8.4 English
This content is now archived and is no longer updated. Progress is not calculated. Pega Cloud instances are disabled, and badges are no longer awarded. Click here to continue your progress in the latest version.

Scenario

U+ Bank is cross-selling on the web by showing various credit cards to its customers. The bank already uses a customer’s credit score to determine their suitability for a credit card.

The bank wants to implement eligibility rules that prevent high-risk customers from receiving credit cards offers. These new eligibility rules require customers to be divided into risk segments that range from AAA to CCC. The risk segments are determined based on the customer’s outstanding loan amount and credit score.

Only customers that belong to certain risk segments are eligible for a credit card.

Use the following credentials to log in to the exercise system:

Role

Username

Password

Decisioning Analyst

CDHAnalyst

rules

Decisioning Administrator

CRMDecisioningAdministrator

install

Caution: This challenge is built on the challenge "Building a scorecard to calculate the credit score". Hence when you click on Initialize Pega or Reset Instance in this challenge, you first need to complete the previous challenge.

The risk segments are determined by two parameters:

  • Outstanding loan amount – Value available in the Principal Loan property of the customer data model
  • Credit score – Score determined by the Determine Credit Score scorecard

The following table describes the risk segmentation:

Condition

Risk Segment

If Outstanding loan amount < $10000 AND

Credit score is > 600

AAA

If Outstanding loan amount between $10000 and $25000 AND

Credit score is > 600

AAA-

If Outstanding loan amount between $25000 and $50000 AND

Credit score is > 600

AA

If Outstanding loan amount > $50000 AND

Credit score is > 600

AA-

If Outstanding loan amount < $25000 AND

Credit score is between 400 and 600

BBB

If Outstanding loan amount between $25000 and $50000 AND

Credit score is between 400 and 600

BBB-

If Outstanding loan amount > $50000 AND

Credit score is between 400 and 600

BB-

If Credit score is between 200 and 400

CCC

If Outstanding loan amount AND Credit score falls in any other range

CCC

 

Your assignment consists of the following tasks:

Task 1: Create a decision strategy to determine customer credit scores.

Create a decision strategy and import the DetermineCreditScore scorecard rule to determine customer credit scores.

Task 2: Create a Decision Table

Create a decision table that implements the bank’s risk segmentation requirement as per the table above.

Task 3: Ensure customers in the risk category BB- and CCC are not eligible for credit cards.

Amend the decision strategy to ensure customers in a given risk category are not eligible for offers. Ensure that customers in the risk category of BB- and CCC are ineligible for credit cards. Customers from all other risk segments are eligible. 

Task 4: Test the strategy for different customers

Verify that customer Robert is ineligible for a credit card, while Arnold is eligible. Use the information in the following table for verification.

Customer

Outstanding Loan

Credit Score

Eligible

Robert

180000

300

NO

Arnold

8000

400

YES

Task 5: Ensure the Risk Segmentation decision strategy can be used as the Eligibility strategy in the Next-Best-Action Designer.

Add the decision strategy as a relevant record in Dev Studio so that it can be used as eligibility strategy in the Next-Best-Action Designer.

Note: To access Dev Studio, log in as Decisioning Administrator.

Task 6: Amend Next-Best-Action Designer’s Eligibility criteria for the Credit Cards Group.

Amend Next-Best-Action Designer’s eligibility criteria for the Credit Cards group as such: credit cards are eligible for all the other risk segments except for customers belonging to risk segment BB- and CCC.

Task 7: Confirm your work.

Challenge Walkthrough

Detailed Tasks

1 Create a decision strategy to determine customer credit scores.

  1. Log in as Decisioning Analyst with user name CDHAnalyst and password rules.
  2. In the navigation pane on the left, click Intelligence > Strategies.
    CH20726_1_Image _4.png
  3. In the upper right, click Create > Start with new canvas.
  4. On the Create Strategy page, enter or select the following information:
    1. Short description: Risk Segmentation
    2. Business issue/Group: Sales/CreditCards
    3. Development branch: No branch
    4. Apply to: PegaCRM-Data-Customer
  5. Click Create and open.
  6. On the canvas, right-click , and then select Enable external input to enable external inputs.
  7. On the canvas, right-click and then select  Decision analytics category> Scorecard to add a scorecard model component.
  8. Click scorecard model component, and then select Properties.
  9. In Scorecard model properties window, in the Scorecard model field, enter or select DetermineCreditScore.
    CH20726_2_Image _4.png
  10. Click the Score mapping tab to enable the score calculation.
    1. Select the Enable score mapping check box.
    2. In the Set field, enter or select CreditScore.
    3. CH20726_3_Image _3.png
  11. Click Submit

2 Create a Decision Table

Task 2: Create a decision table

  1. On the canvas, right-click, and then select Business rules > Decision table to add a Decision table component.
  2. Open the Decision table component properties.
  3. In the Name field, enter Risk Segmentation.
  4. Set the Decision table value to RiskSegmentation.
  5. To the right, click the Open icon to create the decision table.
    Decision table properties
  6. On the Create Decision Table page, ensure that Development branch [No branch] is selected.
  7. Change the Apply to class to PegaCRM-Data-Customer.
  8. Click Create and open.
    Create decision table
  9. Click the Parameters tab and enter the following details.
    1. Name: CreditScore
    2. Description: Customer’s credit score
    3. Date type: Integer
    Parameter in Decision table
  10. In the Table tab, in the tool bar, click Insert column After to add another column..
    Decision table
  11. In the Conditions column, click the first cell to select the first Property.
    Condition of decision table
    1. In the Property field, enter or select .PrincipalLoan.
    2. In the Label field, enter Outstanding loan amount.
    3. Select the Use Range check box.
    4. Click Save to return to the Table tab.
      Set condition 1
  12. In the Conditions column, click the second cell, and then enter the following information:
    1. In the Property field, enter Param.CreditScore.
    2. In the Label field, enter Credit Score.
    3. Select the Use Range.
    4. Click Save to return to the Table tab.
      Set condition 2
  13. Click the Results tab.
  14. In the Results tab, expand Additional Allowed Results.
    Set results of decision table
  15. In the Result field Enter AAA.
  16. Click the Add icon to add the next result.
  17. Repeat step 16 to add the results AAA-, AA, AA-, BBB, BBB-, BB-, and CCC.
    Results of DT
  18. Click Save.
  19. Go to the Table tab and Check Out.
  20. In the if row, enter the following values:
    1. Outstanding Loan Amount: 10000
    2. Credit Score: 600
    3. Return: AAA
      Add values to decision table
  21. Click the Insert Row After icon to add an else if row. Enter the following values in that row:
  22. Outstanding Loan Amount range: 10000 - 25000
  23. Credit Score: 600
  24. Return: AAA-
    Add values to decision table row 2
  25. Enter the following eligibility conditions and return values.
    Add values to decision table all rows
  26. Click Check in to save and close the decision table.

3 Ensure that customers in the risk category BB- and CCC are ineligible for credit cards

  1. In the Decision Table properties window, in the Decision table field, enter or select RiskSegmentation.
  2. Expand the Supply data via section and set the CreditScore parameter to .CreditScore.
    CH20726_16_Image .png
  3. Click Submit.
  4. On the canvas, connect the Determine Credit Score component to the Risk Segmentation component.
  5. On the canvas, right-click, and then select Arbitration > Filter to add a filter component.
  6. Right-click  the Filter component, and then select  Properties.
    1. In the Name field, enter Low Risk.
    2. Open the Expression builder to define the condition as RiskSegmentation.pxSegment!="BB-"&& RiskSegmentation.pxSegment!="CCC".
      CH20726_17_Image .png
    3. Click Submit.
  7. Add another Filter component.
  8. Right-click the Filter component to enter the properties.
    1. In the Name field, enter High Risk.
    2. Open the Expression builder to define the condition as RiskSegmentation.pxSegment="BB-"|| RiskSegmentation.pxSegment="CCC.
      CH20726_18_Image .png
    3. Click Submit.
    4. A dotted line connects the Risk Segmentation decision table component to the Filter component.
  9. Connect the External Input to both Filter components and then the Filter components to the Results. The strategy should look like the following image.
  10. CH20726_19_Image .png
  11. Save the strategy.

4 Test the strategy for different customers

  1. Log in to the U+ Bank website as Robert to test the strategy with AllCreditCards in the For external inputs use strategy field.
  2. Click Run.
  3. On the canvas, click the Risk Segmentation component, and then verify that the decision table classifies Robert in the CCC risk category.
    CH20726_20_Image _0.png
  4. Click the Low Risk Filter component and confirm that Robert is ineligible for any of the credit cards.
    CH20726_21_Image .png
  5. Repeat  step 4 to verify that Arnold is categorized in the BBB risk segment and is eligible for all credit cards.
    CH20726_22_Image _0.png

5 Add a relevant record for the decision strategy created.

 

  1. Log in as Decisioning Administrator with user name CRMDecisioningAdministrator and password install.
  2. In the header of Dev Studio, click Configure to add a relevant record.
    1. Click Application -> Inventory -> Relevant Records.
    2. In the Class name list, select PegaCRM-Data-Customer.
    3. Click Add records.
    4. In the Type list, select Strategy.
    5. In the Record name field, enter or select Risk Segmentation
      CH20726_23_Image _0.png
    6. Click Submit.
    7. In the lower left, click the user profile image, and then select Log off.

6 Amend Next-Best-Action Designer’s Eligibility criteria for the Credit Cards Group.

  1. Log in as Decisioning Analyst with user name CDHAnalyst and password rules.
  2. In Customer Decision Hub, click Next-Best-Action > Designer.
  3. In the Next-Best-Action Designer click Engagement policy to access the engagement policies.
  4. In the Business structure, click the CreditCards group.
  5. Click Edit.
  6. In the Eligibility section, click the Add icon to add a new row.
  7. In the first drop-down, click the down arrow.
  8. In the list, select Strategy > Risk Segmentation.
  9. Ensure that has results for Low Risk is selected.
    Decision table eligibility condition
  10. Click Save.

7 Confirm your work

  1. From the Exercise System landing page, click on U+ Bank to open the website.
    CH20726_25_Image .png
  2. On the website main page, on the top right, click Log in to log in as a customer.
  3. Log in as Robert, and verify that he is not eligible for any card offers.
  4. Log in as Arnold, and verify that he is eligible for card offers.


Available in the following mission:

We'd prefer it if you saw us at our best.

Pega Academy has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice