摘要 |
A data warehouse system and application which analyzes historical sales and product data contained within a data warehouse to determine the best product prices across a set of products for a retailer. The application analyzes historical sales and product data contained in a database to determine an opportunity score for multiple products sold by a retailer, the opportunity score indicating potential benefit to said business from changing the pricing of a product; and analyzes historical sales data contained in the database to determine an ability to change score for each product, the ability to change score indicating potential risk of lost sales for the retailer from changing the pricing of a product. Results of the analyses are displayed in a scatter plot graph with the graph axes being the opportunity scores and ability to change scores, respectively. Each product is represented by a point in the scatter plot, the coordinates of the point being the opportunity score and the ability to change score associated with the represented product. The scatter plot graph can be divided into quadrants, wherein products having favourable opportunity scores and favourable ability to change scores are displayed together in one the four quadrants.
|