DC020 - PowerPivot and NAV Training Course
Business Intelligence reporting is important in any company, and NAV’s integration with Microsoft Office is the perfect platform for this. In the PowerPivot and NAV Course you will learn how to expose NAV data to Power Pivot using NAV Queries and Web Services and to use PowerPivot to analyse your data into helpful pivot tables and charts. The PowerPivot and NAV course is useful for anyone wanting to learn how to use PowerPivot, not just NAV users and can be extended for reporting on other applications.
The following is a list of the subjects covered in the course.
- Dynamics NAV Connections
- What are the Different Power Add-Ins
- Importing Your Data and the Data Model
- Creating a Data Table
- Creating PivotTables with PowerPivot
- Creating Simple Calculated Columns
- Using Slicers to Filter Data
- Using PivotCharts and Dashboards
- Using PowerView and PowerMap
Must have a good working knowledge of Dynamics NAV and Microsoft Excel. The course will be conducted in NAV 2017 and Excel 2016.
Our scheduled training courses are £250.00 per person per day. If you are coming to our site, parking and refreshments will be provided.
Terms & Conditions
For details on what to expect, dress code and general terms and conditions, please see our standard training T&Cs.
Please fill in the following form to book onto this course.