SSRS Report with Multiple Parameters

In the previous post, we showed you how to create an SSRS report with date parameters. In this lesson, we are going to expand upon the previous post and include another parameter with a completely different data type. Modifying the SQL Query and Adding a Dataset Our report currently returns all share accounts that were […]

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 (, a leading provider of advanced reporting and analytics solutions for credit unions, has entered into a partnership with The Knowlton Group ( 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 […]

Business Intelligence Lessons

Starting on Thursday (June 4, 2015), we will be releasing a series of blog posts to help credit unions, community banks, and anyone else interested to implement small business intelligence solutions today. We have created a sample banking database that simulates the data found in your operational environments. The goal of these posts is to […]

What to Consider When Building Your Credit Union Data 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 through […]

Using T-SQL Ranking Functions

It is a common request in data analysis to rank rows of data.  For example, “rank our top 10 lenders based on origination volume?”.  Some of these questions can be solved with the GROUP BY clause, while others can take advantage of T-SQL ranking functions.

Having Business Intelligence Software ≠ Having Business Intelligence

But I just bought this expensive, fancy data warehouse and reporting software? What do you mean I don’t have business intelligence?  A rampant thought amongst executives in the throes of their first business intelligence initiative is that if they have business intelligence tools then they must have business intelligence. That is sort of like saying […]

data warehouse different

Why Build a Data Warehouse?

Everyone seems to have built one and those who haven’t want one. A rational person might question whether or not this is simply a fad – a buzz word to throw around in conversation – or if there truly is a business justification for the effort and expense involved in data warehousing. For small and […]