Analyze data

Go to the workbook editing page

1. Go to 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 your workspace resides, find the workspace, and then click Data Analytics in the Actions column.
2. On the DataStudio page, click the icon in the upper-left corner and choose All Products > Data Development > DataAnalysis.
3. On the DataAnalysis homepage, click Experience Now. The Web Excel page appears.
4. Choose Web Excel > All Spreadsheets and click the name of the required workbook to go to the workbook editing page.
   If you create a workbook, the workbook editing page appears after the workbook is created. For more information, see Create a workbook.

Edit the workbook

In a cell on the workbook editing page, you can enter content or enter a formula that references values in other cells. The column headings are labeled with letters, which start from A and increase alphabetically from left to right. The row headings are labeled with numbers, which start from 1 and increase from top to bottom.

You can right-click a row or column heading and select an option to delete, hide, or show the row or column.

You can right-click one or more selected cells and select an option to cut, copy, or paste data.

Data pivoting

1. On the workbook editing page, select the data for which you want to create a pivot table and click Pivot in the upper-right corner.
2. In the Create Pivot Table dialog box, specify the data to be analyzed.
   You can select Select Range or Use External Data Source.

   • Select Range
     When you select the cells for which you want to create a pivot table, the value of the Range parameter changes accordingly.
   • Use External Data Source

     You can select a data store of the MaxCompute, MySQL, Data Services, or PostgreSQL type. If you use an external data store, prepare the required connection or API in advance and select the connection or API based on the business requirements. For more information about connections, see Connection configuration.

3. Click OK. The pivot table editing page appears.
   

   In this example, select Select Range.

   • Data Source: the range of the selected data in the Excel file.
   • Pivot Table Fields: the names of the fields in the selected data.
   • Row: Drag a field to the Row section. Each value of the field added to the Row section occupies a row in the pivot table.
   • Column: Drag a field to the Column section. Each value of the field added to the Column section occupies a column in the pivot table.
   • Indicator: To modify the settings of an indicator, move the pointer over the indicator, click the icon, and then select Edit.
     In the Property settings dialog box, set the Summary method parameter and click OK. By default, the name indicated by the Field Display Name parameter is in the format of Summary method:Source field name and cannot be changed.
   • Filters: To filter data, click Set Filter. In the Set Filter dialog box, click Add Condition, specify the filter conditions, and then click OK.
   • Sort: To sort a field specified in the Row section, click Set Sort. In the Set Sort dialog box, specify the sorting rule and click OK.

Data profiling

The Data Profile feature allows you to analyze the quality, structure, distribution, and statistics of data. This feature also allows you to preview, profile, process, analyze, and visualize data. The Data Profile feature analyzes data based on columns and allows you to view the data types and value distribution of each column.

Select the data to be analyzed and click Data Profile in the menu bar. Then, you can view the data types and value distribution of each column at the top of the workbook in the form of charts and rich text.

Click Detailed Mode in the upper-right corner. In the Data Profile dialog box, you can view the profiling result, including the field name, field data type, field description, and security level of each column.