DAO Web Page of Fame

Celebrating Summer Successes Since 2006

  INDUCTEE:  Matthew Kirby

YEAR:   2006

CATEGORY: Pivot Tables


Matt Kirby used a pivot table to save Home Depot millions of dollars.

Home Depot asked Matt Kirby to help decide which product classes should be reduced to make room for the proposed 3X increase in space devoted to holiday decorations in 2006. The company originally intended to implement the same reductions across all stores. Matt quickly realized the value in tailoring the reduction decisions across regions. Using Pivot tables and Pivot charts, he was able to summarize the regional differences in category sales leading up to the holiday season. Based on these summaries, Kirby helped Home Depot developed product assortment plans tailored to each region that will be implemented in October-December of 2006.