Microsoft SQL Server Business Intelligence
Your SQL server not only holds the database service but also powerful reporting tools, e.g., Analysis and reporting services.
Doing all your reporting in your NAV database has surely the advantage of getting online data, however if you have a significant amount of historical data or users, the reporting requests can put a stress on your database and deteriorate performance for all users in their daily tasks. As NAV is design to retain all historical data, this can occur overtime.
Instead Microsoft Analysis services can be used to pre-process the data overnight and answer reporting requested lightning fast. Microsoft excel can be directly used to interrogate Analysis Services. Else, nice and tidy pre-formated reports can be designed, published in your intranet or automatically by email by using Microsoft reporting services.
We combine experience in SQL server technologies and in the Dynamics NAV database structure to provide you with cost effective solutions. Current ready to use cubes in Analysis services cover the most used areas:
- Sales
- General Ledger
- Stock
- Purchase
Doing all your reporting in your NAV database has surely the advantage of getting online data, however if you have a significant amount of historical data or users, the reporting requests can put a stress on your database and deteriorate performance for all users in their daily tasks. As NAV is design to retain all historical data, this can occur overtime.
Instead Microsoft Analysis services can be used to pre-process the data overnight and answer reporting requested lightning fast. Microsoft excel can be directly used to interrogate Analysis Services. Else, nice and tidy pre-formated reports can be designed, published in your intranet or automatically by email by using Microsoft reporting services.
We combine experience in SQL server technologies and in the Dynamics NAV database structure to provide you with cost effective solutions. Current ready to use cubes in Analysis services cover the most used areas:
- Sales
- General Ledger
- Stock
- Purchase