What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

Key benefits

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

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

What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

Frequently bought together

AI and Business Rule Engines for Excel Power Users

€26.99

Modern Generative AI with ChatGPT and OpenAI Models

€37.99

€26.99

Total € 91.97

Howard Swerdloff May 14, 2024

Having spent my entire career working in Enterprise software sales, it is rare to find a book that tells you why you are doing something technical or what you are trying to solve for the business / organization. This book does just that. Starting with why we use Excel, how it is central to organizations, but leaves gaps in solving pain points, it moves into what AI is, how AI can create rules to solve real world problems, and the different methods that have been tried to date (coding, macros, etc.)The author does a good job presenting several tools that can be used and makes a case for his choice of tools. From there, developing the team and understanding what each person does helps break down the way AI application works in the real world. Starting with a single rule and building on the level of complexity helps to provide the path forward to learn and apply AI within Excel. Being able to download all the code examples is also a great timesaver if you do have something that doesn't work exactly as described.Overall, great book and I highly recommend it.

Amazon Verified review

Megan Hanna Jan 15, 2024

As a business, finance, and statistics professor, I am always looking for new ways to improve my skills and knowledge. I was excited to read "AI and Business Rule Engines for Excel Power Users" because I knew it would be a valuable resource for me.The book starts by providing a brief overview of AI and business rule engines. It then discusses how these technologies can be used to improve the efficiency and accuracy of Excel spreadsheets. The author provides a number of real-world examples of how AI and business rule engines can be used to solve business problems.One of the things I liked best about the book was that it talked the users through how to decide what tools will work best for their analysis and/or business needs. The author also provides a number of tips and tricks for using AI and business rule engines effectively.Overall, I found "AI and Business Rule Engines for Excel Power Users" to be a very informative and helpful book. It is a valuable resource for anyone who wants to learn how to use AI and business rule engines to improve their Excel spreadsheets.I would highly recommend this book to anyone who is interested in learning more about AI and business rule engines. It is a great reference for anyone who wants to gain insight into the topic or who wants to refer back to it as they're working on specific tasks.Disclaimer: The publisher of this book provided me with a copy to review.

Amazon Verified review

Amazon Customer Jan 01, 2024

The title got me curious. Often, we hear that Excel is about to die. Yet, the title “AI and Business Rule Engines for Excel Power Users” puts Excel in the vortex of the latest technology.Reading the Table of Contents made me more curious and excited to read the book. I am an Excel Power user who has developed many custom solutions for companies in various business industries. This book takes the power of Excel to another level, teaching us how to take advantage of it and other Microsoft technologies to set business rules and automate business procedures.This book is very well-written. In easy language, the author explains how companies deal with developing applications to address their business needs and the challenges they face to maintain and evolve those applications.Paul Browne explores our many options with Excel (Tables, VBA, Power Query, Office Scripts, Power Automate, Python and more) and how to integrate those with AI tools and Business Rule Engines to create solid and trustable Enterprise Solutions. The author also explains several approaches and options when selecting and testing the tools to work with.All the fundamental concepts, such as business rules and decision models, are explained, as well as how to build, deploy, share, and later scale them, including several options and approaches, from the free ones that allow the user to learn, explore and test to the more robust ones for when the business is ready to invest and commit to more resources.I think there is nothing left to be put in by the author. He takes the reader by their hand, explains all the options and concepts they need to know, and guides them, step by step, on how to put all the pieces of a Business Rule Engine together. All that is left is on the reader’s side to put in the decision, the time and the effort to learn and develop the solutions they need for their businesses.

Amazon Verified review

Beowulf1984 Oct 03, 2023

This Excel guide offers invaluable insights for Excel enthusiasts looking to elevate their decision-making process. I really enjoyed the real-world examples. This book empowers readers to craft intelligent rules and leverage advanced tools, enabling them to optimize their Excel and business software usage, making it an indispensable resource for those aiming to elevate their data-driven decision-making skills.

Amazon Verified review

Marguerite Gaynor Jul 19, 2023

found this book an excellent guide on how to take my knowledge of excel to the next level. The book itself is helpful throughout and is an excellent tool to induce features which are both new to me and as a reference when I am trying to remember how to do something again.

Amazon Verified review

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

What do you get with eBook?