Many friends have sent me private messages asking me to provide an evaluation of domestic BI tools. Today, we will start the first phase:Sail Soft VS View FarStill put the evaluation elements first:(1) ToolsMost of the objects targeted by BI are still business personnel and professional data analysts, soIs the tool easy to useIs the interactive experience silky and smoothas well asDo you have sufficient learning resourcesLargely determines the useras well as

Many friends have sent me private messages asking me to provide an evaluation of domestic BI tools. Today, we will start the first phase:Sail Soft VS View Far

Still put the evaluation elements first:

(1) Tools

Most of the objects targeted by BI are still business personnel and professional data analysts, soIs the tool easy to useIs the interactive experience silky and smoothas well asDo you have sufficient learning resourcesLargely determines the useras well as.BI.Fine BIBI.

The functions of Guanyuan are all achieved throughPage presented layer by layerSo looking at the structure of each page individually is very simple, even beginners who have never been exposed to BI tools can follow the prompts for data analysis and chart making.

The FineBI operation interface has a relatively large amount of information, and the functions are all tiled on a single pageDistinguish between lines and surfacesIt is difficult to quickly analyze data when the screen is small and there is a large amount of data. But it is also because the display of functional information is relatively rich and the hierarchy is relatively small, which makes it particularly efficient to analyze real scenarios.

For example:

I need to analyze the sales data of store A this month, so my first step is to find these data.

In Guanyuan BI, I only need to click three times and the page will gradually find the store data table, which is the ease of use of Guanyuan BI. But pay attention to the premise of this operation: I know the complete name of the table and also specify which fields are in the table.

In FineBI, I directly search or enter keywords in the search box to find the corresponding table and data. When I find that this table is not what I want, I can directly select another one to view until I find the data I want. This is why the FineBI operation interface is rich in information.

In reality, there are more scenarios like the following. I only know the general keywords, but I don't know which table it is. Therefore, I need to open several tables one by one to determine which table the data I need to use is in.

In terms of ease of use and interactive experience, when watching product demonstrations, one may feel that Guanyuan is better. However, in the actual business use process, one may find that the interaction of FineBI on Fansoft is more suitable for exploratory analysis.

In fact, for most people, the habit of data analysis comes from Excel. FineBI continues the report tool FineReport of Fansoft, and uses an Excel like operation interface. However, there are not many smart ETL operators in Guanyuan, which seem very simple. In the actual process of processing data, a lot of operations can be required, but it is still difficult to use in business practice.

Both Fanruan and Guanyuan have text and video tutorials on their official websites, and their learning materials are on par.

In terms of product architecture,Guanyuan encapsulates Clickhouse, while Fansoft adopts StarRocks big data solution. In a "high concurrency" scenario, a clickhouse query occupies half of the server's CPU, and starpots can be pre aggregated. Billions of data tables can be first aggregated into millions of tables, improving concurrency efficiency. Generally speaking, ClickHouse is suitable for scenarios with less dimensional changes in widescreen tables. StarRocks not only performs better in single table testing, but also has greater advantages in scenarios with multiple table associations.

For specific selection, please refer to this article 'ClickHousevsStarRocks Selection Comparison'.

When it comes to data processing, it is best to divide performance into two parts:Below 10 million level and above 10 million level(Big data volume generally refers to over one billion levels).

Datasets with less than 10 million rows of dataBoth the Spider engine used by Fansoft and the Spark engine used by Guanyuan can provide a good response experience.

But in scenarios with large amounts of dataDon't listen to manufacturers boasting. The domestic and foreign BI manufacturers I know of are unable to provide good support and are no longer suitable for using extraction mode for analysis. In this case, either optimize the underlying data yourself and build a big data platform; Alternatively, check if the manufacturer has a corresponding solution.

I understand that Fansoft has a big data volume solution, which is probably selecting a high-performance database for adaptation and optimization, in order to achieve support for billion level big data. I haven't learned about the specific implementation effect yet. Friends who have learned about it can share it in the comments section.

BI tools have many functions, and different tools have different focuses. Therefore, while ensuring ease of use and performance, it is still important to look at the compatibility between functions and enterprise requirements.

• Data preparation

Both Fanruan and Guanyuan are supportiveFill in and connect to the databaseThese two forms of data connection. Guanyuan has a direct data reporting function in BI, while Fansoft data reporting requires the use of the reporting tool FineReport. The latter has strong reporting capabilities, but product integration needs to be examined.

Moreover, when it comes to connecting to databases, both have relatively simple access difficulties, but there are some differences in the types of databases supported.

.Fine BI.

The steps for accessing Guanyuan and Fansoft are consistent and relatively simple. Guanyuan basically supports common databases on the market, and if there are no special needs, they are sufficient.

• data processing

In the ETL process, Fansoft continues to use the family bucket mode as usual,There is a specialized tool called FineDataLinkdata processingITjsonSQLdata processing.data processingIT.

Guanyuan isdata processingSmart ETLdata processing.ETLdata processing.

• Data analysis and visualization

OLAP.

At the level of advanced data analysisFine BI6.0DEF.DEFTableau LODDAX CALCULATE.

In terms of visualizationFine BIPower BITableauDesign a visualization module based on graphical syntax.

In addition, FineBI can create visual dashboards, but it does not have the ability to visualize large screens (usually implemented using FineReport) or complex report functions (usually implemented using FineReport). So, in general, companies purchase sail soft products in the form of FR+BI.

BIIn terms of visualizationGraph before problemThe idea is to first determine the required chart type before presenting it. However, the flexibility in style switching is slightly weak, and they have also invested in the number of fixed charts, with over 50 fixed chart types available.

In addition, Guanyuan's BI comprehensively integrates the visualization of large screens and reporting functions, only dividing them into functional modules without distinguishing between software. It does a good job in terms of integration.

• Platform control

Permission control is a common concern in procurement. I have compiled the relevant permission control functions here, and you can take a closer look when comparing them.Here are two issues that I have noticed,The permissions of Fansoft do not support direct template reuse, but rather reuse permissions through linkage between tables, which is somewhat different from our usual usage habits. However, Guanyuan's line permission control requires the use of SQL, and the more hierarchical the SQL, the more complex the company structure becomes.

ACABCsql.

(2) Manufacturer

26000FineReportFine BI6.0..

Guanyuan is considered a rising star in the BI industry, following the path of financing and listing, mainly focusing on the retail industry. In recent years, the market expansion of Guanyuan has been quite fierce, and the solution side is mainly focused on some experienced businesses in the industry. The marketing side has also proposed the concept of "AI+BI", and there has been little movement on the product side.

From my perspective, when selecting a company, we also need to consider whether it can be implemented. Previously, I was invited to participate in the "AI+BI" internal testing activity, and the error rate is still relatively high. However, I am optimistic about "AI+BI" and hope that domestic BI can generate a voice internationally.

(3) Market

In the report "2021 Analysis and BI Platform Magic Quadrant" released by Gartner,PowerBl and TableauBoth are located in the leader quadrant. The leader in the domestic market has consistently topped the IDC China BI market tracking report for many yearsSail software.

Free tools for personal use

Summary

.BI BI .

BI.

Disclaimer: The content of this article is sourced from the internet. The copyright of the text, images, and other materials belongs to the original author. The platform reprints the materials for the purpose of conveying more information. The content of the article is for reference and learning only, and should not be used for commercial purposes. If it infringes on your legitimate rights and interests, please contact us promptly and we will handle it as soon as possible! We respect copyright and are committed to protecting it. Thank you for sharing.(Email:[email protected])