Big data visualization BI tool, hematemesis summary, Tongyoudongweiwei

2019/09/2609:45:14 technology 700

 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"!

Big data visualization BI tool, hematemesis summary, Tongyoudongweiwei - DayDayNews

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.

Big data visualization BI tool, hematemesis summary, Tongyoudongweiwei - DayDayNews


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

Big data visualization BI tool, hematemesis summary, Tongyoudongweiwei - DayDayNews


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

Big data visualization BI tool, hematemesis summary, Tongyoudongweiwei - DayDayNews


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

Big data visualization BI tool, hematemesis summary, Tongyoudongweiwei - DayDayNews


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

Big data visualization BI tool, hematemesis summary, Tongyoudongweiwei - DayDayNews


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

Big data visualization BI tool, hematemesis summary, Tongyoudongweiwei - DayDayNews


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.

Big data visualization BI tool, hematemesis summary, Tongyoudongweiwei - DayDayNews

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

Big data visualization BI tool, hematemesis summary, Tongyoudongweiwei - DayDayNews

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)

Big data visualization BI tool, hematemesis summary, Tongyoudongweiwei - DayDayNews

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)

Big data visualization BI tool, hematemesis summary, Tongyoudongweiwei - DayDayNews

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.

Big data visualization BI tool, hematemesis summary, Tongyoudongweiwei - DayDayNews

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.

Big data visualization BI tool, hematemesis summary, Tongyoudongweiwei - DayDayNews

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

technology Category Latest News