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

Using SSIS to Export Data to Flat Files

Up to this point, we have focused solely on using SSDT (SQL Server Data Tools) or BIDS (Business Intelligence Development Studio) to create SSRS reports. Another aspect of the Microsoft Business Intelligence software is a package known as SQL Server Integration Services or SSIS. SSIS is used primarily as a tool to move data in […]

Creating Data-Driven SSRS Subscriptions

In our last lesson, we explored how to create a basic SSRS subscription. This lesson is going to add some dynamic capabilities to the standard SSRS subscription to create a “data-driven SSRS subscription”. We are going to set up a data-driven SSRS subscription that, on a pre-defined schedule, outputs a report for share accounts opened […]

Creating SSRS Subscriptions

In our last post, we showed you how to create drill down SSRS reports so you can create incredibly dynamic reports. Drill down reports create dashboard-like functions right within SSRS. For those credit unions trying to maximize their BI investment, initially using SSRS over third-party BI visualization tools can minimize your upfront costs. What is […]

Drill Down SSRS Reports

Our previous post showed you how to create an SSRS report with multiple parameter data types. By doing that, we created even more dynamic reporting opportunities. An incredibly invaluable function of SSRS is the ability to “drill down” to other reports. The concept of “drilling down” is where you can click on a specific item […]

5 Steps to Start Developing your Business Intelligence Strategy

Big Data, Analytics, and Business Intelligence have become the most commonly used buzzwords in business.  Despite their varying uses and connotations, each boils down to a single proposition: how can we best use our data?   The answer may vary dramatically from credit union to credit union.  Perhaps your goal is to improve marketing returns […]

SSRS Reports with Date Parameters

How many of your reports are completed on a recurring basis: daily, weekly, monthly, quarterly? Imagine having the report automatically generated based on date values you can either select manually or have pre-selected? Automating recurring reports using date parameters can significantly reduce the amount of time it takes you to complete these requests. In this […]

The Knowlton Group Enters into a Strategic Partnership with OnApproach

Original Press Release from OnApproach. Plymouth, MN (June 8, 2015) – OnApproach (www.onapproach.com), a leading provider of advanced reporting and analytics solutions for credit unions, has entered into a partnership with The Knowlton Group (www.knowlton-group.com) to provide custom business intelligence solutions to enable credit unions to become more efficient and data-driven. The Knowlton Group works with […]

Building Your First SSRS Report

If you aren’t familiar with SQL Server Reporting Services (SSRS), please take a moment and read this articles on SQL Server Reporting Services (SSRS) from Microsoft. This post will give briefly introduce you to SSRS and describe some of its capabilities. One of the most important benefits of SSRS is that it is included in […]