Business Intelligence
Sage Business Intelligence is the ultimate way to present management reports and analyses from your Sage applications. It allows financial data marts to be built “out of the box” for SOP, POP and GL modules and allows others to be added through customisation by Sage partners or through your own internal skills. Once created, these data marts form the base from which powerful reporting applications can be easily created from within Excel using the Sage Business Intelligence Excel addin. These applications can then be deployed via Excel or optionally published as fully interactive applications over the web using the Sage Business Intelligence Web Server.
The Sage Business Intelligence suite includes:
Sage Business Intelligence Solution Builder
This piece of software connects to your Line 500 database to build the Sage Business Intelligence data marts or cubes without requiring any knowledge of the underlying technology. You simply tell it how you would like to analyse your business from a reporting perspective e.g by customer, supplier, product etc and all the underlying connections are made for you.
Sage Business Intelligence Data Import Manager
Once the data cubes have been created, the Data Import Manager loads the data directly from Line 500. Complete or partial updates can be easily initiated and scheduled. There are no restrictions on historical data, so comparisons can be made over 5 or more years, when trending financial data.
SageBI Report Structure Manager
Your General Ledger stores all the account codes, however from a reporting perspective you may wish to roll sets of account codes into higher levels to simplify and optimise analysis and drill down paths. The SageBI Report Structure Manager makes such tasks trivial and the results update the data cubes easily to provide a far richer reporting experience.
Sage Business Intelligence Excel Client
The Sage Business Intelligence Excel client makes reporting and analysis of Line 500 data cubes simple yet extremely powerful. Standard Profit & Loss and Balance Sheet reports with Drill Down and Drill Across functionality can be created in minutes, along with exception reports such as who are my best performing or worst performing products / customers. Trend charts can easily be added to highlight positions over a 12 month or multi year comparison. Finally, analysts can use powerful advanced features such as ad hoc slicing and dicing of the data to examine exceptions in more detail and to determine root causes of good or adverse business performance.
Sage Business Intelligence Web Server
Once reports have been created in the Sage Business Intelligence Excel client, these reports can be simply published to the Sage Business Intelligence Web Server, allowing users to access the reports (including all formatting and any calculations added in Excel) from the simplicity of a standard web browser. For truly mobile users, these reports can optionally be accessed from a Pocket Windows based SmartPhone or PDA, facilitating true analytics on the move.
