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

0 Comments

Submit a Comment

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

Upcoming Events

october

07oct12:00 pm1:00 pmThe Three Paths to Business Central from Dynamics GP

08oct11:00 am12:00 pmConfab with Stoneridge - Livestream - The Vision and Strategy of Microsoft Business Systems

14oct10:00 am10:30 amThe Modern Manufacturer - Managing Complex Cost Modeling

14oct12:00 pm12:30 pmGenerating Custom Inspection or Process Forms

19octAll Day22Stoneridge Connect Fall 2020

22oct11:00 am12:00 pmConfab with Stoneridge - Livestream - Stoneridge Connect Recap

28oct10:00 am10:30 amThe Modern Manufacturer - Engineering Change Management: Introduction of NEW Functionality for Manufacturers Using Dynamics 365

november

18nov10:00 am10:30 amThe Modern Manufacturer - Tears and Trauma of MRP

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!

X