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

SQL HAVING CLAUSE

Filtering Groups with the SQL HAVING Clause

What is the SQL HAVING clause? The SQL HAVING clause is a clause that allows you to filter out groups based on some filtering criteria. The HAVING clause is a lot like the WHERE clause; the only difference is that the WHERE clause filters rows, while the HAVING clause filters groups. For example, if we […]

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

SQL GROUP BY Clause

SQL GROUP BY Clause

(A quick reminder: take a look at our introduction to SQL post to learn how to download the sample database we are using) What is the SQL GROUP BY clause? The SQL GROUP BY clause allows you to group your data in some fashion. We usually use at least one aggregate function when using the […]

What is Big Data?

I hear the term “big data” being thrown around all the time now. “We have big data.” “We want big data.” “We need to develop a big data solution.” I believe that anything that gets people talking about data and its various applications is a positive. That being said, when most people say “big data” […]

SQL Aggregate Functions

SQL Aggregate Functions

What are SQL Aggregate Functions? Aggregate functions are functions that aggregate values and output a scalar (single-row) value as the result. Examples of aggregate functions include the COUNT, SUM, AVG, MIN, and MAX functions. For example, to find the total number of rows in the Person.Person table, we can use the query: SELECT COUNT(*) FROM […]

SQL ORDER BY

Using the SQL ORDER BY Clause

How do I sort data with the SQL ORDER BY clause? Sorting returned data is a very common task when completing SQL statements. Luckily, the SQL ORDER BY clause allows us to complete this activity pretty easily. For example, to return the the FirstName and LastName columns from Person.Person sorted by the FirstName column in […]

SQL Comparison Operators

SQL Comparison Operators

What are the different SQL Comparison Operators? In previous lessons, we have discussed many of the different SQL comparison operators that are available. These operators give you plenty of options to filter data in the WHERE clause of your SELECT statement. Having discussed many of them, I want there to be one consolidated place for […]

SQL Wildcard Operators and the LIKE Operator

SQL Wildcard Operators and the LIKE Operator

What is the LIKE operator? The LIKE operator is an operator that allows you to use SQL wildcard operators in the WHERE clause. SQL wildcard operators along with the LIKE operator allow you to search for patterns of strings. For example, to find all rows in the Person.Person table where the FirstName column starts with […]