Operation Analysis Of Small And Medium-sized Financial Institutions Based On Data Warehouse Technology

This study analyzes the financial services industry in the fierce competition among small and medium financial institutions to improve their business intelligence systems, and ultimately improve competitiveness.With the development of financial institutions and commercial banks in the supply and demand change from a seller’s to a buyer’s market, the concentration of banking business also order from product-oriented to customer-oriented changes, banks also need to have promotions and classification sense of service. Customers are commercial banks, the most important resource, therefore, the key is to develop a customer-centric strategy and build a loyal customer relationships. Through a thorough understanding of customer needs and ideas, making customized products and services can be delivered. Customer Relationship Management (CRM) is based on the special needs of the modern service industry development of a management philosophy.This research organizations, environmental and project planning point of view, such as different data warehouse technology in small and medium financial institutions successfully. Internally there are three main factors, namely, top management support, decision-making and organizational size. In the external factors, economic conditions and competitor strategies largely affect the bank’s behavior and decision-making using data warehouse technology. From the perspective of project planning, experienced data warehouse engineers play an important role in the meantime. In addition, small and medium financial institutions of cooperation is another key factor.Thus, information from the bank information over to the bank, and from information technology to intelligent bank into banks, in this wave of change, the data has played a huge role, and for the integration of data management data warehouse is also came into being.A data warehouse is an intelligent organized, it changes over time while the integrated non-volatile and subject-oriented collections. Generally, the transactional (OLTP) systems to the data warehouse (analytical (OLAP) systems) to provide the source data, the data stored in the data warehouse design and management accordingly.Medium and small financial institution-building data warehouses goal is to provide different perspectives of the data for different users with convenient and accurate angle data. According to business development, the need for decision analysis, data collection needs. Through tools to optimize production complex indicator-based reports provide customized and flexible queries, custom indicators to monitor and display platform for mobile terminals. Continuously improve the user experience, the much-needed and slower data queries and reports issued and optimize your system. Data warehouse platform consists of infrastructure, logical data, data processing, management control four components, introduces the related software, from a technical framework, the physical topology, tools to be explained by pre-planning, needs analysis, program design, development and testing, on-line maintenance process, demonstrated complete data warehouse applications in small and medium financial institutions.The building is divided into the data warehouse data import and data construction in two phases. In the data import stage, through data extraction, data conversion, data loading and other three processes to complete the initial stage of establishing a data warehouse for data management and application after the order to lay a good foundation.In the data storage, the need to design a good storage means in order to achieve data to better applied. Data storage many ways, a better approach is to use the paradigm model to store data warehouse, and the paradigm by calling the view engine model is converted to a dimensional model to show to the user.Data warehouse development on China’s banks has practical significance, especially in small and medium financial institutions will take some time to build a data warehouse, and in the process of training high-level technical personnel. More important is the ability to change the rules of the construction of information technology is not enough unity rigorous project development to focus more on the business operating system, but to invest in the management information system less the status quo, to further improve the level of information technology has become the development of small and medium financial institutions to grasp important means opportunity.