product
700625AI and Business Rule Engines for Excel Power Usershttps://www.gandhi.com.mx/business-rule-engines-and-ai-for-excel-power-users/phttps://gandhi.vtexassets.com/arquivos/ids/823860/8843ef30-5cb0-4387-8787-677cc807abe8.jpg?v=638336368808700000546575MXNPackt PublishingInStock/Ebooks/698146AI and Business Rule Engines for Excel Power Users546575https://www.gandhi.com.mx/business-rule-engines-and-ai-for-excel-power-users/phttps://gandhi.vtexassets.com/arquivos/ids/823860/8843ef30-5cb0-4387-8787-677cc807abe8.jpg?v=638336368808700000InStockMXN99999DIEbook20239781804616321_W3siaWQiOiI5YTVlZDk4Ni05MDQ1LTRkYzYtYTlhYS0zMzk5YmE3YmY3YWMiLCJsaXN0UHJpY2UiOjU3NSwiZGlzY291bnQiOjI5LCJzZWxsaW5nUHJpY2UiOjU0NiwiaW5jbHVkZXNUYXgiOnRydWUsInByaWNlVHlwZSI6Ildob2xlc2FsZSIsImN1cnJlbmN5IjoiTVhOIiwiZnJvbSI6IjIwMjUtMDItMjVUMTk6MDA6MDBaIiwicmVnaW9uIjoiTVgiLCJpc1ByZW9yZGVyIjpmYWxzZX1d9781804616321_<p><strong>A hands-on book to increase efficiency of using excel spreadsheets using Microsoft Office and the Red Hat Business Rules Engine</strong></p><h4>Key Features</h4><ul><li>Additional Tools to leverage the power of Business Rule Engines and Excel</li><li>Advanced Work Bench features</li><li>Kogito Business Central workbench</li></ul><h4>Book Description</h4><p>Microsoft Excel 365 is used by hundreds of millions of people worldwide, with more using equivalent tools such as Google Sheets and OpenOffice. Sooner or later, Excel Power Users reach its limitations e.g. formulas becoming too complex, business knowledge buried in spreadsheets that cannot be explained, not easy to scale (still emailing sheets back and forward?), not secure and anybody can edit a sheet, no way of managing different versions, cannot easily be deployed onto the web. In short, these power users have no clear path to migrate to Enterprise Level solutions.</p><p>The book begins by introducing the Rule Engine approach to AI and shows how to solve many of the issues facing Excel users as their spreadsheets become more complicated. It gives them a roadmap supporting them in getting started, but also shows how to scale the approach by working with colleagues on Enterprise grade solutions.</p><p>As the book progresses, readers will learn how to move existing Excel spreadsheets into a solution that solves many of your current headaches (e.g. formulas too complex to understand). It will allow you and your team to save time, both on day to day tasks but also in maintaining your solution in the future.</p><p>By the end of the book youll understand how to leverage the power of Rule Engines on top of your existing Excel knowledge. Youll have solved many of your current Excel headaches and taken a key step towards using the next generation of AI and Office tools.</p><h4>What you will learn</h4><ul><li>Readers will realize that they are not alone in the problems they are facing using Excel.</li><li>Readers will be able to articulate to colleagues what a Business Rule Engine is and how it can help them.</li><li>Have signed up / downloaded / setup the tools - Kogito, Microsoft Power Automate - for free, and be ready to use them.</li><li>Have worked though the Web Based, Kogito Business Central workbench, and are able to use it to capture their Business Knowledge.</li><li>Have written a real world example proving that the business rules approach is relevant to them, and be ready to extend it to solve their particular business problem.</li><li>Understand other tools (such as workflow / Power Automate) that can help in this space and integrate it into their real life examples.</li></ul><h4>Who This Book Is For</h4><p>Core target audience includes Excel Power users, Business Analysts, looking for a tool to capture their knowledge and deploy it as part of Enterprise grade systems. Prerequisites of target audience includes familiarity with excel. Knowledge of KIE Workbench and Azure Web Portal would be beneficial but not compulsory.</p><h4>Table of Contents</h4><ol><li>Introduction - Youre not the only one facing these problems with Excel</li><li>Choosing a Business Rules Engine</li><li>Writing your first Business Rule</li><li>More Business Rules</li><li>Better Ways to link Excel and Rules Engines</li><li>Advanced Rule Editing Tools</li><li>Testing Business Rules</li><li>Scaling from Excel Desktop to Enterprise</li><li>Workflows with Rules and Microsoft Power Automate</li><li>More on Machine Learning</li><li>Looking under the covers</li><li>Rules in the real world AI no longer needs to be a black box</li><li>Appendix 1</li></ol>...(*_*)9781804616321_<p><b>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</b></p><h4>Key Features</h4><ul><li>Explore the business rule tools by implementing real-world examples to write sophisticated rules</li><li>Discover how decision services solve current business challenges using AI</li><li>Combine rules with workflows and scripting to deploy a cloud-based production environment</li></ul><h4>Book Description</h4>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 Microsofts business process automation tools, such as Power Automate, Power Query, Office Script, Forms, VBA, Script Lab, and GitHub. Youll 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, youll 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. Youll be equipped to solve your Excel queries and start using the next generation of Microsoft Office tools.<h4>What you will learn</h4><ul><li>Use KIE and Drools decision services to write AI-based business rules</li><li>Link Business Rules to Excel using Power Query, Script Lab, Office Script, and VBA</li><li>Build an end-to-end workflow with Microsoft Power Automate and Forms while integrating it with Excel and Kogito</li><li>Collaborate on and deploy your decision models using OpenShift, Azure, and GitHub</li><li>Discover advanced editing using the graphical Decision Model Notation (DMN) and testing tools</li><li>Use Kogito to combine AI solutions with Excel</li></ul><h4>Who this book is for</h4><p>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.</p>...9781804616321_Packt Publishinglibro_electonico_4bca5505-ffd7-338b-84f9-00d2b8009082_9781804616321;9781804616321_9781804616321Paul BrowneInglésMéxicohttps://getbook.kobo.com/koboid-prod-public/packt-epub-40b42476-a475-45b4-97aa-50f81c40ecdb.epub2023-03-31T00:00:00+00:00Packt Publishing