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

Statistical data analysis in Power BI with R

R is a software environment for data mining, statistical analysis, and data presentation. It is widely used in statistical applications for sophisticated modeling and data mining solutions. R scripts can be executed in Power BI with the NAV database as the data source for computations.

Getting ready

The R environment must be installed for this demo. Download and install R from https://cran.r-project.org.

For a detailed description of how to connect to the Dynamics NAV database with Power Query, remove the columns from the dataset and change the column data type, refer to the recipe Retrieving data from NAV with Power Query.

How to do it...

In this recipe, we will use R to build a box plot based on expenses ...

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