25.1 - Product Release Notes (Overview)
- Nate Wentzlaff
- Nate Wentzlaff
25.1 Release Highlights:
New Model Available (Early Adopters Needed) - New Member Acquisition
Member Profile - “Search By” enhancements to easily find members
PLATFORM
Ability for a credit union to access and organize data coming from different data sources.
USER PORTAL
Front door to Trellance Analytics
New Features
Configuration UI in User Portal
Users are now able to configure their Products, Transaction Types, and Channels within a UI in the User Portal. If there are any unconfigured values, an alert will be displayed with a link to the corresponding configuration item.
Product Types:
Transaction Types:
Channels:
New Report Available! - Report Usage
By monitoring every time a user accesses a report through the Trellance User Portal, Report Usage gives the BI leadership team at a credit union useful insight into how all the reports published in the user portal are being used.
Through the Report Usage report, users are able to gather the following insights from their internal users' behavior:
Total Views by Report Name
Total Report views over time
Total Users by Report Name
Total Report Users over time
DATA WAREHOUSE
Allows decision makers to quickly understand member behavior and access deep analytics without requiring any technical resources
New Features
DNA DW Integration - New Mapping
Transaction Narration 1 is mapped using EXTRTXNDESCNBR from DNA_ODS.
Transaction Narration 2 is mapped using INTRRTXNDESCNBR from DNA_ODS.
Enhancements
To assist in validating the completeness and accuracy of a Credit Union’s data in the Trellance Data Warehouse, the data validation report has been enhanced for easier validation of data and the config doc input.
Added Transaction Type Code to the Transaction Sub Type Configuration:
Executive Dashboard with Financials - ROA calculation updated
Return on Assets is now annualized to ensure consistency with NCUA standards.
Branch/Channel Transaction Analysis - Include latest date
Branch Transaction Analysis and Channel Transaction Analysis have been updated to include the latest date within the report.
Previously, the report cut off the data at the previous month-end. For example, the report below is now updated to show 11/17/2024 (which is the latest Transaction Posting Date as of the time this report was pulled). Previously, it would have only showed 10/31/2024.
Member Id assignment from DNA
Mapping updated to ensure the correct assignment of Member Ids between Person and Org Member types from DNA.
Inclusion of all accounts in CU Analytics from Keystone.
Mapping has been updated to ensure every account is loading throughout the entire Data Warehouse (ODS, CU Analytics, API, and Reports).
Late Arriving Membership data now being captured from Keystone.
Mapping has been enhanced to look back for late arriving membership information (i.e. Membership Begin Date, Membership Opened At Branch, etc.) when memberships are opened and details about the membership opening are delayed until after the account details are loaded from Keystone.
CU Analytics Load (+API and Dashboards) updated to look back 30 days for delayed accounts
Whenever an account is delayed from appearing in the core, CU Analytics will now update the account details within CU Analytics for the Reporting Period Date according to when the account was opened. This ensure all downstream consumption (i.e. Reports in User Portal and API) have all accounts loaded within the time frame of the account’s open date.
For example, if an account is opened on January 25th, but is not processed into the source system until February 5th, CU Analytics will show the account details for January 31st. Previously, the CU Analytics layer only looked back 7 days. However, after feedback from several credit unions, the need to extend this timeframe back to 30 days.
Add 'Is Member' filter to all relevant reports for Member Configurator
Member Configurator empowers users to define a member based on business rules. The rules are then leveraged by Trellance to setup an “Is Member” field to define a member (Y) or a non-member (N).
To facilitate the Member Configurator, the “Is Member” filter displays whether the member meets the Member Configurator criteria.
The “Is Member” filter has been expanded to the following reports:
Account Operator Analysis
Branch and Lender Loan Analysis
Credit Card Relationships
Credit Card Risk Portfolio
Current Loan Portfolio Analysis
Data Validation
Deposit Relationships
Lending Relationships
Loan Account Summary
Loan Charge-Off Analysis
Loan Pool Balance (Original) Analysis
Loan Static Pool Analysis
Member Profile
Mapping updates for XP2 DW Integration
Interest Rate mapping updated to use the RATE from the LOAN table in XP2_ODS.
Previously, the mapping was using INT_RATE. Based on user feedback, the mapping has been adjusted to use RATE from the LOAN table in XP2_ODS.
PowerBI Migration to Fabric
In order to deliver faster load times and rendering for end users, along with keeping with the latest version of PowerBI, all Data Warehouse and Predictive Analytics clients' PowerBI workspaces have been upgraded to use Microsoft Fabric.
Episys DW Integration - Mapping Logic Update
Transaction Amount mapping has been updated to ensure the correct amount reflecting the absolute value of the Interest Amount, Fee Amount, Escrow Amount, and .
XP2 DW Integration - Mapping Logic Updates
Operator Full Name doesn’t populate when Operator name changes
Fixed to ensure all records have the Operator Name populating.
MEMBER_NBR changes in XP2_ODS causing duplicate transactions
Fixed to ensure only one transaction populates within Data Warehouse.
INSIGHTS
Ability for credit unions to quickly access and generate insights from the data via data visualizations and the ability to drill-through to the details.
Descriptive Analytics
Ability for credit unions to use leverage KPI’s and trends to make critical decisions that enhance the lives of its members.
Enhancements
Charge Off Amount has replaced the “Charge Off Balance” across all reports.
Previously, reports were using a “Charge Off Balance” that was not adequately capturing the actual amount that was charged off on the account as this information is stored separate from the balance (especially as recoveries are made on the account).
Account Original Credit Score has replaced the Member Credit Score across all reports.
Previously, reports were using the member’s credit score based on the date of the their credit pull.
LOAN ANALYTICS
Deep analysis into Credit Unions' loan portfolio to give deep insights and ensure compliance with regulations.
New Features
Loan Portfolio Analysis - three new tabs added (LTV Migration, CLTV Loan Type, and Real Estate CLTV):
LTV Migration:
CLTV Loan Type
Real Estate CLTV
PREDICTIVE ANALYTICS
Ability for credit unions to use machine learning and AI to predict future outcomes and proactively address members’ needs.
New Features
Enhancements
Next Best Action - UX Improvement to display all recommended actions on Next Best Action and Member Profile within Predictive Analytics dashboard.
Predictive models now trained with a further expanded Data Pool for even better lift!
MARKETING SOLUTIONS
Outcome-oriented business solutions designed to help credit unions get the most out of their data.
Balance Transfer Campaign
Added a new offering: Offer-to-Apply for a Balance Transfer Campaign template with associated workflows and triggers in HubSpot with a streamlined process for setting up Offer-to-Apply campaigns across HubSpot accounts.
This new campaign is an offer for current cardholding members to request a balance transfer which completements the current Balance Transfer Marketing Kit.
API updated for Smoother Hubspot Integration
Marketing Solutions leverages the Predictive Analytics data via the Trellance API to integrate with HubSpot. In order to give a smoother experience to users, the API connection has been enhanced to more efficiently load data into HubSpot.
Please reach out to your account manager with any questions about the overview of the exciting updates that occurred within 25.1 releases.