Real-world Business Intelligence with Microsoft Dynamics GP : Become an expert at preparing reports using Dynamics GP quickly and efficiently

Become an expert at preparing reports using Dynamics GP quickly and efficiently Key Features Extend your Microsoft Dynamics GP skills by mastering Microsoft Dynamics Excel and Microsoft Power BI tools Gain insight into your current data, providing insight for better decision making Empower yourself with easy-to-follow directions for preparing useful and advanced reports Book DescriptionIf you're a GP user, this book is aimed at making your job easier. How? Through the use of Business Intelligence (BI) provided by your Microsoft Dynamics GP software to aid you in making informed decisions. This book assumes no previous experience; however, a basic knowledge of Excel is expected.What you will learn Learn where and how to deploy an SQL View Create PivotTables and PivotCharts using Excel Design PowerViews in Excel Use PowerPivot and PowerQuery in Excel for large data sets Manage Receivables better through the use of Business Intelligence Develop custom reports for your Microsoft Dynamics GP data Manage products using Inventory Control and BI Master how to use Excel Slicers, PivotTables, PivotCharts, PivotViews, Excel tables, Data Connections, and other Excel features Who this book is forIf you're a GP user, this book is aimed at making your job easier. How? Through the use of Business Intelligence (BI) provided by your Microsoft Dynamics GP software to aid you in making informed decisions. This book assumes no previous experience; however, a basic knowledge of Excel is expected.