The Discovery screen in the BI Toolbox is used to create and manage a visual analysis, which is the building block that is typically used to set up a BI Dashboard. A visual analysis can also be used to create an Analytics Report that is shared with other users and scheduled for distribution.
A visual analysis consists of two components: (1) user-selected hierarchy of data sets, including key fields in Conga Contracts (formerly Novatus) program screens to be analyzed, and (2) table that displays the data stored in the selected fields. A chart is typically added to the analysis to emphasize a trend in a data set over time or with respect to a monetary value. A chart can also be used to visually display the relationship between two or more elements of a data set.
The Discovery screen is divided into two sections: Data Analysis lists where Conga Contracts (formerly Novatus) data sets and fields are selected for analysis and Query Builder where charts (or tables) are created to highlight and communicate trends and relationships.
To access the Discovery screen, click Reports in the Navigation Toolbar and select the BI Toolbox link in the menu.
Data Analysis Lists View
The visual analysis in the screen shot below is seeking to identify the value of the contracts that were signed in 2010 and also identify the companies with whom the contracts were signed. Company is the first data set selected to ensure this information is displayed first in the results table. The Company Name and Company Number fields are selected since these are the only fields needed to associate a company with a final contract. Company - Contract is the second data set selected to identify the Contract Profile where the signed document is stored. Key fields are selected to identify the contract, including its Contract Number, as well as other fields that provide information on the signed document, such as its value, effective date, expiration date, and term type. Contract - Document is the third data set selected, and the Document Type field in the Document Profile screen must be included to locate only final documents. Other document fields can be selected to provide additional information, such as Document Revision Number to identify how many versions of the document were created prior to the final version.
|Visual Analysis icon||Click to display the Discovery screen.|
|Select Data lists|
|C||Field check boxes||
You will be able to apply filters to any of the selected fields.
Click to run the data analysis and display the selected fields in the Query Builder.
|E||Collapse Data Section button||Click to collapse the data section of the screen, and fully display the Query Builder.|
Query Builder View
The visual analysis in the screen shot below requires filters for two fields: (1) Document Type where the filter states the document type must contain the word Final, and (2) Effective Date where the filter states the contract's effective date must fall between 1/1/2010 and 12/31/2010. The two fields that will be used to express the desired visualization are Company Name (Y-axis) and Contract Value (X-axis) and are shown in the Visual Analysis Chart.
|Visual Analysis fields||
Verify the selected fields for the analysis contain data.
If no data displays, the visual analysis is not valid and you need to change the categories, the order in which the categories are selected, or the fields selected in a category.
Identify the fields that contain text, indicated by a blue tick mark in the top left corner of the field header.
A check box is indicated by a purple tick mark.
|C||Date fields||Identify the fields that contain a date, indicated by a gold tick mark in the top left corner of the field header.|
|D||Value field||Identify the fields that contain a value, indicated by a green tick mark in the top left corner of the field header.|
|E||Table icon||Click to display a Table Menu with options for the fields in the analysis.|
|F||Add New Column option||Click to add a blank column where a calculation can be added, such as calculating the number of days until a contract's expiration date.|
|G||Show/Hide Columns option||Click to display a window where fields can be hidden/shown, allowing the focus to be placed on the fields that need to be filtered and those needed for the chart.|
|H||CSV Export||Click to export the fields and data displayed in the screen to an Excel spreadsheet.|
|I||Sort icons||Use the icons to sort the data in a column in ascending/descending order.|
Identify the fields that have a filter applied to them, indicated by the presence of the icon.
|Field Properties icon||Click for a program field to display its Properties window.|
|L||Field Properties window||Use the options provided to filter the data in a field, add a calculation, group data in a field, format the display of data in a field, or apply colors to the chart created using the field.|
|M||Filters button||Click to display a FILTERS window with a list of filters applied to the fields in the visualization. Click to remove a filter. Edit a filter by hovering over the filter until displays, and then click the icon to display a prompt with the filter operator and value.|
Click to display the fields used in the visualization.
If you add or remove any of the original fields used in the visualization, any chart created in the Query Builder will be removed.
Visual Analysis Chart
The two fields used to express the desired visual analysis are Company Name (Y-axis) and Contract Value (X-axis) and are shown in the screen shot below. The visual analysis chart that depicts the value of contracts that were signed by customer companies in 2010.
|B||Chart field customizations||Click for a chart field to customize its display in the chart, including adding a filter, formatting, and color.|
|C||Chart field sorting||Use the icons to sort the data in a chart field in ascending/descending order.|
Zoom in on a specific section of the chart:
Click to display the EXPLORER with other viewing options for the chart:
Click to display other chart types for your data analysis:
|G||Legend icon||Click to display the Visualizations Settings prompt that allows you to select the location of the legend in the chart or remove the legend.|
|H||Trash icon||Click to delete the chart from the Query Builder.|
|I||Add To Gallery button||Click to add the visualization to the Visual Gallery.|
|J||Add Columns icon||
Click to display the Crosstab and Timeline options for a chart or table.
|K||Save button||Click to save the visualization to your Home page.|