table joins, sql join

SQL Table Joins – RIGHT OUTER JOIN

What is the RIGHT OUTER JOIN The RIGHT OUTER JOIN is nearly identical to the LEFT OUTER JOIN. The only difference between the two types of OUTER JOINs is the order in which SQL evaluates them. The LEFT OUTER JOIN returns all rows from the first table and the rows that match from second table. […]

5 Reasons to Invest in Data and Analytics in 2016

It’s no secret that the amount of data in the world is growing at a tremendous rate. Some anticipate that the world’s data volume will grow 40% per year and expand to fifty times its current volume by 2020. Think about your own organization: how much data did you have ten years ago? Five years […]

Table Joins – SQL LEFT OUTER JOIN

What is a LEFT OUTER JOIN? Like the INNER JOIN, a LEFT OUTER JOIN allows you to connect multiple tables in the same query. However, the LEFT OUTER JOIN returns all rows from the left table (first table listed) where the joining key matches a row in the second table listed. This is represented by […]

SQL INNER JOIN

Learning Table Joins – SQL INNER JOIN

What is the SQL INNER JOIN? A SQL INNER JOIN is a technique that allows you to retrieve data from multiple tables by connecting them with a joining key. An INNER JOIN can be thought of as the intersection of two tables based on some joining key. Typically, ID columns like SalesPersonID or BusinessEntityID in […]

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