DataAnalysis allows you to analyze, edit, and share data online.

Benefits

Compared with offline data analysis, DataAnalysis has the following benefits:
  • High efficiency: DataAnalysis analyzes data in a database by using online data analysis tools, such as pivot tables. For example, in a user profile table, you can create a pivot table for a partition that belongs to September. When data for October is obtained, you can update the source data and reuse the configuration of the pivot table for September to obtain a pivot table for October. This avoids repeated operations.
  • High capacity: DataAnalysis efficiently analyzes large amounts of data with the help of compute engines.
  • Data sharing: DataAnalysis can analyze data obtained from the databases of different business systems. DataAnalysis allows you to export data to MaxCompute tables. It also allows you to share data with specified members and grant them access permissions. This way, data can be shared between different systems and different users.
  • High security: DataAnalysis allows you to analyze data online without the need to download data. It also allows you to manage the permissions that allow users to analyze and share data.

Features

  • Workbook

    Workbooks are the core feature of DataAnalysis. A workbook is a workspace in which you can obtain, explore, and analyze data. A workbook is in the form of an online table and offers common table features. After you import data from data sources or import on-premises data to workbooks, you can perform data pivoting and profiling. For more information, see Workbook.

  • Dimension table

    The dimension table feature allows you to create MaxCompute tables without the need to write SQL code. It also allows you to collaboratively edit MaxCompute tables with other users online. The dimension table feature also allows you to import data to MaxCompute tables in a visualized manner. For more information, see Dimension table.

    In some cases, data analysts and operations engineers want to manually maintain an online MaxCompute table. If the MaxCompute table is not created by using the dimension table feature, the following procedure must be performed whenever data changes occur:
    1. Operations engineers describe their requirements to data analysts.
    2. Data analysts submit the requirements to developers.
    3. Developers edit SQL statements by using DataWorks, create an Excel table, synchronize data to the Excel table, and then deliver the Excel table to operations engineers.

    If the dimension table feature is used, operations engineers can create, modify, and save a MaxCompute table in DataAnalysis. This improves efficiency.

  • Report

    You can create and design visual reports by dragging and configuring controls without the need to execute SQL statements. For more information, see Report.

  • SQL query

    The SQL query feature allows you to query and analyze data in an existing data source.