Many types of ad-hoc analytics are available to graphically visualize the data displayed in the data table of the data workbench. This ensures that you visualize data that is relevant for your reporting purpose.
In addition to the data table where you can edit and filter your data, you can click the Visualize button to display Gantt charts (timelines), Portfolio charts, and matrix reports where you can visualize and edit the data. Other graphic visualizations include bar, line, pie, area, radar, and doughnut charts and cards. You can also use these visualization types to show the data that you select in the data table to display.
Other kinds of reports may also be available in the Visualize menu of the data workbench. These are preconfigured reports with a fixed thematic scope that visualize the dataset specified in the data table.
Ad-hoc analytics rely on the data that is visible in the data table. Therefore, it is important to reduce the data so that your visualization is meaningful. The number of objects which can be displayed in business charts is limited to 50 to ensure readability of the graphic. There are two ways to specify the data in the data table for the visualization:
- Select the checkboxes
for the individual assets you want to visualize in the ad-hoc analytics. If at least one checkbox is selected, the reports will ignore all other data. Therefore, be sure that only one asset is not inadvertently selected. - Set filters in the data table to reduce the amount of data that is displayed. If no checkbox is selected for an asset, all data displayed in the data table is used as the data source for the reports. Click to learn how to filter the data in the data table.
If the data workbench is filtered to show only applications that have the Recommendation attribute set to Migrate, only those applications would be displayed in the ad hoc reports like bar chart, matrix report, etc. or in a preconfigured report like Application Expenses by Cost Type.
You can export any of the visualizations to send to colleagues. You can also save any visualization except preconfigured reports and add it to the content repository. Visualizations added to the content repository can be added to any content area that you have access permissions to. The saved visualization will always show the most up-to-date data for the assets displayed in the report. For each business chart, a Show Legend button is available in the toolbar and displays a legend displaying the color-coding and other relevant information in the business chart.