Business Intelligence – Sage 300 ERP
Business Intelligence is a shift in focus from collecting data and generating reports to presenting information in such a way as to enable users of information systems to do their jobs more efficiently. We start with the question, “What Information is Needed by Who and When?” rather than asking what data do we want to collect and then figuring out who might find use for this data.
Sage 300 ERP Intelligence empowers you to quickly and easily obtain the information you need for operations and strategic planning. Using a familiar business application, Microsoft®Excel®, effectively analyze Sage 300 ERP and business critical information. Effortlessly create real-time, automated, and preformatted reports with up-to-date, accurate, and meaningful information. Intelligence allows you to spend more time focusing on analysis and interpretation and less time pulling the data together. Improve the productivity of your financial staff, enhance report presentation, and streamline report preparation. Build your Intelligence solution so it works the way you want, using the flexibility of Intelligence licenses and modules.
The Report Manager allows you to author new reports (organizing, creating, editing), as well as filter and aggregate data. This tool also allows you to set permissions and security for reports.
This tool provides you with basic editing capabilities (filtering and changing of parameters) and drill-down functionality on existing reports/templates. You can provide Report Viewer licenses to staff members who do not need to create new reports.
The Report Designer expands upon the functionality of the Report Manager to provide simplified “drag and drop” report creation capabilities.
The Connector Module further simplifies financial managers’ day-to-day operational tasks, allowing access to the information they need from multiple sources and consolidation of data from multiple companies. The Connector Module allows for consolidations and connectivity to unlimited ODBC data sources.
Support business strategy and decision making through advanced analysis of trends and what-if scenarios. The Analysis Module lets you utilize built-in Microsoft Excel Pivot Tables to get insight into information that goes beyond transactional data. Use the Analysis Module to create OLAP cubes, which enable multidimensional analysis of your data.