Financial Analysis And Decision Support System Design And Development

Along with market competition intensified, improve the company’s managementlevel and lower operating risk has become the mainly means of enterprisecomprehensive competitiveness. But in view of complicated of management systemand organization, it makes quickly geting the vast useful decision information andenhancing management benefit became very difficult. Especially financial datamultifarious diversity, it even brings managers huge barriers for formulating correctdecision. Therefore, China National Petroleum Company launch a project "financialanalysis of decision support system" serving modernized management of joint stockcompany. It will realize financial management network, informationization, integrationand modernization, and strengthen decision-making support and participation forfinancial department of management. It will objective truthfully reflect and evaluationcompany performance, and improve CNPC and its subordinate branches financialanalysis and decision.This paper adopts advanced analysis method and design idea, established asystematic data model. This system effective use of data warehouse technology, andusing dupont analysis method to find the root of the problem. Meanwhile, by providingcustom analysis indicators, it will meet different levels manager’s individualrequirements. And we design the system software structure under the whole datawarehouse structure, then apply ETL MOLAP, Data Mining etc, provides aninformation processing and knowledge transfer platform. During system realization, weestablished a unified data storage, processing and analysis platform. It realize the systemdata warehouse collection and data extraction, and can generate global statements fordecision-making need. By establishing WEB analysis and display platform, it willprovide theme analysis, statement analysis, structural analysis, forecast analysis andgraphics analysis, and other functions. In addition, on the whole this system ensure thereliability and safety by three measures,and also consummate the design andimplementation scalability and technology sustainability.The financial analysis and decision support system have budget management, cost analysis, investment evaluation, risk early warning, and other functions. And it canprovide friendly interface, complete data deeper processing and process. As supportingpart for the company production management decision support system, the practicalapplications of this system in the joint-stock company, liaohe oilfield and its subordinateblocks are very well. The results verify the rationality of the overall design, and eachmodel with scientific and practical. So the system can effectively service inprofessional company, provide accurate financial decisions for the oilfield productionand operation.