Abstract:The financial system of transformation for agricultural science and technology, a transaction process- ing-based system, cannot analyze data fast and effectively. In order to effectively use the large amounts of accumulated data, analyze the effect of the funds for the commercialization of agricultural science and technology achievements, and decide the rational allocation of funds in the future, an analytic system of agricultural achievement transformation funds is designed using data warehouse. System is designed and implements the conversion of the E-R Model to Star Schema, and the data warehouse of agriculture science and technology achievements transfer capital project was created on this basis. Based on B/S, the information centralization of management of agricultural scientific and technological achievements transfer capital project can be effectively achieved, and comprehensive query, statistical analysis of demand changeable project information, and project performance can be carried out to meet the needs of the constant development and change of agricultural scientific and technological achievements capital management project decision making performance.