O'Reilly logo

Extending Microsoft Dynamics NAV 2016 Cookbook by Alexander Drogin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Sales forecast in Power BI with R

R scripts can do more than simply render statistical plots. They are able, for example, to analyze time series and build a time series prediction based on various models.

Getting ready

Install R from https://cran.r-project.org.

You will also need the forecast R package. To install it, run your R scripting environment (for example, RStudio) and run the following command:

install.packages("forecast") 

How to do it...

For a brief introduction to R prediction capabilities, we will generate a sales forecast from NAV demo data.

  1. Run Power BI and connect to the SQL Server hosting the Dynamics NAV database. Select the table CRONUS International Ltd_$Detailed Cust_ Ledg_ Entry in the Navigator window and choose to edit the query. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required