•

Reporting and analytics within the comfort of Microsoft Excel.
Sage 50 BI brings business data into the familiar Microsoft Excel environment allowing quick analysis of company data from many different angles. This means the features of Excel, such as ease of formatting (layout and printing), calculations and macros can all be used to enhance the reports created using Sage 50 BI.

•

Pre-defined reports out-of-the-box.
Sage 50 BI is supplied with time saving, pre defined reports allowing you to analyse and understand financial information within your Sage 50 solution. For example - Profit & Loss report, worst paying customers, average sales month on month, and Top customer.

•

Easy to understand terminology and usage.
Sage 50 BI can be used and understood by all customers regardless of your technical ability as there is no technical knowledge or pre-requisites required to use the tool.

•

Make faster, more informed and confident decisions.
Sage 50 BI provides quick and easy access to information that has not typically been available through Sage 50. The report fields can be easily changed in seconds to allow quick and easy reporting and analysis.

•

Save essential time on reporting.
Sage 50 BI provides a superior alternative to complex spreadsheet reporting with reports easy to create, from easy to access data that is automatically refreshed. Sage 50 BI gives one version of the truth and reduces the need for complex time consuming spreadsheets which require manual intervention and manipulation.

•

Easy and fast deployment.
A fast and easy tool which can be deployed across the business in a few hours with minimal disruption to your business.

•

Uses reliable Microsoft SQL Server Analysis Services.
Sage 50 BI uses SQL Server Analysis Services which is a market leading OLAP technology. Therefore Sage 50 BI is built using market leading Microsoft technology.

•

Report Wizard.
Sage 50 BI comes with a report wizard as standard. The report wizard is a powerful editing tool which provides flexibility and ease of use by enabling you to extract the information you require and display it the way you want.

•

Drill Down.
Allows the you to easily go from a summary report to detailed analysis on specific items in the report. You can drill down through increasing levels of detail or to the transaction data for more detailed analysis.

•

Change the report parameters.
Enables multi-dimensional analysis, by allowing you to quickly flick between data by changing the report to get a different view of your data and a better insight of your business.

•

Sort, Filter and subtotal functionality.
This functionality allows the data to be manipulated making it easy to view and analyse. These additional features provide additional flexibility allowing you to create the reports you require to suit your business needs.

•

Conditional Formatting.
Provides a very quick and easy method of spotting exceptions within a report by highlighting anomalies within your data, thus saving you valuable time.

•

Dynamic Charts.
Add charts to reports to give a graphical representation of the data - ideal for presentations and reporting.

•

Ad-hoc analysis via Report Layout Panel.
Provides full flexibility to create reports, which can be configured and designed specifically for your requirements.

•

Flexible layout options to produce formal reports.
Produce professional and aesthetic reports and dashboards quickly and easily - ideal for use in presentations. You can layout all forms of reports exactly as required within Microsoft Excel. You can also build dashboard reports with multiple linked queries and charts.

•

Report Sets.
Automate the creation of multiple reports to create report packs and save time on reporting.

•

Link reports.
Allows you to create a dashboard of a number of reports that can all be linked and updated together by enabling synchronisation between reports within a workbook.

•

Insert user defined rows and columns into reports.
Add additional rows or columns in a report to add additional calculations using Excel formulae to meet reporting needs. Increasing flexibility to utilise Excel functionality within a Sage BI report.

•

Named Sets.
Save time and improve reporting by creating sets specific to the business. For example, create a set for the last 6 months to quickly be able to show data for each of the previous 6 months.

•

Calculated Members.
Extend reports by creating additional calculations as required. You can define additional calculations based on existing data within a report.

•

Make faster, more informed and confident decisions.
Sage 50 Business Intelligence is an easy to use product that allows quick access to Sage 50 data. Multi dimensional analysis means that data can be easily viewed from different angles. For example sales by region, customer and month.

•

Reporting and analytics within the comfort of Microsoft Excel.
Sage 50 Business Intelligence brings business data into the familiar Microsoft Excel environment allowing quick analysis of company data from many different angles. The features of Excel, such as ease of formatting, calculations and macros can all be used to enhance the reports created using Sage 50 Business Intelligence.

•

Save essential time on reporting.
Sage 50 Business Intelligence provides a superior alternative to complex spreadsheet reporting. Providing you with one version of the truth and reducing the need for complex time consuming spreadsheets which require manual intervention and manipulation.

•

Save time with pre-defined reports out-of-the-box.
Sage 50 Business Intelligence is supplied with pre defined reports allowing you to analyse and understand financial information within their Sage 50 solution. For example - Profit & Loss report, worst paying customers and average sales month on month.

•

Easy and fast deployment.
Sage 50 Business Intelligence is a fast and easy tool to deploy across the business with minimal disruption. In the majority of cases a complete installation of Sage 50 Business Intelligence takes less than an hour from beginning the installation process to viewing the standard pre-defined reports with data.

•

Built using market leading Microsoft technology.
Sage 50 Business Intelligence uses reliable Microsoft SQL Server Analysis Services which is a market leading OLAP technology.

•

Flexible layout options.
Allowing you to produce formal reports, you have the ability to layout all forms of reports exactly as you would within Microsoft Excel, inserting new rows and columns, and formatting reports using your Excel knowledge. You can also build professional dashboard reports with multiple linked queries and charts.