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
March 24, 2021

Time to Review Tracker Configurations; Tracker Purges Begin in March!

Time to Review Tracker Configurations; Tracker Purges Begin in March!

ATTENTION ONLINE CREDIT UNIONS Automated tracker purges have arrived (again)! Last year’s automated tracker purge routine was re-worked and rescheduled, and will now begin March 1, 2021. What is Happening? We will manually purge all tracker conversations that are outside of individual CU-configured retention periods throughout March, based on tracker volume. Then,  in April we… Read more »

Feb 5, 2021

Asterisk Intelligence debuts KPI Operational Consulting

Asterisk Intelligence, a data analytics team at CU*Answers which provides business intelligence consulting, fulfillment, and educational services to credit unions, recently added Key Performance Indicators Operational Consulting to their bench of professional service offerings. KPI Operational Consulting engagements take a three-pronged approach to manufacturing value: awareness, education, and data monetization. “We want to empower credit […]

Feb 2, 2021

Asterisk Intelligence completes exploratory analysis for Cumberland County FCU

Asterisk Intelligence, a data analytics team at CU*Answers which provides business intelligence consulting, fulfillment, and educational services to credit unions, has recently completed an explorative analysis commissioned by Cumberland County FCU. The analysis examined available data on branch activity, studying the members who visit a branch and the transactions which occur at a branch. The […]

Feb 2, 2021

The Next Data Warehouse Upgrade Arrives in March

The Next Data Warehouse Upgrade Arrives in March

Attention Data Warehouse Subscribers: Beginning 3/7/2021, your Data Warehouse library will be temporarily unavailable until 3/28/2021 while CU*Answers performs upgrades to our Production server.  During this time, all CU*Answers online credit unions will be running off our High Availability server. Because the Data Warehouse library (FILExxDW) is stored on Production and not replicated to HA,… Read more »

Jan 26, 2021

Analytics Booth is FREE for Credit Unions with Less Than 2,000 Members!

Analytics Booth is FREE for Credit Unions with Less Than 2,000 Members!

The Asterisk Intelligence team is excited to announce that, beginning in 2021, Analytics Booth will be free to all credit unions with less than 2,000 members.  With your subscription to Analytics Booth, you will have access to 80+ trend lines of your credit union’s data, 12 dashboards, customized alerts, Powerlines, etc.  To activate your subscription,… Read more »

Jan 19, 2021

Engage Your Board of Directors with a Dive into Analytics Booth!

Engage Your Board of Directors with a Dive into Analytics Booth!

Board Member engagement is critical to the health and success of your credit union.  Some of the most important contributions your board can make come from asking the right questions and challenging the status quo. If you’re looking to further engage your Board of Directors, Asterisk Intelligence can support your initiative with an educational briefing… Read more »

Jan 15, 2021

Free Download from AI for the 20 Quick Data Fact Projects Book

Free Download from AI for the 20 Quick Data Fact Projects Book

Free Download: 20 Quick Data Facts Book from Asterisk Intelligence Be surprised by data about your credit union!  See some information that raises more questions that you want to research and learn!  Discover (or re-discover) a data set you didn’t know you had at the click of a button! There are thousands of facts available… Read more »

Jan 13, 2021

Analytics Booth is FREE for Credit Unions with Less Than 2,000 Members!

Analytics Booth is FREE for Credit Unions with Less Than 2,000 Members!

The Asterisk Intelligence team is excited to announce that, beginning in 2021, Analytics Booth will be free to all credit unions with less than 2,000 members.  With your subscription to Analytics Booth, you will have access to 80+ trend lines of your credit union’s data, 12 dashboards, customized alerts, Powerlines, etc.  To activate your subscription,… Read more »

Jan 7, 2021

Kick Off the New Year with Analytics Booth!

Kick Off the New Year with Analytics Booth!

Take on the new year with enhanced operational reporting and improved trending abilities – impress your board with insights powered by Analytics Booth! Take advantage of operational trend lines and organizational insights accessible anywhere you have an internet connection.  Never wait for the end of the month again to review your performance – enjoy daily… Read more »

Dec 28, 2020

Asterisk Intelligence completes a data tune-up

Asterisk Intelligence, a data analytics team at CU*Answers, which provides business intelligence consulting, fulfillment, and educational services to credit unions, recently completed a Data Tune-Up consulting engagement with a Texas based Credit Union. A Data Tune-Up helps credit union partners learn how to manage their operations in ways which allow for more detailed analytics, insights, […]

Dec 16, 2020