AI and Business Rule Engines for Excel Power Users: Capture and scale your business knowledge into the cloud - with Microsoft 365, Decision Models, an

A power-packed manual to enhance your decision-making with the application of Business Rules using KIE, Drools, Kogito, MS Excel, Power Automate, Office Script, and MS Forms

Purchase of the print or Kindle book includes a free PDF eBook

Key Features

• Explore the business rule tools by implementing real-world examples to write sophisticated rules
• Discover how decision services solve current business challenges using AI
• Combine rules with workflows and scripting to deploy a cloud-based production environment

Book Description

Microsoft Excel is widely adopted across diverse industries, but Excel Power Users often encounter limitations such as complex formulas, obscure business knowledge, and errors from using outdated sheets. They need a better enterprise-level solution, and this book introduces Business rules combined with the power of AI to tackle the limitations of Excel.

This guide will give you a roadmap to link KIE (an industry-standard open-source application) to Microsoft's business process automation tools, such as Power Automate, Power Query, Office Script, Forms, VBA, Script Lab, and GitHub. You'll dive into the graphical Decision Modeling standard including decision tables, FEEL expressions, and advanced business rule editing and testing.

By the end of the book, you'll be able to share your business knowledge as graphical models, deploy and execute these models in the cloud (with Azure and OpenShift), link them back to Excel, and then execute them as an end-to-end solution removing human intervention. You'll be equipped to solve your Excel queries and start using the next generation of Microsoft Office tools.

What you will learn

• Use KIE and Drools decision services to write AI-based business rules
• Link Business Rules to Excel using Power Query, Script Lab, Office Script, and VBA
• Build an end-to-end workflow with Microsoft Power Automate and Forms while integrating it with Excel and Kogito
• Collaborate on and deploy your decision models using OpenShift, Azure, and GitHub
• Discover advanced editing using the graphical Decision Model Notation (DMN) and testing tools
• Use Kogito to combine AI solutions with Excel

Who this book is 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.

一本充滿力量的手冊，以KIE、Drools、Kogito、MS Excel、Power Automate、Office Script和MS Forms應用商業規則來增強您的決策能力。

購買印刷版或Kindle電子書，將包含免費的PDF電子書。

主要特點：

- 通過實施真實世界的示例來探索商業規則工具，撰寫複雜的規則。
- 了解決AI的方式，通過決策服務解決當前的業務挑戰。
- 將規則與工作流和腳本結合起來，部署基於雲的生產環境。

書籍描述：

Microsoft Excel在各個行業被廣泛採用，但Excel高級用戶常常遇到諸如複雜公式、模糊的業務知識和使用過時表格而產生的錯誤等限制。他們需要更好的企業級解決方案，本書介紹了將商業規則與AI的力量結合起來解決Excel的限制。

本指南將為您提供一個路線圖，將KIE（一個行業標準的開源應用程序）與Microsoft的業務流程自動化工具（如Power Automate、Power Query、Office Script、Forms、VBA、Script Lab和GitHub）相連接。您將深入研究圖形化的決策建模標準，包括決策表、FEEL表達式和高級商業規則編輯和測試。

通過本書，您將能夠將您的業務知識作為圖形模型共享，將這些模型部署並在雲端執行（使用Azure和OpenShift），將它們與Excel相連接，然後作為一個端到端解決方案執行，消除人為干預。您將具備解決Excel問題並開始使用下一代Microsoft Office工具的能力。

您將學到什麼：

- 使用KIE和Drools決策服務撰寫基於AI的商業規則。
- 使用Power Query、Script Lab、Office Script和VBA將商業規則與Excel相連接。
- 使用Microsoft Power Automate和Forms構建端到端工作流，並將其與Excel和Kogito集成。
- 在OpenShift、Azure和GitHub上協作和部署您的決策模型。
- 使用圖形化的決策模型表示法（DMN）和測試工具進行高級編輯。
- 使用Kogito將AI解決方案與Excel結合。

本書適合對Excel有經驗的高級用戶、業務用戶和業務分析師，他們正在尋找一種工具來捕捉他們的知識並將其部署為企業級系統的一部分。需要具備MS Excel的工作熟練能力，對Web技術和腳本有基本的了解將是一個額外的優勢。

1. Wrestling with Excel? You Are Not Alone
2. Choosing an AI and Business Rules Engine – Why Drools and KIE?
3. Your First Business Rule with the Online KIE Sandbox
4. More Decision Models, Business Rules, and Decision Tables
5. Sharing and Deploying Decision Models Using OpenShift and GitHub
6. Calling Business Rules from Excel Using Power Query
7. Using Business Rules in Excel with Visual Basic, Script Lab, or Office Scripts
8. Using AI and Decision Services Within Power Automate Workflows
9. Advanced Expressions, Decision Models, and Testing
10. Scaling Rules in Business Central with Docker and the Cloud
11. Rules-Based AI and Machine Learning AI – Combining the Best of Both
12. What Next? A Look inside Neural Networks, Enterprise Projects, Advanced Rules, and the Rule Engine
13. Appendix A, Introduction to Visual Basic for Applications
14. Appendix B, Testing Using VSCode, Azure, and GitHub Codespaces
15. Appendix C, Troubleshooting Docker

1. 與Excel搏鬥？你並不孤單
2. 選擇AI和商業規則引擎 - 為什麼選擇Drools和KIE？
3. 在線KIE沙盒中的第一個商業規則
4. 更多的決策模型、商業規則和決策表
5. 使用OpenShift和GitHub共享和部署決策模型
6. 使用Power Query從Excel中調用商業規則
7. 在Excel中使用Visual Basic、Script Lab或Office Scripts的商業規則
8. 在Power Automate工作流程中使用AI和決策服務
9. 高級表達式、決策模型和測試
10. 使用Docker和雲端在Business Central中擴展規則
11. 基於規則的AI和機器學習AI - 結合兩者的優勢
12. 接下來呢？深入了解神經網絡、企業項目、高級規則和規則引擎
13. 附錄A，介紹Visual Basic for Applications
14. 附錄B，使用VSCode、Azure和GitHub Codespaces進行測試
15. 附錄C，Docker故障排除