Businesses need robust analytic tools to turn information into forward-thinking insight, such as the insight needed to change the direction of a negative trend or take advantage of a positive trend. Microsoft Dynamics NAV provides simple but powerful analysis and reporting tools that enable this kind of business intelligence. Examples of Ad-Hoc Query and Analysis Business Intelligence features in Dynamics NAV include:
Account schedules
Analyze data from the General Ledger, Sales and Purchase, and Inventory. Compare data to budgets across time, departments, projects, campaigns, and other dimensions. The easily defined line and column layout provides users with a comprehensive and tabular form of analysis. Results can be presented in print, in a window from which users can easily navigate to original entries and documents, and/or in Microsoft Office Excel for further processing.
Analysis views
Gain a comprehensive understanding of the business and its activities with this multilevel and multidimensional business insight capability. Create analysis views for different purposes. For example, users can see an analysis view relating to sales in a particular area for a particular time period and for a particular group of customers. The views can easily be sent to Microsoft Office Excel, where the automatic creation of relevant PivotTable® views enables users to drag fields and use additional measures, dimensions and criteria.
Power BI
Power BI for Office 365, a self-service business intelligence solution delivered through Excel and Office 365. Use OData and Queries in Microsoft Dynamics NAV for easy integration into Microsoft Excel for leveraging the tools in the PowerBI suite like PowerPivot, PowerView, PowerMaps and PowerBI.com
In Microsoft Dynamics NAV 2016 you can connect to your instance of NAV and PowerBI.com and get immediately access to a business performance Dashboard with insights into your business. The new PowerBI.com Content Pack for Microsoft Dynamics NAV is designed specifically for SMB owners, managers and executives to provide details on customers, sales and finance.
The dashboard and reports are built on top of a fully featured model, allowing you to explore and analyze your data as you need. Automatic refresh will ensure you’re always seeing the latest data.
Jet Reports Express
Through easier ad-hoc reporting, you can get the answers you need to questions about your business – from finance and sales queries to key performance metrics. Use the intuitive interface of Jet Reports Express and simple formulas in Microsoft Office Excel to create high-impact reports. Take advantage of the multiple report templates available out of the box and present your findings in a single, well-formatted report.
Table Builder
Answer and analyze ad-hoc business queries quickly and accurately in Microsoft Office Excel with real time data from Microsoft Dynamics NAV by using Table Builder. Access and combine all the data you need from your business system – including tables, fields, flow fields and dimensions. Slice and dice data and consolidate information and analysis across companies or databases. With just one click, you can drill down into any value in a report to see the underlying data.
General Ledger function
Allows you to report from all areas of their general ledger and do Financial reporting within a familiar and flexible environment.
Report Player
You can also use the Report Player to get fast access to your reports in Microsoft Office Excel as well as get a quick overview of progress or latest’s update right on your desktop. Go to the Windows 8 app store to download the app.
MANAGEMENT CAN:
√ Track consolidated profit and loss by division and company.
FINANCE CAN:
√ Stay on top of account receivables KPI’s in terms of days outstanding, past collection performance and more.
SALES CAN:
√ Easily build product sheets that pull current pricing and specifications, and instantly update and release important changes.
Get more information on Better ERP Ad-Hoc Query and Analysis
Learn more about all the Features of Microsoft Dynamics NAV
