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


02jun2:00 pm2:30 pmBusiness Intelligence for Batch Manufacturers

16jun10:00 am10:30 amHow AP automation can speed up month-end close in D365 Finance

17jun11:00 am12:00 pmConfab Live with Stoneridge – Real Time Marketing Strategies for Success

23jun10:00 am10:30 amThe Modern Manufacturer: Cost Accounting in D365

30jun10:00 am10:30 amAP Automation Checklist for a 2022 Rebound

30jun2:00 pm2:30 pmAchieving Success: How Technology Is Helping Nonprofits Thrive


01jul11:00 am12:00 pmConfab Live with Stoneridge – Dataverse Virtual Entities

14jul12:00 pm12:30 pmBeyond Reporting - What Business Intelligence Can Do For Your Agribusiness

15jul11:00 am12:00 pmConfab Live with Stoneridge – Integration Strategies for End User Success

21jul10:00 am10:30 amThe Modern Manufacturer: Manufacturing Software in the Real World

21jul12:00 pm1:00 pmIs it Worth it to Upgrade to Dynamics 365 Finance and Supply Chain Management? - Everything AX Users Need to Consider

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!