1, based on a direct connection to the business system out of the report tool (OLTP application)
Run dry report on behalf of vendors, and later sail soft FineReport.
The advantage of this type of reporting tool is the development of a more flexible, at the same time, including the data fill in and fill in the function; the shortcomings of the BI reporting tool is not based on the OLAP, which leads to do not support the report based on the Multi-dimensional reporting operations , such as drill-down tables based on the same dimension , you need to do more than one table , by way of linking to achieve ; at the same time , due to do the table before the sql statement to lock and load the analysis of the source data , you can not make full use of the performance of the database , so the computational performance of the large amount of data and high concurrency under the performance of the biggest weaknesses .
It is also because of these shortcomings of such reports, the new generation of Run Qian product set calculator positioned in the source database and the middle layer of the report, is committed to solving the database to the report of the calculation of the performance problem. Sailsoft launched FineBI, trying to solve the related problems through BI technology, but due to the accumulation of OLAP-based technology for a shorter period of time, the realization of its directly connected to the database until the beginning of this year was released, and to be further verified.
2, based on DW / BI theory of traditional BI tools
Foreign vendors: IBM's acquisition of Cognos, Oracle's BIEE and SAP's acquisition of BO
Domestic vendors: Yixin Huachen's Yixin ABI, SmartBI SmartBI
This type of analysis tools, a better solution to the multidimensional report operation problems as well as performance problems. However, foreign tools in the implementation of complex reports in the Chinese style is in a weak position, and at the same time, due to the BI tool bias application layer, the project inevitably some customization and secondary development needs, foreign companies in such issues basically can not respond. Because of the OLAP technology, the BI tool itself can not provide data modification and supplement the relevant functions, foreign tools in this scenario is stretched to the limit.
Yisin Huachen is one of the earliest BI vendors in China, with customers in government, banking, electric power, taxation, leasing, and other industries. It serves a large number of government and enterprise users such as the State Administration of Taxation (SAT), Export-Import Bank (EXIM Bank), the State Grid of China (State Grid), and the Haier Group, and its influence in the industry can be seen clearly. Yixin ABI was born from the stand-alone data analysis system released in 2003. From BI@Report, to Yixin BI, to Yixin ABI nowadays, Yixin ABI has gone through four architectural leaps, more than twenty major version updates, and more than ten years of technical precipitation, and its product functions and performance can basically be compared with those of similar foreign tools.
There is another typical representative of this kind of tool in China, Sematic (SmartBI). Sematic team of DW / BI has more practical experience, but for some historical reasons, the final development of the product into a designer based on Excel reporting tools and a business-oriented use of self-service analysis tools. Excel-based report designer, one can not realize the online design and **** enjoy, the second is not in line with the national requirements for certain areas of autonomous security and control of the development direction, at the same time, due to the benchmark FineReport, failed to solve the inherent shortcomings of reporting tools.
3, business-oriented Agile BI tools.
Foreign representative vendors: Tableau
Domestic representative vendors: SailSoft FineBI, Yixin Huachen Pea BI
With the development of technology and the market, there are a lot of companies have begun to research and development of Agile BI tools directly for business users. A representative of foreign countries is Tableau, Tableau at the beginning of the product positioning is to replace Excel, stand-alone users to complete a variety of rapid design and analysis of local operations, focusing on the emphasis on interaction with the data, as well as a variety of ways to analyze the operation of the interaction. This type of tool due to its positioning problems, in the production of a variety of complex statistical reports of the ability to natural deficiency.
There are many vendors doing agile BI in China, such as FineBI of Sailsoft and Pea BI of Yixin Huachen. the first version of FineBI relies heavily on FineReport technology, so its first version of BI is more likely to be positioned as a traditional BI tool, focusing on solving the ability to analyze multidimensional analysis, but from the market feedback, it can't be clearly differentiated with FineReport. FineReport's obvious distinction, so its subsequent versions of BI gradually tend to agile BI tools. But because of its experience in OLAP technology is very little, or the need to analyze the data packaged into a special package, and then BI tools based on a special package for analysis, the role of this special package is equivalent to the role of the sail of soft own data analysis model (similar to the role of OLAP databases or cube), you need to complete their own management and maintenance of the data analysis model. Until recently, it has only released the engine that can directly connect to the OLAP database, and the related ability needs further verification on the project.
Yixin Huachen in *** with the core OLAP engine technology to develop a separate business-oriented use of the pea BI, positioned as a simpler, more accessible self-service analytics BI, which uses a lot of intelligent technology to provide automation of the product, so that the user operation is easier, such as automatic modeling technology when the data table is imported, the data portrait function, multi-table auto-association technology, charting intelligent recommendation technology, and charting intelligent recommendation technology, as well as the operation of the user more easily.
4, based on Internet technology and resources, entrepreneurial BI
Representative vendors: AliCloud's QuickBI, NetEase, HaiZhi BDP, ShenZe Data, etc.
Since many people are optimistic about the BI market and application scenarios, some Internet companies developed BI products based on their own applications, such as AliCloud's QuickBI, and NetEase, etc. These companies have developed their own BI products. and NetEase has numbers, etc. These tools are lightweight tools, and their business status in the company belongs to the fringe business, so they do not get attention and development.
There are also some companies founded by startup teams from Internet companies, such as Hazardous BDP and God's Strategy, etc., whose products are focused on BI applications based on saas or certain types of business application scenarios. Therefore, the versatility of such BI tools needs more time to be verified.