Foreign BI: SAS BI, IBM cognos, Oracle Bone Inscriptions BIEE, SAP BO, Power-BI, Informatica, Arcplan, QlikView, Tableau, etc.
Domestic BI: BDP Business Data Platform, smartbi, UFIDA Watch, Fansoft, Run Qian Report, Yonghong Technology, etc.
Foreign BI
1、IBM Cognos
IBM provides comprehensive business intelligence solutions, including front-end tools, online analytical processing tools, data mining tools, enterprise data warehouses, data warehouse managers and data preprocessing tools. Combined with the business needs of industry users, IBM also provides users with business intelligence solutions in government, electric power, finance, telecommunications, petroleum, medical and other industries. The IBM Cognos business intelligence solution is built on a mature technology platform, aiming at seamless upgrade and economical and effective expansion, so as to achieve the widest deployment and meet the different information needs of various types of users. The most widely used traditional BI tools have been acquired by IBM. Has a strong database platform, and has deep professional knowledge in the fields of data management, data integration and middleware. Part of the operation, manual modeling, once the demand changes, it needs to be re-modeled, and the learning requirements are higher.
(Information from Baidu Encyclopedia)
2. Clear BIEE
BiEE is the most powerful BI analysis tool of oracle. It was the first to enter China, supported simple and convenient clustering, and had powerful front-end and middle-back end design functions. The front-end development is flexible and easy to use. As long as the development company invests enough powerful technicians, the project duration planning is reasonable, which can basically meet all the requirements from the upper level to the middle and lower level, and the interface is beautiful. However, the disadvantage is that doing some Chinese-style reports requires a lot of work, and there are still some shortcomings. However, with the continuous development and upgrade of oracle, the products are also changing. Another aspect is to find a truly responsible company and implementation team to implement the recommendations. It all depends on the technical ability of the implementation team.
3. SAP business objects
A BI tool acquired by SAP BO Company, whose product operation mode is combined with SAP's ERP system, so integrating other databases or systems is not dominant, and it is a heavy BI with high usage requirements and difficult upgrade. There is nothing wrong with reactive power, which has no characteristics in BI products. Like SAP, it is closely connected with Oracle Bone Inscriptions's product line. It seems that foreign manufacturers are bundling the whole solution.
4、Qlikview
The main feature of Qlikview is that it is simple to develop and use, but compared with Tableau and FineBI, its running performance is poor. Generally speaking, it can make self-help data analysis and all information have a flexible and intuitive display. When Qlikview provides flexible and powerful analysis functions through AQL architecture, AQL architecture changes the demand for OLAP cubes. The defects of Qlikview are also obvious. Limited by the number of users (that is, the price) and the complexity of designing reports, QlikView can only be used by a few managers, but the report problem of middle-level cadres has not been solved.
5, the picture
Positioning is a data visualization tool with powerful visualization function, high requirements for computer hardware and complex deployment. At present, the mobile terminal only supports the IOS system. The operation is simple, and users only need to simply configure and drag to analyze the data. Generally speaking, the tools are quite good, with low cost and quick use. The function is quite powerful, the visualization effect is really good, and it also has the function effect of data drilling and dynamic. Although Tableau has strong analysis function, it has weak data capture function and poor data processing ability, so it needs to be prepared and can be considered as a front-end tool for data analysts. In addition, Tabluea is really not cheap, the cheapest is 999 yuan a year.
Domestic BI
1, BDP business data platform
BDP business data platform aims to help enterprises quickly complete multi-data integration, establish a unified data caliber, support self-service data preparation (ETL), provide flexible, easy-to-use and efficient visual exploratory analysis capabilities, help enterprises build enterprise insights suitable for their own businesses, and quickly cover employees at all levels and application scenarios with data decisions.
BDP can flexibly access and synchronize various data sources, including various database connections, OpenAPI and SaaS platform API, which can meet various business scenarios and 1 100 million lines of data response of enterprises, realize data cleaning, integration and loading quickly, and make visual analysis by dragging and dropping. Support nearly 30 chart types and 12 self-contained color schemes, and the data is more intuitive and beautiful.
The core value of BDP business data platform for enterprises is to display and analyze data in an intuitive, multi-dimensional and real-time manner, and view and share data in APP in real time, fully activate the internal data of enterprises, drive performance with data, and adapt to the rapidly changing market. Haizhi helps all kinds of enterprises to quickly build a data analysis platform suitable for business. At present, the clients we serve cover Internet, fast-moving retail, logistics, O2O, medical/educational SEM and other industries.
(Information from BDP official website)
2、FineBI
FineBI was launched by windsurfing company a few years ago, which has a good reputation and development in China. Through the fool-like operation, users can simply drag and drop in the dashboard to create various data visualization information, perform data drilling, linkage, filtering and other operations, and analyze data freely. FineBI is oriented to enterprise IT departments and business personnel, providing self-service data analysis for business personnel under enterprise-level control, helping IT to do data control downwards, making full use of bottom data upwards, and supporting front-end business data applications. The data analysis function is comprehensive and practical, but it is quite satisfactory and there are not so many bright spots. Sailsoft's self-help BI products and lightweight BI tools are easy to deploy and take the direction of multi-dimensional analysis. Later, it was upgraded with jar package, which was convenient to maintain and cost-effective.
3. Bi Yonghong
Agile BI software, high product stability. Using sql to process data does not support the program interface, so it can be outsourced to a third party. Yonghong's technology is mainly divided into big data and visualization. In terms of big data, through the technologies of column storage, distributed computing, memory computing and distributed communication, Yonghong has independently developed a high-performance big data computing engine, which can be used as a data mart for analysis and can realize tens of billions of data calculations in seconds. In the aspect of visualization, Yonghong hides the complex multidimensional analysis function behind his back, and realizes various complex analysis processes by simply clicking and dragging the visualization operation at the front end.
With the popularization of big data and data analysis technology in recent years, Tableau and Qlikview, including the domestic BDP business data platform, are gradually recognized by enterprises for their advantages of simplicity, high popularity and low usage threshold.
I know BI products very well. I hope I can help you ~ ~ ~