Real-world Business Intelligence with Microsoft Dynamics GP

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

About This Book

• 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

Who This Book Is For

If 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

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.