Data Analysis is about:

• Utilizing agency specific data that accommodates your asset needs
• Efficiently and effectively assessing large volumes of asset information
• Viewing different combinations of data to enhance decision making
• Comparing data from different databases to observe trends
• Providing users with an easy to use analysis tool

• Visualize your data by charting in 2 or 3 dimensions
• Create bar, line, area, point, and stacked bar charts easily 
• Add progress bars to the grid to provide quick visual interpretation of your data
• Customize your charts and grids on a per user basis

The grid has may features for the user to configure and manipulate data for viewing.

• Order Columns - change the order of the columns to place related information side by side
• Group by Column headers - drag and drop column headers into the 'group by' area to group data by column heading

  

• Group and Column Totals - apply common mathematical functions (sum, min, max, average) to group and column footers
• Stack grid - vertically stack columns to cluster data for ease of viewing
• Fix Columns - use the fix columns option to 'fix' information on the left side of the grid while scrolling long line of information
• Grid Properties - set custom colors for the grouping hierarch
• Hide Columns - move columns that are not interest to a 'holding bin' so they are not displayed in the grid.  Move them back later when thy are required.  DataViewer remembers which are hidden and resumes the display when the view is closed and reopened
• Sort on Multiple Columns - further enhance the data display by sorting on numerous columns to arrange the data in the desired order.

Filtering Data

Use filters to display only the information you want to see.

Use extensive formatting capabilities to edit color, rotate, or change the perspective of your charts

Numerous print options are available.  Data con be printed from:

• Grid - the grid may be printed directly or exported to Excel, HTML, or a Paradox table.
• Summary or Item Chart - Printing calls a dialog box to customize the chart report.