Image of a spreadsheet print out and calculator.

A Better VLOOKUP

I know what you are thinking. I was thinking the same thing before I started using the combination of the Index and Match functions.  Vlookup is a function that allows you to find a value in the left most column of a cell range and then return a value from a cell a certain number…

Stopwatch

When Query Speed Counts

There are often numerous ways to write a particular query or stored procedure. In some cases, the approach makes little difference. Other times it can lead to poor performance that wreaks havoc on an application or service. Taking care as you go will help to avoid slowdowns and prevent the need for rework when query…

Hands holding two puzzle pieces in front of various graphs and statistics.

Love a good data puzzle? I do.

In today’s world, as the frequency of mergers & acquisitions increases, there’s a corresponding increase in the need to ingest large amounts of digital information, combining new business data with the old. Data sets are rarely alike between companies that have the same basic products or services – or even when they use the same…