Workers must first sharpen their tools if they want to do their jobs well.
In the era of big data, business intelligence (BI) and data visualization are more demanding, and Taobao big screens are even more popular around the world! Data visualization is the "last mile" of big data, BI wakes up sleeping data.
BI wakes up sleeping data
Traditional BI strives for a large and complete unified comprehensive report and analysis platform, focusing on the development of traditional reports, just like a dragon knife. The rapid iterative business development of Internet companies now needs to rely on Tianjian to promote the rapid development of self-service BI and agile BI.
Times call, traditional BI giants are gradually transforming to self-service BI and cloud BI. For a time, data visualization and BI showed a grand occasion of "a hundred schools of thought contend, a hundred flowers bloom"!
Visual BI tool classification
01 Open source BI tool
Superset
Airbnb open source data visualization tool.
currently belongs to the Apache incubator project and has a good combination with kylin.
Python development, the version iteration progress is very fast.
may be the most attractive open source BI tool.
The chart cannot be copied quickly, so you have to go through the SQL level again.
Authority management, the official provides a complicated authority control, but it is not easy to use.
github: https://github.com/apache/incubator-superset
start: 25k+
The number of stars in Superset has far exceeded other visualization tools.
Redash
The open source BI tool provides Web-based database query and data visualization functions.
Redash allows quick and easy access to billions of records.
Support simple alarm rules
Dashboard can be shared
The aesthetics is not beautiful enough compared to Superset
Supported chart types are limited
github: https://github. com/getredash/redash
star: 13k+
supports ClickHouse
metabase
The UI is relatively beautiful The designer carefully adjusted it. In contrast, Superset and Redash are the products of programmers acting as designers.
Metabase attaches great importance to the experience of non-technical personnel (such as product managers, market operations personnel) when using this tool
github: https://github.com/metabase/metabase
star: 16k+
currently does not support ClickHouse
CBoard
A visualization tool developed by Chinese people.
The interaction design is good, drag and drop mode, support mail
Java系
github: https://github.com/yzhang921/CBoard
star: 2k+
Although the star is not high, it is widely used in the second and third-tier companies in the market and the second-tier companies Development version.
Chinese document:
https://peter_zhang921.gitee.io/cboard_docsify//zh-cn/manual/widget
Davinci
Da Vinci open source BI software developed by the big data visualization platform of Yixin Technology R&D Center.
For business personnel/data engineers/data analysts/data scientists, we are committed to providing one-stop data visualization solutions.
The function is relatively comprehensive, but it has not been widely used in China. It is worth looking forward to.
Java系
github: https://github.com/edp963/davinci
star: 800+
Davinci: https://edp963.github.io/davinci/
user manual provides online viewing and PDF download
SpagoBI
Professional open source suite suitable for modern business of traditional sources and big data systems analysis.
Java系
was a fully open source SpagoBI before version 6. Starting with version 6.0 released in 2018, it was renamed Knowage and moved to the open source community version and the paid enterprise version.
SpagoBI has been merged into Knowage!
star: 100+
github: https://github.com/topics/spagobi
Pentaho
Pentaho is a very complete BI solution.
Pentaho prefers BI solutions integrated with business processes.
Pentaho is a BI suite that focuses on workflow and emphasizes solution-oriented rather than tool components. It has business intelligence (BI) components and integrates multiple open source projects so that the company can develop a complete business intelligence problem The solution, the goal is to compete with commercial BI.
github: https://github.com/pentaho
star: 100+
The classic ETL tool kettle is Pentaho's.
02 Commercial BI tools
FineBI
is a domestic BI tool, made by FanRuan. FineBI has mobile terminals, PAD terminals, and large screens. Self-service BI.
The first-class BI tool made in China is very cool and practical.
FineBI is a set of enterprise data management and visualization BI solutions, which integrates Alluxio, Spark, HDFS, zookeerer, etc.Big data components, the engine supports the front-end to quickly display and analyze, and truly realize billions of data in seconds.
The overall package price of general enterprise products is hundreds of thousands.
QlikView
is a solution that treats users as data recipients.
QlikView is more flexible and has various display styles. It allows to set and adjust every small aspect of each object, and customize the appearance of visualization and dashboards.
can automatically associate data: identify the relationship between various data items in the collection, without manual modeling.
In-memory BI tools, the data processing speed largely depends on the memory size. Qlikview processes data input by storing it in the memory of multiple users.
Pricing: Limited edition is free; Qlik Sense Cloud Business’s collaboration function is $15 per user per month
Tableau
Visual BI artifact Tableau .
Medium-sized enterprises and large enterprises, but the Internet emphasizes that it is open source and free, and it is used less.
Functionally, Tableau and Qlikview have a very high degree of overlap. However, Tableau is more beautiful in visualization and easier to analyze than qlikview.
Especially like Tableau, the ETL function is not integrated, and there must be a very good data warehouse as the basis.
Pricing: Each deployment requires at least one Tableau Creator (US$70 per month); you can choose Observer (US$12 per month, minimum US$100) or Explorer (US$35 per month, minimum US$5)
Active community (various training videos, blogs, forums, social networks)
Power BI
Microsoft series for business intelligence and analysis demand.
It is tightly integrated with Microsoft's main tools (including MS Excel, Azure Cloud Service and SQL Server).
Pricing: Three tiers: Author Edition (free), Professional Edition ($9.99 per user per month), Premium Edition (depending on performance)
SmartBI
is biased towards traditional BI, which requires a certain degree of technology in operation and use, and the user's learning cost is higher.
QuickBI
Alibaba Cloud product
is a lightweight self-service BI tool dedicated to the efficient analysis and presentation of big data based on cloud computing Service Platform. Through the connection of the data source and the creation of the data set, the data is analyzed and inquired ad hoc;
uses the spreadsheet or dashboard function to visualize the data in a drag-and-drop manner.
03 Traditional heavy BI tools
Old traditional heavy BI tools, classic history represents Oracle’s BIEE, IBM’s Cognos, SAP’s BO and MicroStrategy, etc. The times call, traditional BI giants are gradually transforming to self-service BI and cloud BI, and they also hope to retreat from the rapids of the data age to bring forth the new and create new glory!
AddWei iom1128 pulls you into the data warehouse BI technical exchange group