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

Register for Asterisk Intelligence Week at CU*Answers

Register for Asterisk Intelligence Week at CU*Answers

Join the Asterisk Intelligence team for one or more sessions in the July Asterisk Intelligence Week! Options include both skills and strategy sessions! During the event, participants will review and discuss data analytics, data management, and data warehousing solutions and strategies. Also available by popular demand is an entire day of tactical skills instruction on… Read more »

Jun 22, 2021

Proving Data Strategies: CU*BASE Tool Usage Insights

Proving Data Strategies: CU*BASE Tool Usage Insights

Join the Asterisk Intelligence Team as they review the Tool Usage Analysis Dashboard (#1195) available within CU*BASE.  How effectively are you and your team utilizing CU*BASE and which tools are used the most by your team?  Did you know that the 21.05 CU*BASE release introduced 10 new features within CU*BASE; are your team members aware… Read more »

Jun 18, 2021

Asterisk Intelligence Presents: Removing Barriers that Keep You from Earning

Asterisk Intelligence Presents: Removing Barriers that Keep You from Earning

Data analytics can help your credit union make informed decisions and offer a competitive edge, yet misconceptions about data analytics can obstruct the impact and hinder your earning abilities.  During our upcoming webinar, the Asterisk Intelligence team will explore 3 common misconceptions surrounding data analytics and how your credit union can turn these fallacies into… Read more »

Jun 17, 2021

The AB_22.06 Analytics Booth Release Arrives June 27!

The AB_22.06 Analytics Booth Release Arrives June 27!

The Asterisk Intelligence Team is excited to present the AB_21.06 Analytics Booth Release, arriving to Analytics Booth subscribers on Sunday, June 27!  This release features: Additional Web Version launch points within four new CU*BASE tools to quickly access in-depth analysis. Seven new data points, such as average credit score and average weighted rate, in the… Read more »

Jun 14, 2021

Don’t Miss This Week’s Proving Data Strategies: Analytics Booth Peer Comparison

Don’t Miss This Week’s Proving Data Strategies: Analytics Booth Peer Comparison

Join the Asterisk Intelligence team as they review the Peer Group Trend Graphing feature of Analytics Booth.  Your data is an asset and it’s simple to gain quick value from it – track your operational trends alongside cuasterisk.com network peer groups, defined by you.  Available for all Trends in Analytics Booth, create a Primary Peer… Read more »

Jun 1, 2021

Proving Data Strategies: Analytics Booth Peer Comparison

Proving Data Strategies: Analytics Booth Peer Comparison

Join the Asterisk Intelligence team as they review the Peer Group Trend Graphing feature of Analytics Booth.  Your data is an asset and it’s simple to gain quick value from it – track your operational trends alongside cuasterisk.com network peer groups, defined by you.  Available for all Trends in Analytics Booth, create a Primary Peer… Read more »

May 27, 2021

Join the Asterisk Intelligence Team for a Release Review!

Join the Asterisk Intelligence Team for a Release Review!

Asterisk Intelligence Release Review: Data Strategies Join the CU*Answers Asterisk Intelligence Team for a review of their favorite changes and new tools implemented with the 21.05 CU*BASE release.  They will discuss new dashboards, feature enhancements and database changes from this release.  Hear firsthand how certain features can be integrated into your operations and help to… Read more »

May 24, 2021

Join the Asterisk Intelligence Team for a Release Review!

Join the Asterisk Intelligence Team for a Release Review!

Asterisk Intelligence Release Review: Data Strategies Join the CU*Answers Asterisk Intelligence Team for a review of their favorite changes and new tools implemented with the 21.05 CU*BASE release.  They will discuss new dashboards, feature enhancements and database changes from this release.  Hear firsthand how certain features can be integrated into your operations and help to… Read more »

May 19, 2021

Don’t Miss This Week’s Proving Data Strategies: Where Your Members… Shop/Borrow/Pay Bills

Don’t Miss This Week’s Proving Data Strategies: Where Your Members… Shop/Borrow/Pay Bills

Join the Asterisk Intelligence team as they review the set of “Where Your Members….” Dashboards within CU*BASE GOLD.  Your data is an asset and it’s simple to gain quick value from it – follow along with several fast and simple data reviews that bring light to exactly where members are doing their financial business outside… Read more »

May 17, 2021

Proving Data Strategies: Where Your Members… Shop/Borrow/Pay Bills

Proving Data Strategies: Where Your Members… Shop/Borrow/Pay Bills

Join the Asterisk Intelligence team as they review the set of “Where Your Members….” Dashboards within CU*BASE GOLD.  Your data is an asset and it’s simple to gain quick value from it – follow along with several fast and simple data reviews that bring light to exactly where members are doing their financial business outside… Read more »

May 13, 2021