DataWorks:Analyze data using online workbooks

Version limits

• Visualization chart limits: The Basic Edition is limited to seven chart types. To access more chart types, you can upgrade to DataWorks Standard Edition or a higher edition.

• Workbook sharing limits: The maximum number of editors and viewers that you can specify varies by edition.

  Feature/Edition	Basic Edition	Standard Edition	Professional Edition	Enterprise Edition
  Maximum number of editors	0	3	5	10
  Maximum number of viewers	0	10	20	30

Go to Workbooks

On the DataAnalysis page, click Go To DataAnalysis. In the menu bar on the left, click the or icon to open the Workbooks page.

Create a Workbook

Before you analyze data, you must create a workbook to hold the target data.

Import data into a workbook

Workbooks support direct data entry and importing data from local files for data analysis.

On the workbook editing page, click the Import button in the upper-right corner. You can import Workbooks, Local CSV Files, or Local Excel Files.

Analyze data

Workbooks provide a rich set of data analysis operations similar to those in Microsoft Office Excel. On the workbook editing page, you can set the font, alignment, number format, rows and columns, conditional formatting, and styles. You can also profile the data in the workbook.

View and manage workbooks

1. On the workbook editing page, click Workbooks in the upper-left corner or the icon in the left menu bar to navigate to the workbooks list page.

2. On the Workbooks page, in the All Workbooks area, you can view the workbooks in the Created By Me and Shared With Me lists.

3. On the list page, you can manage workbooks as follows:

   • Rename: Click the icon next to the file. In the Rename dialog box, enter a new name in the File Name field and click OK.

   • Change Owner: Click the icon next to the file. In the Change Owner dialog box, enter and select the new owner, and then click OK.

   • Clone: Click the icon next to the file. A new file with the _copy suffix is created.

   • Delete: Click the icon next to a file. In the Delete dialog box, click OK.

4. Click a File Name to reopen the workbook's editing page.

Export, share, and download workbooks

After you process and analyze data in an online workbook, you can export, download, or share the data with specified users.

Appendix: Button details

On the workbook editing page, you can configure the following items:

• Font

  Ordinal Number	Feature	Description
  ①	Font	Select the font type.
  ②	Font Size	Select the font size.
  ③	Bold	Make the text bold.
  ④	Italic	Italicize the text.
  ⑤	Underline	Add an underline to the text.
  ⑥	Strikethrough	Add a strikethrough to the text.
  ⑦	Border	Add a border to the text.
  ⑧	Background Fill	Fill the background color of the text.
  ⑨	Text Fill	Change the color of the text.

• Alignment

  Ordinal Number	Feature	Description
  ①	Align Top	Align text to the top.
  ②	Middle Align	Align text to be centered between the top and bottom of the cell.
  ③	Align Bottom	Align text to the bottom.
  ④	Auto Wrap	Display long text on multiple lines to make it all visible.
  ⑤	Align Left	Align text to the left.
  ⑥	Center	Center text horizontally.
  ⑦	Align Right	Align text to the right.
  ⑧	Merge & Center	Combine the selected cells into one larger cell and center the content in the new cell.

• Number

  Ordinal Number	Feature	Description
  ①	Data Type	Select the cell format, such as Number, Currency, Short Date, Long Date, Time, Percentage, Fraction, Scientific, and Text.
  ②	Percentage	Set the data type of the cell to percentage.
  ③	Two Decimal Places	Format the data in the cell to two decimal places.
  ④	Thousand Separator	Separate thousands in the cell's data with a comma, for example, 1,005.
  ⑤	Currency	Set the data type of the cell to currency, such as CNY, USD, GBP, EUR, and CHF.

• Rows and Columns

  Ordinal Number	Feature	Description
  ①	Insert Row	Add a new row of cells to the workbook.
  ②	Insert Column	Add a new column of cells to the workbook.
  ③	Delete Row	Delete the selected row of cells from the workbook.
  ④	Delete Column	Delete the selected column of cells from the workbook.
  ⑤	Freeze Row	Freeze all rows above the selected row in the workbook.
  ⑥	Freeze Column	Freeze all columns to the left of the selected column in the workbook.
  ⑦	Hide Row	Hide the selected row in the workbook.
  ⑧	Hide Column	Hide the selected column in the workbook.

• Conditional Formatting

  Ordinal Number	Feature	Description
  ①	Filter-based Conditional Formatting	Includes rules in Highlight Cells Rules and Top/Bottom Rules.
  ②	Color Fill Conditional Formatting	Includes styles in Gradient Fill, Solid Fill, and Color Scales.
  ③	Icon Fill Conditional Formatting	Includes Directional, Shapes, Indicators, and Ratings icons.
  ④	Clear Conditional Formatting Effects	Includes Clear Rules From Selected Cells and Clear Rules From Entire Sheet.

• Style

  Ordinal Number	Feature	Description
  ①	Apply Table Style	Select and apply a table style.
  ②	Delete	Remove the applied table style.
  ③	Cell Style	Set the style of the cell.
  ④	Clear	Includes Clear All, Clear Contents, and Clear Formats.

• Edit

  Ordinal Number	Feature	Description
  ①	AutoSum	Supports five types: Sum, Average, Count Numbers, Max, and Min.
  ②	Find	Click Find directly, or use the keyboard shortcut Ctrl+F to open the input box.
  ③	Filter And Sort	Filter data and sort it in ascending or descending order.
  ④	Clear	Directly delete the selected content.

• Charts

  Ordinal Number	Feature	Description
  ①	Column Chart	For more information, see Column chart.
  ②	Line Chart	For more information, see Line chart.
  ③	Pie Chart	For more information, see Pie chart.
  ④	More	Click More to select charts such as: Area chart Bar chart Scatter chart Stock chart

• Plugins: This section provides the Type Conversion feature. Click the icon to apply Convert To Numeric or Convert To String to the selected data.

• Keyboard Shortcut List: Click the icon to view the shortcuts for each feature.