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: Belinda Allen and  Mark Polino  
Paid access
|Sep 2025
Product purchase options

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

    People also read

    Microsoft Dynamics GP 2010 Reporting
    Book

    Microsoft Dynamics GP 2010 Reporting

    Microsoft Dynamics GP 2013 Reporting - Second Edition
    Book

    Microsoft Dynamics GP 2013 Reporting - Second Edition

    Microsoft Dynamics GP 2016 Cookbook
    Book
    New

    Microsoft Dynamics GP 2016 Cookbook

    Polino, Mark, Grieve, Ian
    Developing Microsoft Dynamics GP Business Applications
    Book

    Developing Microsoft Dynamics GP Business Applications

    Vail, Leslie
    Building Dashboards with Microsoft Dynamics GP 2016
    Book

    Building Dashboards with Microsoft Dynamics GP 2016

    Allen, Belinda, Polino, Mark
    Microsoft Dynamics GP 2013 Financial Management
    Book

    Microsoft Dynamics GP 2013 Financial Management

    Grieve, Ian
    Microsoft Dynamics GP 2010 Implementation
    Book

    Microsoft Dynamics GP 2010 Implementation

    Yudin, Victoria
    Microsoft Dynamics GP 2013 Implementation
    Book

    Microsoft Dynamics GP 2013 Implementation

    Yudin, Victoria
    Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013
    Book

    Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013

    Polino, Mark
    Microsoft Dynamics GP 2010 Cookbook
    Book

    Microsoft Dynamics GP 2010 Cookbook

    Polino, Mark