Atlassian uses cookies to improve your browsing experience, perform analytics and research, and conduct advertising. Accept all cookies to indicate that you agree to our use of cookies on your device. Atlassian cookies and tracking notice, (opens new window)
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:
Open
Added Transaction Details drill-through button to give users the ability to connect to data via API to see all transaction details.
Open
Added new filters: Account Charge Off Date and Account Status Code
Open
Executive Dashboard with Financials - ROA calculation updated
Return on Assets is now annualized to ensure consistency with NCUA standards.
Open
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.
Open
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.