Ad Hoc Reporting with Microsoft Dynamics NAV 2013: Microsoft Office Excel Add-in, Microsoft PowerPivot for Excel, and Jet Reports Express

I receive a lot of questions when to use what reporting tool provided in Dynamics NAV2013

There was a good item published at the msdn NAV blog

http://blogs.msdn.com/b/nav/archive/2012/08/30/ad-hoc-reporting-with-microsoft-dynamics-nav-2013-microsoft-office-excel-add-in-microsoft-powerpivot-for-excel-and-jet-reports-express.aspx

It also has some nice links to external tools currently available using ODATA:

http://shlemonz.blogspot.ca/2013/01/odata-is-on-of-new-exciting-features.html

Top 5 sql server improvements in NAV 2013

http://navigateintosuccess.com/blog/top-5-sql-server-improvements-in-nav-2013

How do I...consume a Microsoft Dynamics NAV 2013 Query from an Excel Powerview

This video will take you through a series of steps in order to consume a Microsoft Dynamics NAV 2013 Query from an Excel PowerView.

 

Upgrade NAV2009R2 Demo Database to NAV2013

The upgrade from NAV 2009 R2 to NAV 2013 involves a lot more than just running a codeunit before and after. The SQL Database is going to be changed from ANSI to UNICode, this is affecting every text filed and code in the database.
This video show the process with the standard Demo Database from W1 2009 R2. The part about upgrading customizations is a different process and is not covered in this video.


Webreference: https://www.youtube.com/watch?v=AtU22nGXO5o