PLATFORM

Ability for a credit union to access and organize data coming from different data sources.

DATA WAREHOUSE

Allows decision-makers to quickly understand member behavior and access deep analytics without requiring technical resources

Enhancements

• Data Validation Report

  • 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:

Added Transaction Details drill-through button to give users the ability to connect to data via API to see all transaction details.

Added new filters: Account Charge Off Date and Account Status Code

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

Please reach out to your account manager with any questions about the overview of the exciting updates that occurred within 25.1.1 release.