Analytics 200 is a lightweight tool for organising and analysing your business data. The application's main functionality lies in its ability and ease of use in summarising information, represented in a cross-tabulated form, and to chart, print or export the values displayed. It connects to your Sage database allowing you to retrieve data you require from any table and present it in a manner that produces the key information you seek.
Its functionality is provided via Grids and Pivot Tables often found in applications such as Microsoft Access or Microsoft Excel, to convert lengthy table data into compact summarised reports based on fields placed in columns and rows. The layout can be easily customised by the user by dragging and dropping fields into various area column, row or data areas to achieve the desired layout. Display data can then be filtered, re-arranged, printed or even charted by simply highlighting those cell values you wish to diagram. For instance, query the sales order tables to analyse sales during specific periods (years, quarterly intervals, months) for each customer and/or each product category, or without having to start from fresh, change the column layouts to display the top 10 customers by items purchased. Other examples include a report that displays the most or least popular products, grids displaying products stock levels per location whilst highlighting those below the re-order level, create an aged debtors report based on your preferred period gaps, or compare sales or return figures to the previous year or month. An end-user can easily alter the layout to display the information they need in the way they need it. Analytics 200 is therefore the best tool to quickly create and query financial and statistical reports on your system data.
Sage 200 Business Intelligence (BI) provides powerful analysis and reporting which will transform data into meaningful intelligence. Critical management decisions can be made on complete, accurate information which is easily extracted.View Details