CMOs can use data

Five Ways CMOs Can Use Data

Data and analytics is exploding. Whether you call it big data, business intelligence, or analytics, it is clear that the use of data is going to be critical to any company’s success. Especially in the bank and credit union industry, data and analytics is a relatively new concept. Sure, data has been used in the […]

KPI

KPIs and the Sierpinski Triangle

Most people don’t know it by name, but most recognize the unique design of the Sierpinski Triangle. The fractal is designed by recursively breaking down equilateral triangles into increasingly smaller triangles. Mathematicians have a field day with this type of object, but most people don’t equate it to any type of practical business visualization. As […]

member segmentation and insights using analytics

Member Segmentation Analysis and Insights Using Analytics

In our last post, we discussed why analytics will become a necessity to compete in an evolving banking industry. In that article, we promised to follow up with a series of posts that contain specific examples of how analytics can be applied. This first post will discuss how analytics and business intelligence can be used […]

data warehouse different

What Makes a Data Warehouse Different?

I get this question all the time: what makes a data warehouse different from a regular database? To those in organizations with a less robust business intelligence and analytics maturity, it may be difficult to differentiate between the two. However, there are very distinct differences between a data warehouse and a regular database. In this […]

Becoming a Data-Driven Credit Union

Data warehouses, multi-dimensional analysis cubes, and predictive analytics can appear to be imposing goals. Where do we start? How quickly can we accomplish our data goals? Do I have the right talent? These questions, and many like them, create doubt and concern amongst credit union executives wondering how they can start utilizing data better and […]

Data Mass Value Curve

In my post discussing Top-Down BI Strategy, I introduced a chart which I call the “Data Mass Value Curve”. This graph identifies an exponential increase in the value of the data as a function of the amount of data available. That is to say that the more data you have available to you, the value […]

Import Data into SQL from Excel

In our last lesson, we showed you how to use SSIS to export data to Excel. In fact, all of our previous SSIS lessons have focused on exporting data from SQL into some other format. In this lesson, however, we will show you how to import data from Excel into SQL. This is very helpful […]

Using SSIS to Export Data to Excel

In our previous post, we learned how to append the date to flat file exports. This represents an intermediate level skill in SSIS but can be incredibly helpful in production business environments. Unfortunately, everything we have looked at in SSIS so far has related to flat files. More often than not our business users would […]

Append the Date to Flat File Exports with SSIS

In one of our previous posts, we provided instructions on how to use SSIS to export data to flat files. Often times, our business users would like to have a running history of exported data. For example, if we had an export that output all orders for the prior day our users wouldn’t want to […]