Abstract: This paper introduces the origination of the DW ideology and its architecture and principles, as well as relative techniques. The structure of DW of comprehensive query system of factory manager is also discussed. The implementation methods of data collection and data visual appears are presented. Finally, this paper proposes the ways of building an effective decision support system.