Management Reporting with Navision BI out of the box solution

Implementation of "Navision BI out of the box" solution for finance domains (General Ledger, Analytical Ledger, Accounts Payable, Accounts Receivable). Katoen Natie was moving from Navision 4.0 to Business Central and wanted to have reports including data from Business Central as well as historical data from Navision. A data warehouse was set up reading data from NAV and Business Central from over 100 companies.

The Microsoft BI components which were used, are:
  • Master Data Services for the management of general ledger accounts and grouping of reporting hierarchies
  • Tabular model for the performant and in memory reporting in Excel, Paginated reports and Microsoft Power BI
  • Reporting services to deliver pixel-perfect reports to financial controllers worldwide
  • Integration services and BIML for ETL DW automation