With the arrival of the third quarter of 2023, Xpert Analytics Cloud has once again stepped into a brand new version, bringing a series of exciting features and architectural upgrades. In this blog post, we will focus on the latest features of Xpert Analytics Cloud 2023 Q3 and the upgrade of the software architecture.

1. Software Architecture Upgrade​

1.1 Angular 16 & Signal State Management​

The Xpert analytics cloud has been successfully upgraded to the new Angular 16 version, bringing users a faster and smoother user experience. In terms of UI component state management, we have taken an important step and started to rewrite it step by step in a brand new way Signal. This will not only improve the stability and performance of the system, but also make the development process more efficient.

1.2 UI Design with Tailwind CSS​

In terms of UI design, the Xpert analytics cloud 2023 Q3 version ushered in a revolutionary change. We have fully adopted Tailwind CSS to redesign the style of UI components, presenting users with a more modern and beautiful interface, and also improving the ease of operation.

This article will introduce how to deploy Xpert Analytics Cloud privately and integrate it with the StarRocks data source to provide powerful multidimensional data indicator analysis capabilities for enterprises and data analysis teams. In this article, we will use tools such as Docker Compose to build and run this private deployment program.

Introduction​

Xpert Analytics Cloud is an advanced data analysis platform that helps users get data from a variety of data sources and perform efficient data exploration and visual analysis. StarRocks is a fast, scalable distributed OLAP database that is particularly suitable for multidimensional data analysis. Integrating these two tools together can enhance data analysis capabilities and improve data insights.

An indicator management system is a tool for collecting, analyzing and monitoring business data of enterprises. Enterprises need an indicator management system because it can help enterprises understand their business conditions, evaluate their performance and formulate effective strategic plans.

Through the OLAP engine based on the core, the Xpert Analytics Cloud establishes a unified semantic model of enterprise data, without cumbersome data transformation and ETL, and through the unified caliber indicator definition function, the enterprise operating data is uniformly managed and certified. Finally, through the indicator application provided by the Xpert Analytics Cloud, the indicator is used to analyze and evaluate the business and financial data of the company.

Xpert Cloud Story Dashboard is a powerful large screen display tool designed to help users visualize data and information. It offers a variety of impressive features, including individually setting widget styles and unifying setting global widget styles, allowing users to design unique widget styles according to their needs. In addition, users can customize CSS with advanced style features to achieve more refined and personalized large screen style effects. The slide widget function makes the large screen dynamic and interactive, while the custom data refresh event and automatic page turning function ensure timely data update and automatic page switching. Not only that, the dashboard also provides flexible large screen page size settings, which can be fully adapted to full screen or fixed screen size to meet a variety of display needs. Xpert Cloud Story Dashboard allows users to easily create beautiful, interactive and personalized large screen displays, bringing visual shock and pleasure to the audience.

Xpert Analytics Cloud is a data visualization analysis platform. It provides a powerful story dashboard function, which includes the ability to customize graphic logic. This capability allows users to use common open source graphics libraries to display and manipulate custom graphics.

ECharts is an open source JavaScript chart library that provides rich visual chart types and interactive features, including line charts, bar charts, pie charts, radar charts, and more. Meta-analysis cloud integrates ECharts and provides the ability to customize graphic widget logic in the story dashboard feature so that users can create and customize graphics in a more flexible way.

With the ability to customize graphic logic, users can customize and interact with graphs by writing JavaScript code according to their own needs and data characteristics. Users can define the appearance style of the chart, data processing logic, interaction behavior and so on.

This article shows you how to create a story dashboard using the semantic model and indicators created earlier. The 📖Story Dashboard feature in Xpert Analytics Cloud is a visual reporting tool that helps users turn data into meaningful narratives. It is usually composed of a series of pages or slides, each of which can contain different charts, images, and text.

Final effect preview sales summary:

Xpert analytics cloud relies on semantic models to have powerful indicator management functions, aiming to help users effectively manage and monitor indicators in data models. Xpert analytics cloud builds a unified semantic modeling of enterprise data through a core OLAP engine, without cumbersome data conversion and ETL, and unifies the definition of indicators to manage and certify enterprise business data. Finally, through the indicator application and story dashboard provided by Xpert analytics cloud, the indicators are used to analyze and evaluate the company's business and financial data.

This article will use the indicator management function of Xpert analytics cloud to define a complete set of indicator management systems for the AdventureWorks Sales data model.

The semantic model in Xpert Analytics Cloud provides rich role & access control functions to ensure the security and access control of data. These role permissions can be applied to multi-dimensional data sets, dimensions, hierarchies, and members to meet specific user needs.

In the Xpert Analytics Cloud, two types of roles can be created: single role and composite role.

1. Single role: A single role is an independent role with specific permissions. Permissions to access multidimensional datasets, dimensions, levels, and members can be specified for a single role. This way, you can control the role's access to and manipulation of different levels in the data model.

2. Composite role: Composite roles are roles composed of multiple single roles. For example, a composite role can be created for a regional manager to allow access to a union of sub-regions in the sales dataset.

Through these role permission control functions, Xpert Analytics Cloud provides flexible 🔐 Access Control mechanism, so that administrators can accurately manage the access permissions of data according to user roles and needs. This not only protects the security of sensitive data, but also ensures the compliance and privacy protection of data.

In today's data-driven era, harnessing data for in-depth analysis and insights has become crucial for businesses to gain a competitive advantage. Power BI is a widely popular business intelligence tool, while Xpert Analytics Cloud serves as a powerful data analysis platform that offers comparable modeling capabilities to Power BI. This article will explore how to leverage the semantic modeling capabilities of Xpert Analytics Cloud to achieve similar functionalities as Power BI, using the AdventureWorks Sales dataset for demonstration purposes.

Below is the data relationship model of the AdventureWorks Sales dataset in Power BI:

摘要​

本文将详细介绍元数分析云与 Doris 集群的集成，探讨如何利用元数分析云的多维建模和指标管理功能，充分发挥 Doris 集群 MPP 架构的数据并行计算能力，为用户提供强大的数据分析和查询解决方案。