The two concepts of BI and OLAP are familiar to many database technicians. BI gradually appeared along with the development of the era of new types of BI and the division of traditional BI, from the current level of development, traditional BI is slowly decline, because traditional BI from high threshold, need professional IT staff to complete, and the process is complex, weak in data visualization, these problems has become the bottleneck of the development of traditional BI, on the contrary, The new BI is in a period of rapid development.
Recently, Ali Cloud released Quick BI V3.0, the new version on the original basis can be more efficient data analysis, so Quick BI V3.0 compared with what has been improved? Next, the author takes inventory in detail.
Product innovation to reshape BI’s new positioning
Quick BI’s “spreadsheet capability” for entry-level data analysts is unique to the industry. It’s an Excel like operation that lowers the barrier to entry and improves the user experience. Quick BI enables almost anyone to do data analysis online.
In order to further reduce the user threshold, we can see the new group field function of V3.0 Professional group space. For example, in the past, if a restaurant wants to group the amount of profit, it can be divided into three groups: 0~50, 50~100 and more than 100. You need to write SQL to do that.
Now, a simple configuration is required to add fields, as shown in the figure below.
Added fields in the dataset to achieve the same visual effect in the dashboard:
In the analysis link, Quick BI V3.0 has also been updated to restore the user’s analysis link and add the cross-jump function. In order to realize the linkage between data, it is necessary to make three tables: “area – consumption store”, “store-member nickname list” and “member user information”. But now it is changed to a chart display, only need from “area – consumer store – member nickname list – member user information”, through the dashboard jump three layers click to realize the recovery of the analysis link, and according to the click value, each time dynamically open the corresponding parameter page.
Quick BI V3.0 supports deep multidimensional analysis capabilities. In addition to chart drilling, linkage and jump, it can also support unstructured/semi-structured data query, text analysis and index optimization of date-type fields of some data sources.
Users’ requirements for BI tools are not only limited to data analysis, but also have high requirements for the color scheme of dashboard charts. When using the dashboard embedding function, they need to keep the color scheme consistent with their own website. Before the Quick BI3.0 version was available, users had to adjust the color of each curve on a single chart, which was time-consuming and difficult to configure.
By adding the whole color system switch method, one button to change the color system configuration of all charts, and this function through the color system collocation of professional designers, more fashionable and business.
In addition to the new overall color palette toggle Settings, Quick BI3.0 new region color map, region bubble map, TAB component new styles. When the TAB component was used before, the chart could not be adjusted to the TAB component or moved out of the TAB component as required. If the scene needed to be moved, it had to be re-made, and the configuration process was complicated and repetitive.
Components can now be moved to or from the TAB, reducing the user’s workload. At the same time, the main and subtitle Settings are supported to meet the display scenarios of multiple component headings.
I found that before has not been convenient drilling, in this edition also has a new breakthrough, in the current page click
The corresponding area of the chart can be used for the trip interaction. You no longer need to open the “More Settings” screen.
Data source code is added to expand the coverage of the database after this version upgrade, Data Lake Analytics is added to the connected Data source above the advanced version; SAP IQ(Sybase IQ) and SAP HANA are added to the professional version to further expand the coverage of the database and make Quick BI available to more users.
The positioning of Quick BI3.0 is to provide impromptu analysis of massive data, electronic report making and drag-and-drop visual analysis capabilities, so that people who know business can realize data analysis by themselves, reshape the whole link of data production, and finally realize that everyone is a data analyst.