Chinese-style Reporting Pro Feature Overview
Overview
Chinese-style Reporting Pro (GuanReport) is an extended reporting capability embedded in the Guandata all-in-one intelligent data analytics platform. It is designed to deeply integrate Excel with the Guandata intelligent data analytics platform.
Chinese-style Reporting Pro inherits the strengths of Excel, such as flexible structure, styling, and calculation logic. At the same time, it shares the Guandata BI mechanisms and capabilities for data integration and refresh, Smart ETL, filter linkage analysis, row- and column-level permissions, downloading, and distribution, giving users a reporting experience that balances flexibility and efficiency.
Key Advantages
- Highly Compatible with Excel: Preserves familiar Excel interaction patterns and supports a wide range of spreadsheet capabilities and more than 450 native functions.
- Low Learning Curve: Report templates can be edited with drag-and-drop operations and real-time preview, making it easy to get started.
- Fast Online Migration: Reuse the format and content of offline reports to migrate them online quickly without redefining calculation logic.
- Smart Data Preparation: With the built-in Smart ETL capability of the Guandata BI platform, Chinese-style Reporting Pro (GuanReport Pro) can quickly connect to and process the various data sources required for complex enterprise reports.
- Secure Permission Control: Enterprises can use the existing data permission controls in Guandata BI to manage the data sources used by complex reports and reduce risk.
- Complex Calculation and Analysis: Supports value query statements, inter-cell calculations, and parameterized queries, and can work together with other charts in BI through linkage and filtering.
- Sharing and Collaboration: Supports template download, Card export, and subscriptions, making it suitable for shared reporting across multiple users.
Overall, Chinese-style Reporting Pro (GuanReport Pro) is designed for Chinese-style complex reports that involve scattered data sources, complicated table structures and headers, and intricate calculation logic. It is widely used in business scenarios such as sales analysis, financial operations, and supply chain analysis.
The product meets the needs of business users for efficient report creation while also satisfying enterprise requirements for data security. It supports fast source-data preparation, highly compatible Excel-style flexible design, integrated visual analysis, and report sharing and collaboration, significantly improving report production efficiency and reducing the development threshold.
Use Cases
Supply Chain Data Analysis
Supply chain data analysis usually includes logistics analysis, procurement analysis, production analysis, inventory analysis, delivery analysis, transportation network analysis, and supply chain node location analysis. Chinese-style Reporting Pro (GuanReport Pro) can meet the needs of different roles and help create visually polished supply chain analysis reports.

Sales Analysis
Regardless of the enterprise structure, sales targets are usually broken down across multiple levels. Managers need to monitor overall target attainment, and frontline sales staff need to track their own progress. As a result, sales analysis reports are often complex. Chinese-style Reporting Pro (GuanReport Pro) can support different user roles and help create visually polished sales analysis reports.

Profit Analysis
Profit analysis, also known as profit and loss analysis, is financial analysis centered on the income statement. It is closely related to revenue, costs, and expenses, and is often relatively complex. Chinese-style Reporting Pro (GuanReport Pro) can support different roles and help create visually polished profit analysis reports.

Financial Analysis
Financial analysis evaluates the profitability, operating ability, solvency, and growth of an enterprise based on accounting records, financial statements, and other related information. It often combines single-metric and multi-metric analysis with reference values such as budgets or targets, then presents results through intuitive reports and visual materials. Chinese-style Reporting Pro (GuanReport) is well suited for these complex reporting needs.

Operational Reports
Operational reports are usually used to reflect a company’s profit realization or loss over a certain period. They provide the information needed for business decision-making, profit fluctuation analysis, operating cost analysis, and investment evaluation. These reports are often complex and benefit from reusable analytical models, making Chinese-style Reporting Pro (GuanReport) a strong fit.
