Don’t Get Lost in the Data

It’s often easy to get lost in the bells and whistles that most data and analytics tools offer. Fancy visualizations, interactive dashboards, and modern user interfaces make these tools difficult to say no to. But what tends to get lost in all the technology is a simple question: what business questions is my data going […]

The Knowlton Group Advantage

There are plenty of data and analytics consultants in the market. The choice of a data and analytics consultant can be critical to the success of your project, so how you can be sure you have chosen the best team to partner with? At The Knowlton Group, we specialize in working with financial institutions. We […]

reporting, BI, business intelligence, SQL reporting, excel reporting

Reporting – First Step for Business Intelligence

The terms business intelligence, data and analytics, and big data strike a combination of excitement and fear into business leaders’ minds. My goal for this post is to alleviate some of the fears associated with business intelligence and analytics (big data is a whole different world). Community banks and credit unions, regardless of size, can […]

What I Learned Starting The Knowlton Group

Yesterday, LinkedIn reminded me that The Knowlton Group has been around for three years! It certainly doesn’t feel like three years have passed since filing all the documentation and getting the company officially registered. Reflecting on this, the only thing more surprising than how fast time has flown is how much has changed in that […]

CFO Data, CFO Analytics

How a CFO Can Use Data and Analytics

Over the past few weeks, we have released posts describing how different members of the C-suite can make use of data and analytics. We started out discussing five ways CMOs can use data and then talked about the CLO and lending analytics. In this post, we want to highlight the ways that a CFO (Chief […]

data and analytics projects, data and analytics initiatives, business intelligence

Data and Analytics Projects: Focus on the Business First

An increasing number of organizations are making data and analytics an integral part of their business operations. In Thomas Davenport and Jeanne Harris’ book Competing on Analytics: The New Science of Winning, they define the most analytically advanced businesses as “Analytical Competitors”. These organizations embed data and analytics into their operations and are a fundamental […]

Lending Analytics, loan analytics, data and analytics

The CLO and Lending Analytics

In one of our last posts, we talked about how marketers can use data. As part of the growing usage of data and analytics, we want to highlight the different ways key executives can leverage data to drive their business. In this post, we discuss five ways that lending analytics can be used in any […]

SQL EXCEPT

SQL Except Set Operation

What is the SQL EXCEPT set operation? The SQL EXCEPT set operation is another set operation like the UNION or INTERSECT operations. This operation, however, returns all rows from the first query except those rows that appears in the second query. Think of this as subtraction but for sets. Visually, the SQL EXCEPT set operation […]

SQL INTERSECT, Set operations

SQL INTERSECT Set Operation

What is the SQL INTERSECT set operation The SQL INTERSECT set operation returns the distinct rows from two or more queries that appear in each query’s results. Unlike the SQL UNION set operation that returns all rows from both queries, the SQL INTERSECT operation only returns the rows that appear in both queries. Visualized with […]