• BI Summit - In Review

    I recently returned from a prominent event in the analytics and business intelligence space, and even having been home for a few days, my excitement over where the industry is headed stemming from all the great discussion I heard during the week continues…

  • Excel Puzzler - Problem Solved with AverageIf Function

    I could write SQL to solve this problem.. but the data was in Excel.

    I pulled pricing and mileage data from several car for-sale sites and dropped it in an Excel sheet. Columns include year, price, kilometers (mileage), etc. Here is a snippet of the data…