Tell Me More About Data Warehouses

What It Is

A data warehouse is the digital storage unit. It is a space to hold specialized data sets that are then used for curating new member trends, marketing campaigns, strategic analysis, and other data strategies defined by credit union. A direct line from core processing to a storage unit. A holding space for 3rd party data you wish to link with core processing data. No additional hardware or software to buy. A storage unit for containing data that teams can use further credit union data-driven decisions – all this and more is what you get when you decide which storage unit is right for the design of your data strategy.

Simply put, a data warehouse is a space to store the data sets made available only to those who have the space to process them.

Join Your Peers

Credit Unions small and large use a Data Warehouse today!

Order your warehouse today!

Why You Want It

Mix 3rd party data with CU*BASE data for analysis that wasn’t possible before – New insights and depth to lead decision-making and member analysis. Optics data offers objective monitoring on how members engage when they aren’t doing a transaction – click-tracking data on phone support and members online banking habits. Or, customize what you keep longer – What do you need to save that keeps slipping through your fingertips?

What You Can Do With It

With a data warehouse, you can store data from elsewhere in CU*BASE, as well as data from outside of CU*BASE that you wish to use inside.

General Storage

Data Project Files

  • Excel documents to track member relationship information outside of CU*BASE
  • Non-member data collected at events for purchased for marketing projects

3rd Party File Uploads

  • Results from a 3rd party vendor or email processor
  • Results from external member survey campaigns

Long-Term Archives

General File Archives

  • Custom Query output files, to lock them in for long-term availability
  • Self-managed archives of key core files for extended retention

Tracker Archives

  • Automatically archive older tracker records from the CU*BASE core data

About Tracker Archiving

Optics Data

Phone Optics

  • Wrap-up coding data for why your members call

Phone Optics

Online Banking Optics

  • Click-tracking data from CU*BASE’s non-transactional online banking data

Online Banking Optics

Card Activity Optics

  • Analyze card network traffic patterns (warehouse capabilities coming soon)

How You Use It

A set of native tools exists in CU*BASE to manage your warehouse:

The Library Dashboard

This tool (#1980) allows you to manage your data warehouse. You can sort, explore, change, copy, delate, or rename the files and data sets in your warehouse. Additionally, Tool #1981 is a simple tool for you to manage the list of individuals who can have the right to view or use the Data Warehouse. A user needs to be on the list in order to run queries that use data living inside your Data Warehouse, to add new data into the Data Warehouse, and to delete or make changes to data inside the Data Warehouse  More About the Library Dashboard

Data Transfers (Uploads & Downloads)

This tool (#1375) you may be familiar with! This tool allows authorized users to commit data to their data warehouse via file transfers. More About Data Transfers.

Report Builder (Query)

The solution for customized reports, CU*BASE Report Builder is a specialized function allowing users to pull out data elements from CU*BASE tables to generate custom information. In conjunction with report automation, report output can be automatically added to your data warehouse. More About Report Builder.

How Much It Costs

You’ll pay a one-time amount of $1000 to have your credit union’s Data Warehouse established in CU*BASE. Once established, you’ll pay a small base fee of $100 per month plus a simple $10/GB based on the plan you choose.
 


Click any option below to learn more.

 

 

   

See what Asterisk Intelligence Data Warehousing has to offer!

Asterisk Intelligence Data Warehousing products are now available to order in the store.

Shop Asterisk Intelligence Data Warehousing

Updated
January 31, 2022

Meet the Analyst: Deriving Data Insights to Help Your Business Strategy

Meet the Analyst: Deriving Data Insights to Help Your Business Strategy

In order to become a more data-driven organization, you need a person or a team that ensures quality information can be used in a meaningful way throughout your entire business.  Meet the Analyst is your human resource for managing a range of data-driven functions, including overseeing data management, creating data strategies and improving data quality…. Read more »

May 4, 2022

Frankenmuth Credit Union gets started with a data warehouse

Asterisk Intelligence, the data analytics and data warehousing team at CU*Answers, recently announced that Frankenmuth Credit Union (Frankenmuth, MI) has partnered with the data analytics consultants to establish a data warehouse with CU*Answers. “Turning on another data warehouse solution is always exciting and it’s a privilege to be working with another credit union who is […]

May 2, 2022

Asterisk Intelligence offers new NSF and Courtesy Pay fee program analysis

Asterisk Intelligence, the data analytics and data warehousing team at CU*Answers, recently announced it is offering a new service designed to address the growing interest in NSF and Courtesy Pay fee programs. “In 2022, we have seen a noticeable increase in credit unions looking to analyze and understand the performance of their NSF and Courtesy […]

Apr 28, 2022

Asterisk Intelligence Presents: Custom Queries and Training Opportunities

Asterisk Intelligence Presents: Custom Queries and Training Opportunities

Did you know?  The Asterisk Intelligence team can help build a query for custom reports or data mining insights for your credit union!  These query results will be provided as a database file in your QUERYxx CU*BASE library.  Training is also available upon request, so that you can run the query on your own in… Read more »

Apr 28, 2022

Video Now Available: What are My Members’ Remote Banking Habits?

Video Now Available: What are My Members’ Remote Banking Habits?

Deciding how to meet your members’ needs remotely can be tricky.  Without thorough analysis, you may end up utilizing risky and ineffective tactics.  Now available is a video recording of a recent webinar hosted by Keegan Daniel, VP of Professional Services with Asterisk Intelligence and Kristian Daniel, VP of MTG, Sales & Business Development.  In… Read more »

Apr 26, 2022

Optics Data Zooms in on Member Engagement, Click-by-Click

Optics Data Zooms in on Member Engagement, Click-by-Click

With data collection for Online Banking Optics and Phone Optics, your credit union can have a more detailed analysis of your member base and the ways they are engaging with your organization.  Best of all, these data collection options are FREE to activate for Data Warehouse users! Online Banking Optics Data Collection With Online Banking… Read more »

Apr 20, 2022

Announcing the Data Fact Q1 Contest Winner!

Announcing the Data Fact Q1 Contest Winner!

Throughout Q1 2022, the Asterisk Intelligence team sent a total of 116 Data Fact emails to our credit union partners.  Data Facts are designed to raise awareness of CU*BASE tools, strategies, and tactics which can be used to analyze your credit union operations, identify areas of opportunity, and offer tactics for taking action and DRIVING… Read more »

Apr 18, 2022

Today’s Quick Tip for Managing Your Data Warehouse: Know What “Access” Means

Today’s Quick Tip for Managing Your Data Warehouse: Know What “Access” Means

We’ve collected questions that have come across the Asterisk Intelligence desk and have put together a series of tips for your organization to manage your Asterisk Intelligence Data Warehouse.  Ongoing attention to data quality and established procedures can help avoid a messy or frustrating database down the road. Today’s tip: know what “access” means (refer… Read more »

Apr 15, 2022

How can Analytics Booth Strengthen Your Credit Union’s Financial Performance?

How can Analytics Booth Strengthen Your Credit Union’s Financial Performance?

Your credit union processes transactions every minute, every hour, every day – thousands of pieces of data are getting generated, collected and stored.  With Analytics Booth, you can track and trend your credit union’s data and have it delivered wherever and whenever you want it! Join the Analytics Booth Executive Management series and learn how… Read more »

Apr 13, 2022