All Products
Search

This Product

    DataWorks:Use MaxCompute for data analysis and Quick BI for visualization

    Document Center

    DataWorks:Use MaxCompute for data analysis and Quick BI for visualization

    Last Updated:Feb 27, 2026

    This tutorial uses the E-commerce industry as an example. It shows how to use MaxCompute and DataWorks to perform extract, transform, and load (ETL) on business and log data. The data is then synchronized to AnalyticDB for MySQL for real-time analysis and visualized in Quick BI.

    Background information

    • MaxCompute: Used for large-scale data computing. For more information, see What is MaxCompute.

    • AnalyticDB for MySQL: Used for real-time, high-concurrency online analysis of massive data. For more information, see AnalyticDB for MySQL.

    • DataWorks: Used to perform ETL to collect, transform, and analyze complex datasets. For more information, see What is DataWorks.

    • Quick BI: Used to create reports from processed data for visual display and analysis. For more information, see Quick BI overview.

    Scenarios

    • BI analysis for websites, apps, and miniapps in industries such as the Internet, E-commerce, and gaming.

    • BI analysis for various websites.

    Solution overview

    The flow for big data BI analysis using MaxCompute is as follows:

    1. Use data integration to synchronize business and log data to MaxCompute.

    2. Use MaxCompute and DataWorks to perform ETL on the data.

    3. Synchronize the processed data to AnalyticDB for MySQL.

    4. Use Quick BI to create and visualize user personas.

    Benefits

    • The combination of AnalyticDB for MySQL and Quick BI provides fast, real-time data analysis. This solution also simplifies the synchronization of business and log data to Alibaba Cloud analytic databases.

    • This solution integrates with the Alibaba Cloud Simple Log Service ecosystem and seamlessly connects with products such as Blink, Elasticsearch, AnalyticDB for MySQL, E-MapReduce, and DataV to enhance the user experience.

    • The powerful data transformation and analysis capabilities of MaxCompute and AnalyticDB for MySQL lower the barrier to building big data platforms and make it easy to handle massive data computation. This solution also reduces enterprise costs and ensures data security.

    • This solution seamlessly integrates with third-party open source ecosystems. Logs can be sent to Simple Log Service without modifying user applications, which lowers the barrier to entry.

    Solution details

    For more information, see Big Data BI Analysis Based on MaxCompute.