Real-world Business Intelligence with Microsoft Dynamics GP

Book Description

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

Who this book is for