BI and Reporting

Power BI DashboardThe global ERP NAV provides several ways of accessing to simple reports or reporting tools, based on its data.

Totally embedded within NAV, the Query Generator, with the NAV Dasboards, allow to clearly monitor and fastly steer your company activity. For more complex or specific analysis, NAV data can be naturally exported to Excel and then used to create ad-hoc tables or reports.

Power BISince the NAV 2009 version, NAV is provided with a rich and scalable reporting tool : Jet Reports. Totally embedded within Excel, Jet Reports allows its users to have and esay and reliable access to ERP data, and use it within Excel (through its traditional features : tables, pivot tables, reports draw up, macros, graphs, filters…).

An additional way of analyzing data and creating reports is provided by the use of Power BI, a solution connected to NAV and able to provide predifined reports, and a natural language query tool.

Finally, as NAV is based  on Microsoft SQL Server, it is easy to setup and run BI and datawarehouse features of Microsoft SQL Server Analysis and Reporting Services.

More information on the Microsoft Business Intelligence for NAV brochure (En anglais) :Whitepaper - NAV2016 and BI

BI Functions of Microsoft Dynamics NAV :

  • Roles based dashboards

  • Ad hoc reports

  • Integrated with Jet Reports Express

  • DataWareHouse management

  • Data access based on rights per roles

  • Export toward Microsoft Office solutions

  • Integrated with SQL Server Analysis and Reporting Services



Nos clients sont meilleurs ambassadeurs :

  • We have selected Microsoft Dynamics NAV as our Local Subsidiaries’ Group Core Model, also as an alternative to our Tier-1 Central. Dynamics NAV is currently implemented within 25+ countries and will cover 40+ at the end of the project.

  • The technical platform of Microsoft Dynamics NAV allows us to import easily and efficiently an important volume of data on a daily basis coming from our multi-countries and multi-currencies e-Commerce website.

  • The high involvement and commitment of Dynamics International resources on our Dynamics NAV project has allowed us to efficiently implement the Group solution within our 13 local subsidiaries. It helped managing each country’s specific activities (bookkeeping/finance) through a direct interface with our Group internal business solution.

  • Microsoft Dynamics NAV Bookkeeping and Finance functions have convinced us of the relevance of this ERP solution regarding our international context. The solution efficiency allowed us to keep a cost effective team size at Finance Department level, in order to manage the growth of our 35 countries subsidiaries.