Customer analysis and evaluation

Evaluating a customer in terms of criteria for the competitive position (X axis) and customer desirability (Y axis), such as sales, profit margin, financial reliability, planning precision and frequency of complaints. The customer criteria measured and the summarized customer evaluation for the X and Y axes are stored at various aggregation levels in an MS Access database. This data can be assessed visually by year in the form of a pivot table or in the form of a bubble chart/BCG matrix, using MS Excel.