Shulou(Shulou.com)11/24 Report--

Throughout the past, we have found that the development of automobile and BI are similar.

For more than 100 years, the power of cars ranges from steam to fuel to new energy, and the control of cars ranges from manual to automatic to intelligent self-driving.

In the field of BI, since the concept of BI was put forward in 1958, the underlying data preparation includes report development, Cube multi-dimensional model, wide table and then to indicators; the upper data analysis from the traditional report, large screen, to agile self-help visualization exploration, and then to intelligent enhanced analysis.

Picture: four stages of the development of BI in China

By comparison, it is found that although automobile and BI belong to different industries, they have experienced the continuous exploration of technology, and both take intelligence as the future goal to reduce the threshold, save energy and increase efficiency.

As a well-known domestic BI manufacturer Sematic Software, it has been combining industry-leading technology and best practices for more than ten years, sparing no effort to create good products for users.

On August 8, Sematic Software released the one-stop ABI platform Smartbi Insight V11 version (hereinafter referred to as V11 version) at the "2023 Smartbi V11 Series New Product launch", which helps enterprises realize digital operation through index-driven and intelligent decision-making. Next, we will deeply interpret the Smartbi one-stop ABI platform from three dimensions.

Highlight one

Index-driven, surging power

The engine of a car is like the heart, which can provide power for the car. A good engine running at high speed will make the car more energy-efficient, fast, stable and safe.

The data model and index model of the Smartbi Insight "data management" layer is like the engine of a car. When it runs surging, it provides continuous power for the upper data application and data consumption, so that enterprises can soar on the right road, such as fast speed, stable and far away, safe and orderly!

▎ data Model-- Encapsulation of powerful data processing capability

The data model encapsulates multi-source, heterogeneous and complex original data, and forms a data model with strong data processing ability, well-organized and understandable by everyone through convenient dimension index definition, calculation and measurement and the derivation of members. So that business users can use the data simply and conveniently.

V 11 version further strengthens the data processing capacity of the data model and lowers the threshold for use. The data model implements twin engines, similar to the "DM-i super hybrid" of cars. The new SQL engine can query detailed business data with a large amount of data; in addition, the data model supports wizard-like visual operations to create computational metrics and columns, which is easy to use.

Figure: guided generation calculation metric

▎ Index Model-- A Bridge for Communication of Business and Technical requirements

It is very handy for users to apply data through the data model. However, the way it is built is still a little complicated for business people who do not understand technology, and they cannot see the full picture of enterprise data assets and indicators.

Smartbi also provides the function of index model. Through deep business participation and one-stop index management service, it can help enterprises build a self-growing index system and form their data assets.

The index model builds a bridge of demand communication between business users and technical personnel, both sides use common interface and language to communicate, business users use business terms to describe requirements, and technicians directly transform it into the index model in Smartbi. In this process, there is no loss and deformation of information, and the caliber of indicators is unified. At the same time, on the index model that has been built, business users can directly derive the calculation index without the participation of technicians.

Figure: calculation indicator derivation

In the V11 version, the index model with a unified caliber of business and technology can be automatically transformed into a data model for subsequent query and analysis with one click, and users can freely select dimensions and indicators according to their needs and split them into multiple data models. This can not only form a proprietary business model, but also be easy to maintain and have better performance, thereby improving the user experience.

In V11, the indicator model supports direct access to dimension tables and fact tables in the database. When an enterprise has its own data warehouse, but lacks a unified index system management platform, it can realize the storage mapping of indicators through this function, so that unified management can be achieved without all reconstruction.

Figure: dimension table and fact table connected to the database

Highlight two

Free control and intelligent decision-making

The control mode of the car is from manual, automatic to intelligent self-driving, which aims to reduce the technical difficulty and threshold of driving through high and new technology, so that more and more people can enjoy the convenience brought by the car.

Our one-stop ABI platform Smartbi Insight provides spreadsheet, self-help analysis tool set, dialogue analysis, data mining and other functions to meet the full scene data application needs of different BI stages (traditional BI, self-help BI, intelligent BI) in breadth and depth.

▎ self-help analysis-- teach people how to fish and make the business useful

The V11 version reorganizes and plans the content and interface paths of some functions, and the new impromptu query, perspective analysis and interactive dashboards are more in line with user habits and needs, and are extremely easy to use.

Figure: new ad hoc query, self-service detail data query tool, check and drag to query freely

Figure: interactive dashboard, with rich components and component templates, visible operations WYSIWYG

Conversational Analysis of ▎-- ChatGPT in the Field of BI

The dialogic analysis function of Smartbi Insight is to analyze data through the interaction between natural language and data.

In V11 version, dialogic analysis uses a new query scheme supported by LLM, models the data by index, makes it easier for users to understand, provides complex computing power through the data model, accurately understands the user's intention through LLM, and finally completes the interaction through NL2MQL to provide the desired results.

In V11 version, conversational analysis supports more diverse uses. Independent "conversational analysis" is free to explore data and share results with the outside world; create pages quickly through AI question and answer in interactive dashboards, improve the efficiency of large screen & report development by more than 200%; and integrate with enterprise IM nails and Wechat to work together efficiently.

Highlight three

New UI, excellent experience

V11 version uses popular design elements and color schemes to create a new UI style, the overall color is fresh and natural, showing users concise and beautiful, clear and unified visual feedback. These well-crafted UI effects can be put into use directly.

In addition, we have made an in-depth study of the habits of BI users and re-optimized the product modules, interaction and operation methods, etc., not only the classification is clearer, but also provides guiding operations to improve product ease of use and efficiency, users are more comfortable to use, reduce user learning and use costs, experience more quality and pleasure!

Figure: add a navigation page to get through the help system, so that users can work and study more efficiently

Figure: launch a "personal center" to manage resources for easy access, organization and sharing of information

In addition to the highlights described above, Smartbi Insight V11 has enhanced data source expansion, visual analysis, stability, and performance. V11 version polishes the underlying data preparation, tamps the upper intelligent analysis, and achieves a comprehensive upgrade from the bottom up, thus leading the new navigation mark of digital operation!

Welcome to the experience center, personally "test drive" experience!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.