Background Note | HBS Case Collection | May 2007 (Revised March 2008)

Basic Techniques for the Analysis of Customer Information Using Excel 2003: A Step-by-Step Approach

by Francisco de Asis Martinez-Jerez

Abstract

Provides a set of easy, step-by-step guides for some analytical techniques that are useful in the analysis of cases discussed in the course "Competing and Winning Through Customer Information (CWCI)". The instructions that follow use datasets from three of the cases in this course: "Slots, Tables, and All That Jazz: Managing Customer Profitability at the MGM Grand Hotel"; "MercadoLibre.com"; and "Bancaja: Developing Customer Intelligence (A)". These datasets are available upon request from the author.

Keywords: Data and Data Sets; Management Analysis, Tools, and Techniques; Mathematical Methods;

Citation:

Martinez-Jerez, Francisco de Asis. "Basic Techniques for the Analysis of Customer Information Using Excel 2003: A Step-by-Step Approach." Harvard Business School Background Note 107-073, May 2007. (Revised March 2008.)