Data and Analytics – An Iterative Process

Many people out there believe that a data and analytics program can be developed with a single purchase, hire, or action. Like installing Microsoft Excel or some other “plug and play” software, these individuals believe their data and analytics program will be installed and voilà – a data and analytics program exists. Let me be […]

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 […]

Report Inventory: A Business Intelligence Gold Mine

Our last post discussed the value of a data inventory – a list of all data sources throughout your organization. A data inventory is one of the first and most critical steps towards developing a long-term business intelligence strategy and roadmap. The next key discovery document we will discuss is the “Report Inventory” and why […]

sample data inventory

Data Inventory: What and Why

A critical first step of developing any successful business intelligence strategy is to first understand what data sources are at your disposal. Identifying these data sources, their owners, and their priority is the crux of the “Data Inventory”. Why do I Need a Data Inventory Did you ever get a box of legos as a […]

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 […]

Value of Data vs. Amount of Data

Business Intelligence: A Top-Down BI Strategy

Business intelligence and proper data utilization are becoming integral components of an organization’s success. As the amount of data amassed by each company continues to grow, so too will the value of properly utilizing that data. The chart below will have an entire post dedicated to it in the coming weeks. Your first thought after […]

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 […]

Using the SQL Agent to Automate SSIS Packages

In our last post, we learned how to use SSIS to export data to a flat file. While that is certainly a step in the right direction towards removing all manual effort from our reporting processes, we still had to manually kick off that SSIS package. In this post, we are going to learn how […]