Dynamics NAV 2015 – Harnessing the Power of Business Intelligence (BI)

by | Updated February 3, 2020 | Dynamics NAV


Right on the heels of the successful release of Dynamics NAV 2013 R2, the Microsoft development team has shifted their focus since late December 2013 and has been hard at work on the next version of Dynamics NAV, codenamed “Crete”.

Microsoft has already started gearing up the marketing machine by announcing some of the key features and technologies that will be included with the release of the product, and one of those announcements centers around BI, or more specifically, Power BI.

Power BI is a cloud-based business intelligence service that integrates with Office 365 and allows end-users to use tools commonly known in a business (Excel, SharePoint, Web/Mobile devices).  Some of the key features/services included in the Power BI solution:

  • Power Query – Allows for data connections to public and corporate data sources.
  • Power Pivot – Extends the data in Excel by adding relationships, custom measures, hierarchies, and Key Performance Indicators (KPI’s).  It also uses an in-memory technology with the generated models so that end-users can analyze millions of rows of data at lightning speed.
  • Power View – Allows for the creation of reports and views through interactive charts and graphs that allow end-users to visually explore the data captured in the Excel Power Pivot model.
  • Power Map – Allows for end-users to integrate with geospatial data to create a 3D map experience in Excel.

Power BI Public Query
Above: Power Query used to grab public information to add to a Worksheet in Excel

These new technologies allow for integration with Dynamics NAV through the use of the ODATA web services.  IT Administrators can register on-premise data sources in the Power BI Admin Center and then grant access to end-users for the feed.

At this time (end of May 2014), the feature validation phase of NAV ‘Crete’ should be concluding and in June 2014 we’re expecting a Customer Technology Preview (CTP) release that will allow for partners and customers to experiment with the new features introduced with NAV ‘Crete’.  The Stoneridge team has already started ramping up, as we feel that data visualization is a key feature of an ERP system that will no longer be a stand-alone secondary project, but integrated with the roll-out of your Microsoft Dynamics NAV solution.

We will be posting a deeper look at the BI integration later this year.  Check back then to see how you can harness this technology in your NAV deployment and the benefits and drawbacks that we have discovered to save you time and money when implementing your solution!

Related Posts


Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events


14jan11:00 am12:00 pmConfab with Stoneridge - Livestream - Looking Forward: Predictions for Technology in 2021

20jan10:00 am10:30 amThe Modern Manufacturer - Demand Forecasting Functionality

27jan12:00 pm12:45 pmFour Keys to Choosing the Best ERP or CRM Solution: Part 1 – Fit

28jan11:00 am12:00 pmConfab with Stoneridge - Livestream - Ask the Experts!


03feb10:00 am10:30 amThe Modern Manufacturer - Enterprise Asset Management

03feb12:00 pm12:45 pmFour Keys to Choosing the Best ERP or CRM Solution: Part 2 – Platform

10feb12:00 pm12:45 pmFour Keys to Choosing the Best ERP or CRM Solution: Part 3 – Implementation Partner

11feb11:00 am12:00 pmConfab with Stoneridge - Livestream - Live Agents, Power Virtual Agents, Omnichannel – Oh My!

16feb12:00 pm12:45 pmFour Keys to Choosing the Best ERP or CRM Solution: Part 4 – Cost

17feb10:00 am10:30 amThe Modern Manufacturer - Machine Maintenance Work Orders

25feb11:00 am12:00 pmConfab with Stoneridge - Livestream - Surfing Through the Dynamics 365 Wave 1 2021 Release

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!