Monday, November 19, 2018

Custom JavaScript Functions and Power BI visualizations in Microsoft Excel

Did you know that Microsoft Excel supports custom JavaScript functions and Azure Machine Learning? The famous spreadsheet allows Power BI developers to export the custom visualizations from Power BI to Excel. The combination of these features enables developers to use their line-of-service apps to Excel. Deevita also delivers similar business intelligence solutions to benefit developers in the field of data reporting. 

Programmers can also write scripts with Visual Basic for Applications (VBA). Using JavaScript has some advantages, although not popular. One of them is the ability to connect to third-party services. And, the functions can also run on any platform. 

Thanks to the support from Azure Machine Learning, Excel users can apply the Machine Learning (ML) models of the organization. Building the ML models still dwells with the hands of computer science. But, with the current capabilities many users can consume those models easily. Considering that Excel is the most preferred platform for data exchange, integrating the ML models enhances productivity.

No comments:

Post a Comment