Loading Events

« All Events

  • This event has passed.

MICROSOFT DYNAMICS NAV WITH SQL DB

27th April 2017 @ 2:00 PM - 5:30 PM

EXCEL REPORTING ON DYNAMICS NAV

This module explains how to create basic NAV reports using Excel to connect to Dynamics NAV.

 

Lessons:

  1. Plan the dashboard
  2. Create the dashboard
    – Create and save a SQL data connection
    – Create a report
    – Create a filter
    – Create a slicer
    – Create a Timeline
  3. Configure Excel Add-In
  4. Practice
  5. Useful links

 

Lab:

  1. Create and save a SQL data connection
  2. Create a report
  3. Create a filter
  4. Create a slicer
  5. Create a Timeline
  6. Configure Excel Add-in
  7. Create report to display outstanding amount by customers

 

After completing this module, students will be able to:

  1. Able to create basic dashboard by using Excel and SQL Data source.
  2. Able to create basic dashboard that contains several reports and a filter using external data connections.

 

PRE-REQUISITE

  1. Excel 2013 (and above) installed on Laptop/Notebook
  2. Dynamics NAV with SQL DB
  3. Bring your own Laptop/Notebook

For Who?

  • IT Personnels and Anyone who needs to generate basic reports

 

Details:

  • Date: 27-Apr-2017
  • Time: 2.00pm to 5:30pm
  • Venue: 20, Jalan Eco Cascadia, Taman Setia Eco Cascadia, 81100 JB

 

Register here :-

Your Name (required)

Your Position (required)

Your Company (required)

Your Email (required)

Your Contact No. (required)

Details

Date:
27th April 2017
Time:
2:00 PM - 5:30 PM

Venue