6
Calling Business Rules from Excel Using Power Query
In the previous chapter, we looked at how we could collaborate to share and edit our decision models. We also saw how to deploy them onto the OpenShift cloud so that other people could run them through an automatically generated web interface.
That was very impressive, but our colleagues are still likely to be doing most of their work using Microsoft Excel. How can we link our business rules, AI, and decision models to Excel and make all the tools work together? That’s what this chapter covers, including the following:
- Five different ways to link rules, AI, decision models, and Excel – using Power Query, Visual Basic for Applications, Script Lab, Office Scripts, and Power Automate
- Machine-readable ...
Get AI and Business Rule Engines for Excel Power Users now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
