The DataAnalysis module of DataWorks allows you to analyze, edit, and share data online. This topic provides an overview of DataAnalysis, including its features, benefits, and permissions.

Benefits

Compared with offline data analysis, DataAnalysis provides the following benefits:
  • High capacity: DataAnalysis uses compute engines to analyze large amounts of data in an efficient manner.
  • Data mobility: DataAnalysis allows you to obtain data from different data sources for query and analysis and share analysis results with specified members.
  • High security: DataAnalysis allows you to analyze data online without the need to download data to your on-premises machine. DataAnalysis also allows you to manage the permissions to analyze and share data.

Features

  • SQL query

    The SQL query feature allows you to query and analyze data in an existing data source. For more information, see SQL query.

  • Workbook

    The workbook feature is the core feature of DataAnalysis. The feature provides a personal space in which you can create and configure a workbook to obtain, explore, and analyze data. The feature also provides common workbook functionalities that can help you get started with workbooks. You can import data from data sources or your on-premises machine to a workbook and perform data profiling. You can also share a workbook with a specified member to allow the member to view data in the workbook. For more information, see Create and manage a workbook.

  • Dimension table

    You can use the dimension table feature to upload data from your on-premises machine to a MaxCompute table and use the MaxCompute table together with other tables to analyze data online. For more information, see Create and manage a MaxCompute table.

    In some cases, data analysts and operations engineers need to manually maintain an online MaxCompute table. If the dimension table feature is not used to create a MaxCompute table, the following operations must be performed each time 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 need to only create, modify, and save a MaxCompute table in DataAnalysis. This improves efficiency.

Permissions

Since June 1, 2022, only users to which the Data Analyst role is assigned can use DataAnalysis. If you want to use DataAnalysis, you can contact the user that is assigned the Workspace Manager role to assign the Data Analyst role to you. For more information, see Manage workspace-level roles and members.
Note
  • Users that are assigned the Visitor role or a custom role but are not assigned the Data Analyst role before June 1, 2022 can no longer use DataAnalysis after June 1, 2022.
  • Users that are assigned a role other than the Visitor role or a custom role are automatically granted the permissions on DataAnalysis and can continue to use DataAnalysis.
For more information about users, roles, and permissions, see Permissions of workspace-level roles.

Go to the DataAnalysis page

You can use one of the following methods to go to the DataAnalysis page:
  • Method 1: Go to the DataAnalysis page from the homepage 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 desired workspace resides. Find the workspace, move the pointer over the more icon, and then click Homepage in the Actions column.
    4. On the page that appears, click the Data Analysis Scene tab. On the Data Analysis Scene 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 of the region where the desired 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 the region where the desired workspace resides. Find the workspace and click DataStudio 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.

By default, the Homepage tab is displayed. In the Shortcuts section on this tab, you can click SQL Query or Spreadsheet to perform the related operations to analyze data. In the Recently Edited section on this tab, you can click the name of a file to perform operations.