DAO Web Page of Fame

Celebrating Summer Successes Since 2006

  INDUCTEE:  Gautam Sukumar

YEAR:   2007

CATEGORY: Pivot Tables


Gautam Sukumar used Pivot tables and regression extensively to accurately highlight the benefit of configuration profitability rather than individual commodity profitability. Historically, Dell
performed profitability analysis on individual components such as Hard Drive, Memory, Processor, etc and used the results of this analysis to set pricing for its computers. Gautam approached the problem differently. By analyzing profitability of a combination of individual commodities that make up a configuration, Gautam was able to identify several insights to help Dell improve its pricing model. One of the key highlights of the analysis was the identification of irregular discounting worth more than $35MM.