Data Facilitation
AnalyzeCU: Format Requirements
AnalyzeCU: Format Requirements In order to utilize the analytics platform we have created, your AIRES files must be uploaded and be in the specific format that matches the NCUA requirements. You can find all the information you need HERE (https://4542559.fs1.hubspotusercontent-na1.net/hubfs/4542559/analyze-cu/AIRES%20and%20AIRES%20Plus%20Specification.pdf on the formatting. If you have any questions, please email support@cucollaborate or am@cucollaborate and someone from our team will be hSome readersHow to: AIRES File Code Mapping
How to: AIRES File Code Mapping To get the full value out of the software and to allow us to measure risk-based member benefit - we need to have your team map your share products, loan products, and payment frequency codes (your product codes should exactly match DEXA). Here is a video showing you how to map the necessary codes. If you have any questions on the process or any other querSome readersAnalyzeCU: Data Preparer Information
The Data Preparer The Data Preparer is a desktop tool that was developed as an extension for the AnalyzeCU website. Its main goal is to anonymize and encrypt personally identifiable data and other sensitive data in your AIRES files. This app also supplies decryption for files that you choose to export from the AnalyzeCU website. Encryption and decryption of files is done with an encryption key that has a *.aced file format. This encryption key can be generated via the Data Preparer app. AfterSome readersAnalyzeCU Helpdesk
Through the use of a readily available, standardized data set, we have made data analytics accessible and actionable for all participants of the CUCollaborate platform—helping credit unions demonstrate purpose, economic impact and relevance to the stakeholders they serve. The platform is comprised of several components that provide several views to assist credit unions in analyzing data such as detailed member demographics, how far a CU is from the miFew readersAnalyzeCU: AIRES+ Upload Instructions
Guidance on uploading AIRES+ files to AnalyzeCU 1) Prepare AIRES+ file with your members' birthdates: AnalyzeCU now has the ability to ingest member birthdates in addition to the data from a credit union’s AIRES share and loan files via a modified version of the AIRES share file that we are referring to as an “AIRES+” file. Guidance on formatting the file for upload here: AIRES and AIRES Plus Specification.pdf (windows.net). Please keep the following considerations in mind when preparingFew readersAnalyzeCU: Explanation of Encryption in Data Preparer
Explanation of Encryption in Data Preparer What Encryption Are We Using? In Data Preparer, we use a method called symmetric encryption. Specifically, we use an algorithm known as RijndaelManaged, which is a part of the Advanced Encryption Standard (AES). This method is widely used across many industries for securing data. How Does It Work? Key: This is a password that only you and the system know lives locally on your desktop. It's used to lock (encrypt) and unlock (decrypFew readersHow to delete your own AIRES file upload?
How to delete your own AIRES file upload? Please see below step-by-step instructions to delete your files! When AIRES files are uploaded into the system on within the data management page under AnalyzeCU, we can find the status of each uploaded file set. From here, hover over the desired row and select the three dots. By clicking on three dots, you will find a sub menu with additional features. One of them is Delete file. (https://storage.crisp.chat/users/helpdesk/website/56afcec6Few readersAutomate Your AIRES Files Uploads with PowerShell
CUCollaborate has built a comprehensive suite of products designed to address the unique challenges faced by credit unions. Many of these challenges can only be effectively addressed when CUCollaborate has access to the necessary data. For this reason, CUCollaborate recommends uploading your AIRES Files on a weekly basis to maximize the accuracy of analysis. To make secure data sharing easier than ever, CUCollaborate has developed the "AIRES PowerShell Automation Script," which eliminates theFew readersThe Role of Date of Birth within the CUCollaborate Software
The standard AIRES Share file does not contain a date of birth value. However, this information is crucial for key demographic elements and our Low-Income Designation software. To address this, we have introduced the term AIRES+, referring to the Share file which includes a 21st column specifically for the date of birth. In this article, I will outline the benefits that credit unions can gain by providing date of birth data. LID product For credit unions interested in identifying andFew readers
Low-Income Designation
This section contains no articles.
AnalyzeCU: How to encrypt and upload your AIRES files
How to encrypt and upload your AIRES file? Please see below step by step instructions to upload your files! If video instructions are preferred you can view that here. Prepare your files by downloading them from your core processor and ensuring that the files contain the mandatory fields. You can find our comprehensive guide on formatting HERE (https://info.cucollaborate.com/hubfs/analyze-cu/AIRES%20and%20AIRES%20Plus%20SpeciPopularAnalyzeCU Information
What is AnalyzeCU? AnalyzeCU is a geospatial platform that integrates spatial science, deep learning, and data mining overlayed with demographic and credit union member data that enables all credit unions that participate to build insights, benchmarking, awareness and understanding with actionable plans to grow their markets, products, members, and social impact; Through the use of a readily available, standardized data set, we have made data analytics accessible and actionable for all partSome readersAnalyzeCU: Social Security Numbers in AIRES Files
The "Social Security Number" field in your AIRES files does not actually have to be a literal social security number or even TIN. Per the NCUA's guidance, the field can contain either a social, tax identification number or "any unique, alphanumeric identifier within the 12-digit character limit can be used in lieu of the social security number." The key to this field is that the value uniquely identifies the person and this valueSome readersAnalyzeCU - LID Dashboard Member Counts
Low Income Designation Dashboard - Member Counts The number of unique members counted in the LID Dashboard needs to be within 10% of the total members submitted with the last Call Report. Ultimately, the methodology you use to identify and count unique members for the Call Report needs to be the same method you use to identify and count unique members for the AIRES+ file. If your member count number in the LID Dashboard is larger than your latest Call Report, that could be due to: *Few readersAnalyzeCU: FAQs
General AnalyzeCU FAQ: https://datapreparer.blob.core.windows.net/public-documentation/AnalyzeCU%20FAQ.pdf Data Preparar validation errors: https://datapreparer.blob.core.windows.net/public-documentation/Data%20Preparer%20Validation%20Errors.pdf AIRES file processing - Best Practices: https://datapreparer.blob.core.windows.net/public-documentation/AIRES%20File%20Processing%20Best%20Practices.pdf AnalyzeCU AIRES Formatting Specifications: https://datapreparer.blob.core.windows.net/public-doFew readersAnalyzeCU LID Report: P.O. Box Cleaning Approaches for LID
Why Clean Up P.O. Box Data? The NCUA’s primary method for assessing whether a credit union member qualifies as low-income for LID attainment is by using the member’s address to determine if the member lives in a Low-Income Designated (LID) area (a county, census tract, census block group, or zip code). P.O. Boxes cannot be accurately geocoded, nor can they be used to assess the location of a residence. Members with P.O. Box addresses therefore are automatically not counted in the credit unFew readers