Analytics 200
Overview
Analytics 200 provides numerous built-in features that enable you to perform various data analysis tasks. Below is a list of essential features offered.
Data-Related Features
1. Connect and process data from your Sage 200 Database
2. Load and process data from XML file
3. Connect to SQL Server OLAP cubes i.e. Sage Business Intelligence cubes.
4. Automatic summary calculation for each cell. There are a variety of summary functions available: Sum, Count, Min, Max, Average, Variation based upon a sample and Variation based upon the entire population.
5. Summary display modes. Instead of raw summary values, it's possible to show how the calculated values correlate to values in other cells. For instance, you can display the percentage of the totals and grand totals or the absolute or percentage difference between the current and preceding cells.
6. Any number of data fields. This feature allows you to calculate and display multiple summaries at the intersection of each column and row.
7. Automatic Total calculation. Totals (which are inserted as additional rows or columns) display total summaries calculated for outer column and row fields.
8. Automatic Grand Total calculation. Grand Totals display overall summary totals calculated against all the columns and rows. They are displayed as the bottommost rows or rightmost columns.
9. Multiple Totals. It's possible to calculate multiple Totals for specific column and row fields.
10. Grouping values into intervals. The values of column and row fields can be grouped into intervals. In this case multiple field values which have a specific matching value part will be congregated into a single item. For text fields, you can group values alphabetically (by the first character the values start with). For fields that display date/time data the values can be grouped by years, quarterly intervals, months, etc.
11. Multiple fields can be bound to the same data source field.
12. Filtering data. This feature enables you to limit which records are processed. An end-user can easily change the filter at runtime via the filter dropdown list, a filter editor or when connecting to databases, apply a filter to the SQL statement.
13. Automatic sorting of column and row field values in alphabetical order (for text data) and in order of magnitude (for numeric and date/time data). An end-user can change a field's sort order (from ascending to descending and vice versa) by clicking the field header.
14. Sorting by summary values. Allows column and row field values to be sorted by total summary values.
15. The Top N Values feature. Along with the sorting by summary, it allows you to display the specified number of topmost values, therefore showing the most important information and ignoring the rest.
16. View the records used that were used in calculating the displayed cell value.
Layout Features
1. Any number of column and row fields. The values of column and row fields are listed along the top and right edge of the control and they identify the column and row headers. The values of multiple column (row) fields are arranged into a hierarchy, and can be expanded or collapsed.
2. Cell selection and copying to clipboard. An end-user can select a range of cells with the mouse, and then copy their contents by pressing the CTRL+C shortcut. The selected data is copied to the clipboard in the tab-separated format natively supported, for example, by Microsoft Excel.
3. Dragging fields between different areas. End-users can freely drag field headers between different control areas. This gives them full control when analysing the data.
4. Allows end-users to temporarily hide fields and make them visible again.
5. Built-in context menus provide access to the most commonly used features.
6. Save the layout and data retrieval elements allowing it to be re-loaded at a later date or distributed to other users.
7. Style conditions give you a simple and flexible method of altering the font or colour of a cells depending upon the cell's data.
General Features
1. Create new analysis models via wizards.
2. Access and alter a field's grouping or summary properties.
3. Add new custom fields using the field wizard.
4. Create custom fields whose value is calculated using and expressions and/or references other fields.
5. Print support - the contents of the grids can be printed or exported to various print formats.
6. Charting. Pictures speak louder than words, chart your data by simply selecting the range of cells you wish to portray.
7. Choose from a variety of different 2D and 3D chart types to present your data, Bar, Line, Area, Scatter, Pie, Doughnut and much more.
8. Alter the layout, titles, labels, colour of your chats, 3D axis using a chart wizard.
9. Export the displayed grid to HTML, XML, TXT, XLS (Excel) and PDF formats.
10. Export the charts grid to various image formats, Bitmap, JPEG, GIF.
11. View all the data retrieved and being used to calculate the displayed values.
12. View the data being used to calculate individual cell values.
To view brochure please click here
