2, BI as a solution should be more appropriate. The key to business intelligence is to extract useful data from many different enterprise operating systems and clean up the data to ensure the correctness of the data, and then after extraction (Extraction), transformation (Transformation) and loading (Load), that is, the ETL process, merged into an enterprise-level data warehouse, so as to get the enterprise data a Global view, on the basis of the use of appropriate query and analysis tools, data mining tools, OLAP tools, etc. to analyze and process (when the information becomes knowledge to assist in decision-making), and finally the knowledge will be presented to the manager, to provide support for the manager's decision-making process.
3, the advantages of enterprise BI
1) random query dynamic reports
2) anytime, anywhere grasp of the indicators of management
3) anytime on-line analysis and processing
4) ultimately use the data to assist in the operational planning
4, the purpose of the enterprise BI
1) to promote the decision-making process: to enhance the integration of information and information analysis. Enterprise information integration and information analysis capabilities, summarize the company's internal and external information, integrated into effective decision-making information, so that business managers to significantly enhance decision-making efficiency and improve the quality of decision-making.
2) Reduce overall operating costs: Improve access to information and significantly reduce the time and labor costs for IT staff to write programs and produce reports for Power Users. The flexible module design interface, which eliminates the need to write programs, also significantly reduces maintenance costs in the future.
3) Collaborate with organizational goals and actions: Strengthen the information dissemination capability of the enterprise, eliminate the cognitive gap between the information demanders and the IT staff, and enable more people to obtain more meaningful information. Comprehensively improve the enterprise's physical, so that everyone in the organization has the same goal, work together.
5, the main functions of business intelligence
Business Intelligence technology system is mainly a data warehouse (Data Warehouse, DW), on-line analytical processing (OLAP) and data mining (Data Mining, DM) three parts.
The main functions that a BI system should have:
1) Data Warehouse: an efficient way to store and access data. Provide structured and unstructured data storage, large capacity, stable operation, low maintenance costs, support for metadata management, support for a variety of structures, such as centralized data warehouse, distributed data warehouse. The storage medium can support near-linear and secondary memory. Can well support the current stage of disaster recovery and backup program.
2) Data ETL: Data ETL supports multi-platform, multi-data storage format (multi-data sources, multi-format data files, multi-dimensional databases, etc.) data organization, requires the ability to automate the data lookup and understanding based on the description or rules. Reduce the gap between massive, complex data and global decision-making data. Help form reference content that supports decision-making requirements.
3) Data Statistics Output (Reporting): Reporting can quickly complete the design and presentation of data statistics, including statistical data table style and statistical charts show that can be exported to other applications or Html form of performance and preservation. For the customized design part to provide simple and easy to use design solutions to support flexible data filling and design solutions for non-technical staff. Can be automated to complete the output content of the publication.
4) analysis function: can be formed through the business rules analysis content, and display style rich, with certain interactive requirements, such as early warning or trend analysis. To support multi-dimensional online online analysis (OLAP analysis), to achieve dimensional changes, rotation, data slicing and data drilling. To help decision making to make the right judgment.
6. Typical business intelligence systems are:
Customer analysis system, food basket analysis system, anti-money laundering system, anti-fraud system, customer contact analysis system, market segmentation system, credit scoring system, product revenue system, inventory operation system, and business risk-related application systems.
7, Business Intelligence Solution Vendors
Famous foreign IT vendors include Microsoft, IBM, Oracle, Microstrategy, Business Objects, Cognos, SAS, etc., and famous domestic BI vendors include BDP Business Data Platform, Yonghong BI and so on.