Quick Tip for Report Writers – Use the Better Date from CUFMAINT

Save time, simplify your work, and stop typing your dates in both the YYMMDD and MMDDYY layouts each time you run a query over the File Maintenance data. The original Maintenance Date field of MNTDAT will naturally have dates in both layouts, which is friendliest for optimal processing by the programs that write out the…Read More

Good Read: A proof-of-concept has got me thinking…

Here’s something a little fun in the world of data – Mark Wilson’s recent article, “The humble receipt gets a brilliant redesign,” spotlights a proof-of-concept for a grocery receipt design that organizes and visualizes your purchases in a meaningful and informative way. The person who created this proof-of-concept, Susie Lu, is a data visualization engineer…Read More

Data Warehousing in the Core? It’s ready!

The Data Warehouse is a storage facility. One with open control to design your own database tables, then feed them with whatever data you need or want! Early in our process of thinking about a data warehouse for credit unions, a question was justifiably posed – “What are we/they even going to put in this…Read More

The Lightbulb Went Off – A Pie and a Bar

Have you ever really thought about what kind of chart to use when you’re graphing data? True Confession: I never did. I just went on instinct and blind luck until I began working and learning as a data analyst. Now, I definitely do realize how valuable visualizations are for communicating data. But I worry that…Read More

Asterisk Intelligence Week! (Again)

And again, and again, and again, and again. 🙂 Last month we hosted our 2nd ever Asterisk Intelligence Week training event. (Read my thoughts on AI Week #1 here). It’s definitely one of my favorite training events to do because we spend so much time with participants doing practical hands-on work. This time around interest…Read More

5 Soft Skills of Data Analytics

There are many people telling you how to “do” data analytics today. Use these tools, use these coding/query languages, these database structures are best, start with these projects, get executive buy-in this way, etc. What these articles and webinars often fail to acknowledge are the habits and skillsets that are critical to actually finding success…Read More

The Lightbulb Went Off…Add to Member & Y/N Conversions

I’ve recently been working on a hefty project that is stretching my skills with custom queries up to a new level, primarily with its requirements for very specific formatting and column rules. The part that became my lightbulb moment relates to hand-crafting Y/N (Yes/No) indicators on various pieces of information that do not already live in CU*BASE(r) data as Y/N. Quite a few were…Read More

Know the Numbers

Yesterday I had the pleasure of spending about 45 minutes with a group of ladies who are considering CU*BASE as the next core processor for their credit union. It was a perfect occasion to cover the sheer volume of pre-defined data resources available. As I was talking through some of the details, it struck me that I should definitely be telling everybody else the…Read More