<< Click to Display Table of Contents >> Navigation: »No topics above this level« Data Analyzer |
Overview
Whereas Standard Reports are pre made, designed to satisfy most fundamental reporting requirements. Data Analyzer is a unique and innovative tool that allows you to redefine the way you view your data. By being able to define new relationships instantly against large volumes of data, you now have unprecedented freedom in creating virtually any report. What was traditionally a painful task (if at all even possible) is now quick and easy.
Data Analyzer is a tool used for retrieving and displaying huge amounts of data in a summarized and tabulated form that aids you in drawing accurate conclusions. Data Analyzer is n-dimensional and is only limited by the available resources of the operating environment. This data is pulled from the Worksheets, tabulated, summarized and presented to you in a multi-dimensional data model. You may then manipulate the data view, move dimensions, change the order, add or subtract fields, and change calculation parameters and aggregate functions to better answer your analysis needs. Once you have manipulated the data in a view you desire, you may instantly generate Graphs for any or all of the data in various ways.
Here is a simple example of data represented in a traditional table view. Suppose we are evaluating four practitioners (1-4), against two specific Criterion. Here is how your table view would look:
Practitioner |
Criterion |
Value (Yes, No) |
Practitioner 1 |
Criterion 1 |
Yes |
Practitioner 1 |
Criterion 2 |
Yes |
Practitioner 2 |
Criterion 1 |
Yes |
Practitioner 2 |
Criterion 2 |
No |
Practitioner 3 |
Criterion 1 |
Yes |
Practitioner 3 |
Criterion 2 |
No |
Practitioner 4 |
Criterion 1 |
Yes |
Practitioner 4 |
Criterion 2 |
No |
The data above is a two dimensional view, one dimension is practitioner and the other is the Criterion under which they are being evaluated. Data Analyzer view provides a simpler and better focus on data than the above relational representation. An expanded view could show row and column totals providing a quick summary by practitioner and Criterion.
Practitioner |
Criterion 1 |
Criterion 2 |
Percentage |
Practitioner 1 |
Yes |
Yes |
100 |
Practitioner 2 |
Yes |
No |
50 |
Practitioner 3 |
Yes |
No |
50 |
Practitioner 4 |
Yes |
No |
50 |
Data Analyzer can be expanded to include more dimensions and more summary information. For example, additional dimensions might mean grouping the practitioners under their respective departments, and the Criterion under quarterly or monthly ranges. Additional summary information might include the total Criterion opportunities, positive and negative compliance percentages, and more. While the traditional table views that would represent this data would become unwieldy quickly, Data Analyzer will continue to provide quick and easy ways to view and analyze your data, regardless of the number of dimensions.
Data Analyzer tools provide decision support information in a flexible format that you can manipulate and modify according to your analytical needs. Think n dimensionally!
Data Analyzer may be run under the context of a Review Template where the data included would be for that Review Template only, or it may be run under the Global context, where you have the option of choosing one or more Review Template and Topics to include.
Criterion displayed in the cube are controlled by the filter as set in the Topic Editor. To understand what Criterion will be displayed read Topics And Criterion.
Steps:
To generate a Data Analyzer cube from the Folder Items list choose the Review Template or Global->Analyze->and then choose (Default). This will prompt you with a Data Analyzer Parameters dialog where you can specify the selection criterion for the cube. If you would be using the same filter options again and again, you can create an Analyzer Template.
Once the data analyzer cube has been generated:
▪It can be managed by understanding the Data Analyzer Work Area.
▪To learn about how to print a cube choose Printing Data Analyzer.
▪To learn about how to export a cube choose Exporting Data Analyzer.
▪Data Analyzer cube can be saved for future reference. Learn about it at Saving And Recalling.
▪Data from the cube can be used to generate Graphs.