Real-world Business Intelligence with Microsoft Dynamics GP

Become an expert at preparing reports using Dynamics GP quickly and efficiently

In Detail

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.