Become an expert at preparing reports using Dynamics GP quickly and efficiently
Business intelligence (BI) is the process of making informed decisions based on timely and accurate information. Within an easy-to-use and easy-to-deploy enterprise resource planning (ERP) software solution, Microsoft Dynamics GP aims to provide small and mid-size businesses with complete control over their finances, inventory, and BI information, and to help them adapt to changing business needs.
This book is a collection of real Microsoft Dynamics GP user examples. Using one GP module at a time, the book reviews real GP users' issues and how BI can be used to resolve or improve them. Encompassing these real-life examples, the book reviews what BI to use and why, what BI tool was used and why, and how the results are used to solve problems and improve business success. This book will provide you with the tools to help you identify your BI need and a way to customize your end results in line with your business needs.
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
Downloading the example code for this book. You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to you.