Here I will discuss how you can use OData to expose a Microsoft Dynamics NAV 2015 page as a web service and then analyse the page data using Microsoft PowerPivot for Excel 2013. With OData and PowerPivot, you gain access to a powerful set of tools and technologies for data exchange and analysis.