Pharmaceutical Enterprises Sales Management Decision Support Systems Research And Application

This thesis is the research consequence of Jilin DuoBang Drugs Corporation Marketing Management System development project. The project is aimed at discovering useful information from the database of daily transactions. Solution to the problem is to set up a data warehouse and make full use of its function of supporting decision making. This project is based on the theories of Data Warehouse , Decision Support System and Data Mining. And after six months of work, the development of Drugs Sale Enterprise Marketing Management Decision Support System was finished. To base the system on facts, we transmitted all the sale records from 2000 year to 2003 year into the data warehouse. As shown by the results, this system can answer such questions as commerce,market exploitation and analysis of investment and profit, which can be classified as half structured questions. Solutions of these questions are certainly helpful for making investment decisions or drawing up sale strategy. The accomplishment of this system proves that data warehouse meets the need of enterprises at supporting decision making, and that DW is most helpful for enterprises in exploiting market, contesting consumers and making full use of resources.