Abstract:There exit many problems in the traditional footwear sales system, such as its data collection is not comprehensive, and the accuracy is not high, which will lead the unscientific decision-making and therefore cause the resources waste. In this paper, the data warehouse shoe sale system is designed. The footwear sales analysis design, data migration, sales data analysis based on the data warehouse and On-Line Analytical Processing(OLAP) technology are discussed. The multidimensional analysis for footwear sales data in the system is realized.