AI and Business Rule Engines for Excel Power Users
This book helps you progress to the next generation of Excel tools, using Business Rules, Decision Services, and AI to automate mundane tasks and build more robust solutions. With the help of this book, you’ll be able to integrate tools such as Kogito, KIE, Drools, Office Script, Power Query, Power Automate, Microsoft Forms, and VBA to build end-to-end OpenShift and Azure cloud-based solutions.
Offered by
Difficulty Level
Intermediate
Completion Time
12h52m
Language
English
About Book
Who Is This Book For?
This book is for Excel power users, business users, and business analysts looking for a tool to capture their knowledge and deploy it as part of enterprise-grade systems. Working proficiency with MS Excel is required. Basic knowledge of web technologies and scripting would be an added advantage.
AI and Business Rule Engines for Excel Power Users
- About Book
- Who Is This Book For?
- Book Content
Book content
chapters • 12h52m total length
Wrestling with Excel? You Are Not Alone
Choosing an AI and Business Rules Engine – Why Drools and KIE?
Your First Business Rule with the Online KIE Sandbox
More Decision Models, Business Rules, and Decision Tables
Sharing and Deploying Decision Models Using OpenShift and GitHub
Calling Business Rules from Excel Using Power Query
Using Business Rules in Excel with Visual Basic, Script Lab, or Office Scripts
Using AI and Decision Services Within Power Automate Workflows
Advanced Expressions, Decision Models, and Testing
Scaling Rules in Business Central with Docker and the Cloud
Rules-Based AI and Machine Learning AI – Combining the Best of Both
What Next? A Look inside Neural Networks, Enterprise Projects, Advanced Rules, and the Rule Engine
Appendix A, Introduction to Visual Basic for Applications
Appendix B, Testing Using VSCode, Azure, and GitHub Codespaces
Appendix C, Troubleshooting Docker
Related Resources
Access Ready-to-Use Books for Free!
Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!