I have been engaged in BI projects for several years, so I have some understanding of statements.
Many people have doubts about the tool selection. There is a difference between statements and BI. It is better to choose domestic tools with the products of foreign giant manufacturers.
Without any nonsense, I would like to share my experience in the report selection of a party A, because PPT cannot be shared, so THE essence of which is extracted to share.
Project origin
Party A belongs to the consumer industry. In the past two years, party A has been engaged in new retail, digital retail and online and offline integration through financing. The industry has been expanding rapidly and at a fast speed, with fierce competition of the same kind and strong demand for data analysis.
In the past, information was used as part of SAP’s solution, including reporting. However, the informatization focus of the group in the past two years is data. It is necessary to break through the data layer and make some innovative data applications centering on the new retail scenarios. The current front-end data applications are mainly report tools, which cannot meet the functional requirements.
** Data collection. ** Currently there are many tasks and objectives, which require data entry. The data entry function of the current report is weak and cannot be integrated.
** Mobile data application requirements. ** More than 20 stores need to report data every day, especially real-time access to fresh inventory data. In addition, item scan code data, membership scan code purchase, and small program online purchase data also need to be opened.
** Report development efficiency. ** The development efficiency of mobile terminal is low, many systems can not be integrated, the basic need for code development, and the mobile terminal report tool is inflexible, can not support drilling, linkage and other routine operations, so it cannot support the more intuitive CEO Kanban.
** is weak in analysis. ** The current report is more based on the presentation of past data, and the presentation is not enough, let alone the analysis
The data security function is weak. The report cannot encrypt exported files, and the mobile terminal does not have the watermark function.
To sum up, it is urgent to change reporting tools.
Selection of contrast
Based on the above requirements, these indicators are mainly investigated in the selection of report items:
Tools: Data modeling capabilities, data analysis capabilities, mobile capabilities, visualization support, flexibility
Manufacturer: cost performance, market share, market positioning, service capacity
Finally, 6 categories of products were selected for evaluation, and 3 of them were selected for POC comparison.
Comparative thinking: maturity, value benefit
Beyond product functionality, consider product maturity, solution capabilities, and value benefits
Product maturity
Product maturity is the choice of IT products need to be considered, foreign products are mature but backward update, domestic product maturity to try.
Domestic reporting tools VS foreign reporting tools
Domestic reporting tools can be upgraded quickly, can support customized development, and support personalized reporting requirements, operation and maintenance response speed, cheap, but some tools are not perfect.
Foreign report tools have more powerful and stable functions, but they cannot effectively meet the needs of domestic personalized reports, and are slow to be upgraded, unable to be customized, slow to respond to problems, and expensive (charging according to users).
Traditional reporting tools vs. Agile reporting tools
Traditional report tools are powerful and stable on the PC, but cost a lot to learn and bind with other products, resulting in high maintenance cost and difficulty in upgrading.
Agile report tools are easy to use, high degree of visualization, low threshold of use, easy to upgrade, but most of the Chinese complex report functions are slightly weak.
The value of benefits
Based on the above analysis, the FineReport solutions in 6 categories of products are investigated.
Decision analysis
FineReport supports cockpit setup for decision analysis.
To explore the analysis
FineReport supports graphical analysis, making it easy for data analysts to explore and analyze stores.
The current app used by the company is not easy to use, install and upgrade. The new tool can be integrated into the wechat of the enterprise, saving the installation time of store employees. Meanwhile, linkage drilling can be carried out to speed up the use of associated analysis.
The average click on the current report is more than 10 seconds, and the average click is about 5 seconds after the tool is replaced. At present, the company clicks 20,000 times per day, saving 100,000 seconds, and saving 1.2 person days per day to speed up technology research and development.
It takes five days to develop a report on the current basis of mobile terminal report, one day to develop new tools, saving four days, and 120 man-days to save 30 reports, saving 50,000 YUAN of RESEARCH and development cost.
Technical POC comparison
In the last part of POC, we scored the top three companies, and the results are shown in the figure. Meanwhile, we discussed and communicated internally with big data, suggesting that manufacturers with higher test scores should be used.
