You're reading from AI and Business Rule Engines for Excel Power Users Capture and scale your business knowledge into the cloud – with Microsoft 365, Decision Models, and AI tools from IBM and Red Hat

Product type Paperback

Published in Mar 2023

Publisher Packt

ISBN-13 9781804619544

Length 386 pages

Edition 1st Edition

Languages

Power Query

Tools

Excel

Concepts

Information Management

Authors (2):

Paul Browne (GBP)

ALEX PORCELLI

View More author details

Table of Contents (22) Chapters

Preface

1. Part 1:The Problem with Excel, and Why Rule-Based AI Can Be the Solution FREE CHAPTER

2. Chapter 1: Wrestling with Excel? You Are Not Alone

3. Chapter 2: Choosing an AI and Business Rules Engine – Why Drools and KIE?

4. Chapter 3: Your First Business Rule with the Online KIE Sandbox

5. Part 2: Writing Business Rules and Decision Models – with Real-Life Examples

6. Chapter 4: More Decision Models, Business Rules, and Decision Tables

7. Chapter 5: Sharing and Deploying Decision Models Using OpenShift and GitHub

8. Chapter 6: Calling Business Rules from Excel Using Power Query

9. Part 3: Extending Excel, Decision Models, and Business Process Automation into a Complete Enterprise Solution

10. Chapter 7: Using Business Rules in Excel with Visual Basic, Script Lab, or Office Scripts

11. Chapter 8: Using AI and Decision Services Within Power Automate Workflows

12. Chapter 9: Advanced Expressions, Decision Models, and Testing

13. Part 4: Next Steps in AI, Machine Learning, and Rule Engines

14. Chapter 10: Scaling Rules in Business Central with Docker and the Cloud

15. Chapter 11: Rules-Based AI and Machine Learning AI – Combining the Best of Both

16. Chapter 12: What Next? A Look inside Neural Networks, Enterprise Projects, Advanced Rules, and the Rule Engine

17. Index

Why subscribe?

18. Other Books You May Enjoy

Appendix A - Introduction to Visual Basic for Applications

Introduction to macros and VBA

1. Appendix B - Testing Using VSCode, Azure, and GitHub Codespaces

2. Appendix C - Troubleshooting Docker

Dynamic lists, contexts, and relations

You might remember in Chapter 4 that we graphically created List using a decision node of the List type. Look at Figure 4.25 if you want to refresh your memory – it was a great way to clearly show the health issues we were looking for. But lists are much more dynamic than that. We already said that we could use FEEL expressions anywhere – and that includes within lists. For example, the list in Figure 9.1 is a valid syntax. This example can be downloaded from the sample site (https://github.com/PacktPublishing/AI-and-Business-Rules-for-Excel-Power-Users) as c-09-dynamic-lists.dmn.

Figure 9.1 – Generating our list values dynamically

We’ve manipulated the figure so we can show the main diagram, our list values, and the input/output in one picture. You will have to press the Edit node and Run button on the screen to view similar results.

Date and time functions in FEEL

As you’...