Microsoft Dynamics GP Business Intelligence Features

Role-tailored information:

• Microsoft Dynamics GP features personalised dashboards and KPIs (including charts, graphs, and gauges) with full drill-down views to record source
• Library of over 90 built-in Microsoft SQL Server Reporting Services and 220 Excel reports – helping users present information targeted at specific audiences
• Integrated SharePoint technology – Access data residing in Microsoft Dynamics GP through Microsoft SharePoint allowing non-core GP users to access and share key data and reports

Extended Information Access:

• SQL Server Reporting Services Reports deployed to SharePoint Server makes for a centralised Web-based source for viewing consolidated resources
• Easy to use Action Panes and List Pages – connect multiple data sources (e.g. from ISV applications or custom fields)
• Enhanced Web Services enable tailored information access and delivery to meet specific user and business needs such as connecting to a website or other external systems
• SQL Server Views – simplified data retrieval and report creation: easily create custom SQL Server views linking data from Microsoft Dynamics GP, ISV applications or other external systems.

Enquiries & Reporting with now even tighter integration to Excel

• Business Alerts – automatic notifications about business (database level) changes via e-mail or via Dynamics GP. For example, change of supplier bank account details.
• SmartLists - a simple but powerful reporting tool to enabling users to instantly create sophisticated queries to report on data held throughout Dynamics GP including customers, suppliers, inventory items,employee records, general ledger accounts or transactional data.
• SmartList Builder - build customised SmartLists that quickly link to Dynamics GP and other data sources.
• SQL Server Report Builder - easily create new reports or modify the chart, key performance indicator, and report formats included in Dynamics GP, without the need for developer or I.T. resource assistance.
• Excel Report Builder - create refreshable Excel reports from multiple sources of data, including ISV and custom applications, as well as data from multiple companies, with the ability to filter for selected companies.
• Over 220 built-in Excel reports -refreshed with a single click and accessed via Dynamics GP, a network file share, or a SharePoint Server site.
• PivotTable views and automatic report totals (generated with Excel Report Builder).
• Drill Down Builder - quickly define drill-down location in Dynamics GP, and then embed the field into Word documents, Outlook e-mail messages, Excel and SQL Server Reporting Services reports, and SharePoint pages – makes it easier to retrieve and share data from any module, window, or ISV application.
• Analysis Cubes for Microsoft Dynamics GP and Analysis Cubes Library - Wizard driven reporting tool allowing employees analyse information from multiple dimensions using a pivot table type approach.

Planning, Budgeting & Forecasting

• Microsoft Forecaster for Microsoft Dynamics GP – for simplified, template-driven planning and budgeting.
• Management Reporter to create boardroom reports, such as balance sheets, income statements and cash flows (download our article on how this improves on its predecessor software – FRx).
• Built-in SQL Server data mining tools - perform advanced analytics in Excel, including “what-if” scenarios and predictive modeling and forecasting.