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

Go to the DataAnalysis page

You can use one of the following three methods to go to the DataAnalysis page:
  • Method 1: Go to the DataAnalysis page from the Homepage page of DataWorks.
    1. Log on to the DataWorks console.

    2. In the left-side navigation pane, click Workspaces.
    3. In the top navigation bar, select the region where the required workspace resides, find the workspace, and then click Homepage in the Actions column.
    4. On the page that appears, click the Data Analysis tab. On the Data Analysis tab, click Start Now in the DataAnalysis section.
  • Method 2: Go to the DataAnalysis page from the Overview page of the DataWorks console.
    1. Log on to the DataWorks console.

    2. In the left-side navigation pane, click Overview.
    3. Click the tab for the region where the required workspace resides and click DataAnalysis.
  • Method 3: Go to the DataAnalysis page from the DataStudio page.
    1. Log on to the DataWorks console.

    2. In the left-side navigation pane, click Workspaces.
    3. In the top navigation bar, select a region. Find a workspace and click Data Development in the Actions column.
    4. On the DataStudio page, click the Icon icon in the upper-left corner and choose All Products > Data Analysis > DataAnalysis.

In the Shortcuts section of the DataAnalysis page, you can click Spreadsheet, SQL Query, or SQLNotes as needed to perform data analysis. In the Recently Edited section, you can view recently edited files. You can also click a file name to open the file and perform operations on the file.

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 specific 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. For more information, see SQL query.