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

By Scott Frappier | May 27, 2014

Dynamics nav 2015 – harnessing the power of business intelligence (bi)

 

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

Recommended Reading:

5.13.22 Power Platform

Using Power BI Object Level Security

  The following article will demonstrate how to use Power BI Object Level Security to disable column data based on […]

Read the Article
5.12.22 Dynamics CRM

How to Use the Stoneridge Support Portal

Stoneridge Software’s support portal is an intuitive and useful function that makes it easy for you to access resources to […]

Read the Article
5.6.22 Dynamics GP

Dynamics GP Transaction Removal: Purchase Orders

  Are you having performance issues with Purchase Orders?  Do you find that there are old Purchase Orders on your […]

Read the Article
5.5.22 Dynamics GP

The Real Story about the Long-Term Future of Dynamics GP Support

I’ve seen a number of people put forward comment that Dynamics GP is going away and you have to get […]

Read the Article

New Features in Dynamics 365 Business Central 2022 Wave 1 Release Part 3 – Financial Enhancements

The Dynamics 365 Businses Central 2022 Wave 1 Release has a lot of new and exciting features to help your […]

Read the Article
4.29.22 Dynamics GP

Dynamics GP Transaction Removals: Bank Reconciliation

  This is part 2 of a 3 part series on Dynamics GP Transaction Removals. These quick tips will hopefully […]

Read the Article
4.28.22 Dynamics GP

Uncommonly Used Features – Integrate Purchasing and Payables to Fixed Assets in Dynamics GP

Being able to integrate Purchasing and Payables to Fixed Assets in Dynamics GP will help you create visibility for your […]

Read the Article

New Features in the Dynamics 365 Business Central 2022 Wave 1 Release Part 2 – Ease-of-Use Features

  There are many new features in the Dynamics 365 Business Central 2022 Wave 1 Release to get excited about! […]

Read the Article
4.22.22 Dynamics GP

Dynamics GP Transaction Removal Series: Receivables

  This is part 1 of a 3 part series on Dynamics GP Transaction Removal. These quick tips will hopefully […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X