| |
|
|
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. |
|