The Data Visualization tool helps you to quickly extract important information from large data sets by providing a way to visually analyze the data. Data Visualization creates a multi-layered, interactive graphic report by converting columns to dimensions or measurements. Once Toad visualizes the data, you can swap data dimensions to get the view you want.
Note: This feature is available in the Toad Data Studio Professional Edition only.
To visualize data
Use one of the following methods to send data to the Visualize Data window:
Note: Toad automatically determines what columns in the data set are dimensions, measurements, and unused. Toad also determines the best order of the dimensions to drill down into the data.
Customize the visualization by modifying options in the Setup pane. Review the following for additional information:
Note: To drill down to the next visualized dimension, your must click a data point or pie/bar graph section.
Dimension/Column Treelist (upper left-hand side) | Description |
Visualization Type (chart type)
|
Click the drop-down list to select the type of chart for the visualization. Note: Select Use same chart type during drill down to next dimension to use the same chart style for all dimensions. Click Notes:
|
|
Displays the chart formatting and layout options for the dimension currently visualized. (The currently visualized dimension is the one that appears in the visualization window and displays in bold in the treelist.) The options display in the property grid in the lower part of the Setup pane. To display a dimension's Visualization Options With the dimension displayed in the visualization window, click Visualization Options. Note: Visualization options are not available for the pivot grid chart. To modify a dimension's Visualization Options In the property grid, click the text boxes to enter new values or select from drop-down lists. Note: The Visualization Options available vary depending on the type of chart selected. To add labels to data points, bars, and pie charts In the property grid, under the Values node, select True for the label value. |
Treelist (Dimensions, Measurements, Unused Columns)
|
Toad automatically determines how to use columns to create the visualization. The treelist displays which columns are dimensions and which columns are measurements (and which are unused). It also displays the order of the dimensions. To reorder or rearrange columns in the treelist Drag and drop columns up and down the treelist to reorder dimensions, or drag columns to a different category (dimensions/measurements) within the treelist. Notes:
|
Property Grid (lower left-hand side) |
Description |
|
Displays one of the following:
To display a dimension's Visualization Options With the dimension displayed in the visualization window, click Visualization Options. To display a column's data options Click a column name in the treelist. Notes:
|
Visualization Window | Description |
Displays the visualization of the data set. Displays one dimension at a time. Notes:
|
Use the bottom toolbar to:
To save the visualization as a Toad Data Visualization file. | |
To automate the visualization. See Use Database Automation Activities for more information. | |
To add the file to the Project Manager. |
To delete the anonymous Visualization tables
Toad creates anonymous visualization tables as part of the process of visualizing data. These tables are stored as part of the Local Storage hub. You may want to delete these tables to free up space. If you delete all the tables, they are recreated when you re-open the visualization.
To delete these tables, click in the Visualization toolbar. You can delete these tables individually or by file date or file size. The tables are identified by their date/time stamp.
Notes:
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center