Analysis of the current situation of the hottest B

Analysis of the current situation of business intelligence (BI) industry

nowadays, business competition is becoming increasingly fierce. How to correctly and timely make business decisions on the rapidly changing market conditions and business operations is an important issue for all company management. More and more enterprise managers realize that fully mining the existing business data and analyzing the rules can provide a good basis for business decision-making. With the informatization of enterprises, the business data generated by different business systems are also increasingly large, reaching the GB level. How to find useful business laws in such large and complex data, and how to integrate the market and business intelligence obtained from other aspects to make accurate market analysis, so as to provide a basis for business behavior decisions. Such demand has long been concerned by domestic and foreign software manufacturers

business intelligence (BI) technology uses data warehouse to build the basis for summarizing data, and then supports today's cutting-edge technologies such as data mining and multidimensional data analysis, as well as traditional query and report functions

at present, most of the existing Bi manufacturers rely on some traditional ERP, BPM, CRM or ETL reports, which focus on one aspect, and the product implementation is complex and expensive. And most of the mature products are foreign enterprises, which are not suitable for users with special requirements related to national security, confidentiality, government agencies, etc., nor for the management mode of domestic enterprises. This provides development space for domestic Bi manufacturers. Tsinghua Tongfang ezbi product is the first software system in China that provides comprehensive solutions in the field of Bi (Business Intelligence) and its own intellectual property rights. It provides a series of products from data collection, comprehensive analysis and utilization to systematic maintenance and management. The core goal of ezbi is "data integration and decision support". Data collection is the front-end work, data storage is the central link, data analysis and utilization is the key, and data maintenance and management is the assistance and expansion of applications. Tsinghua Tongfang ezbi products have been successfully applied in Xinjiang Social Security Project, Jilin provincial population and Family Planning Commission, Changchun high tech Industrial Development Zone, Radio Commission, Shandong Dezhou commercial bank and other industries

ezbi introduction

ezbi products are divided into three layers in structure. The first layer is the data acquisition integration layer, the second layer is the data storage management layer, and the third layer is the application presentation layer

data collection integration layer: it is a process to solve data collection and sort out historical heterogeneous data, and centralize scattered data. Ezbi adopts ezetl data conversion system to integrate heterogeneous data and load it to the target data source (data warehouse or database) through extraction, cleaning, conversion and loading. If there is no historical data and it needs to be collected temporarily, ezreport remote report system is used to collect the data into the report system in the way of level by level reporting, and then uniformly import it into the database. Then ezetl data conversion system will extract, clean and convert the data, and finally load it into the data warehouse or data mart of the data storage management layer

data storage management layer: it is the layer to solve the correlation between data and data, data and business, and the problem of secure storage. Through this layer, a logical mapping relationship will be established between data and business, laying the foundation for the presentation of the application layer. The historical data is uniformly loaded into the data warehouse or data mart of the data storage management layer by the ezetl data conversion system of the data collection integration layer, and the ezdatamanager data resource maintenance system updates and maintains the data in the data warehouse and builds a multidimensional business model (cube)

application presentation layer: it is the data presentation for end users and the level that end users can directly apply. In terms of application display, ezbi provides two products, namely ezolap online analytical processing system and ezreport report report and data query module. Ezolap online analytical processing system is a technology of three-dimensional analysis of multidimensional data stored in data warehouse or data mart. It presents complex data in intuitive forms such as tables and analysis charts according to business indicators. It is suitable for units with large amount of data and integrating analysis into daily work. Ezolap and ezanalytical data analysis model base can make the analysis function more powerful and easy to expand. Ezreport report report and data query module is a data acquisition and presentation method that can be built quickly. It can directly query the calculation formula of database and data warehouse (unit is%) and generate reports. It is suitable for occasions with relatively small amount of data. The ezportal of Tsinghua Tongfang Ezone platform can be used. The reasons for this are: the air in the hydraulic system of the zigzag experimental machine is not eliminated, the force measuring piston rod is zigzag or not in the correct position, and the friction force of the force transmission system is uneven. The portal products are integrated

scope of application

ezbi products adopt low coupling design for each module, which can be used alone or cooperate with each other to form a complete solution

ezanalytical data analysis model base: This product is provided to users who have further needs for data analysis and decision support for data in-depth analysis. The common characteristics of these users are that they have a high degree of informatization, have accumulated a large amount of valuable historical business data in daily business, and have a strong requirement for decision support based on historical data analysis

typical enterprise users include telecommunications electronic rupture strength testing machine, banks, securities, retail, logistics and other enterprises with large amount of data and specific evaluation business; Typical government users include statistics, taxation, social security, Planning Commission, economic and Trade Commission and other government departments. In addition, specialized service institutions such as accountants and auditors are also more suitable users

ezolap online analytical processing system: it can carry out unified and comprehensive analysis of users' scattered business data, and meet users' different needs for the same data analysis angle at the same time. The application scope of the system is very wide, ranging from multi-level business comprehensive analysis of group enterprises and institutions, government agencies, to multi angle analysis of indicators for a certain field, and so on

typical users of government institutions include statistics, taxation, industry and commerce, price, social security, economic and Trade Commission, Planning Commission, etc; Typical enterprises and institutions have units with large data volume, such as telecommunications, postal services, banking, securities, logistics, commerce, etc

ezetl data conversion system: its main function is to carry out selective batch collection, conversion and loading services for existing data. It is suitable for data integration such as batch collection, migration, conversion and update of database, establishment and maintenance of data warehouse, data quality management, etc

typical government users include statistics, taxation, industry and commerce, etc. These government departments have a large amount of business data, and have urgent requirements for data concentration, data conversion, data quality management, etc. Typical users of enterprises and institutions include large-scale group enterprises and institutions with many banks, telecommunications, securities and branches. (end)