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.
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")
For a brief introduction to R prediction capabilities, we will generate a sales forecast from NAV demo data.
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.In the query editor, click Choose Columns and select three columns for the dataset: Amount (LCY), Document Type, and Posting Date. Select the field Posting Date and change the data type of the column Date/Time to Date.
Apply a filter on the...