Skip to main content
Have a personal or library account? Click to login
Real-world Business Intelligence with Microsoft Dynamics GP Cover

Real-world Business Intelligence with Microsoft Dynamics GP

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

Publisher:Packt Publishing Limited
By:  and    
Paid access
|Oct 2025
Product purchase options
Description

Key Features

    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

    Table of Contents

    1. What is BI and what are BI Tools for Microsoft Dynamics GP
    2. The General Ledger Holds It All
    3. Business Intelligence for Bank Reconciliation
    4. Making Money by Paying Bills in Payables Management
    5. Collect What Is Owed in Receivables Management
    6. SOP Sales at Your Mouse Click! (Sales Order Processing)
    7. Managing SOP just got easier (Sales Order Processing)
    8. Managing your Inventory (Control)
    9. Inventory (Control) with a boomerang effect
    10. Gain Control of Your Spending with Purchase Order Processing (POP)
    11. Payroll, Commissions and More oh my
    PDF ISBN: 978-1-78217-725-8
    Publisher: Packt Publishing Limited
    Copyright owner: © 2015 Packt Publishing Limited
    Publication date: 2025
    Language: English
    Pages: 364
    Related subjects:
    Computer sciences,
    Business computing

    People also read

    Book

    Microsoft Dynamics GP 2010 Reporting

    Chris Liley, David Duncan
    Book

    Microsoft Dynamics GP 2013 Reporting - Second Edition

    David Duncan
    Book

    Developing Microsoft Dynamics GP Business Applications

    Leslie Vail
    Book

    Microsoft Dynamics GP 2016 Cookbook

    Mark Polino, Ian Grieve
    Book

    Microsoft Dynamics GP 2013 Financial Management

    Ian Grieve
    Book

    Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013

    Mark Polino
    Book

    Building Dashboards with Microsoft Dynamics GP 2016

    Belinda Allen, Mark Polino
    Book

    Microsoft Dynamics GP 2010 Implementation

    Victoria Yudin
    Book

    Microsoft Dynamics GP 2010 Cookbook

    Mark Polino
    Book

    Microsoft Dynamics GP 2013 Implementation

    Victoria Yudin