In order to meet the business needs of decision analysis for production management. In this paper, a grid company conducted a needs analysis production management for the overall data warehouse design to develop ETL technology solutions for the data stored from source systems to a data warehouse, and finally make use of the display tools to query and analyze data so that achieve decision-making support, for production management decisions to provide a reliable basis, and also verify the data warehouse design.