Skip to main content

R is for Analytics: How Microsoft Dynamics ERP and CRM users can take advantage

by Mark Anderson
Contributing Writer,

Since July, when Power BI began to support R visuals in its reports and dashboards, it's become harder and harder to justify remaining ignorant of R. The so-called "lingua franca of data science" has thousands of scripts already written and ready to be pressed into service for Power BI and Dynamics users.

Tomaž Kaštrun

For business users, there are countless use cases where R scripts can be used to solve real-world using Dynamics CRM and ERP solutions, including with Power BI, says data analyst and Microsoft MVP Tomaž Kaštrun. For example, Kaštrun recently used R to comb through millions of historical invoices taken from Dynamics NAV and identify the handful that were most likely to be fraudulent (more on that below).

Data slicing in Power BI

To understand the usefulness of R, take what might seem a simple case: data slicing. As Kaštrun blogged last month, Power BI users exploring data sets sometimes find they want to explore a subset of their data. In the case of Dynamics user, they might interested in quarterly sales results from 2014  and 2015 only, and then only in regions 2 and 3 of their sales district.

Zooming in to subsections of one's data is called data slicing. And as previously noted, R can ...

FREE Membership Required to View Full Content:

Joining gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here

About Mark Anderson

Mark Anderson is a science and technology journalist, author and copywriter. Based in western Massachusetts, he's written for many top publications and about everything from IT to genomics to energy. He recently launched a business copywriting service and is the author of two nonfiction books about science, history and literature.

More about Mark Anderson