
Real-world Business Intelligence with Microsoft Dynamics GP
Become an expert at preparing reports using Dynamics GP quickly and efficiently
Packt Publishing
Published on 30. May 2015
Book
Paperback/Softback
364 pages
978-1-78217-724-1 (ISBN)
Description
Become an expert at preparing reports using Dynamics GP quickly and efficiently
Key Features
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
Book DescriptionIf 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 forIf 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.
Key Features
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
Book DescriptionIf 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 forIf 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.
More details
Language
English
Place of publication
Birmingham
United Kingdom
Target group
Professional and scholarly
US School Grade: College Graduate Student
Dimensions
Height: 235 mm
Width: 191 mm
Thickness: 20 mm
Weight
679 gr
ISBN-13
978-1-78217-724-1 (9781782177241)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions

Belinda Allen | Mark Polino
Real-world Business Intelligence with Microsoft Dynamics GP
Become an expert at preparing reports using Dynamics GP quickly and efficiently
E-Book
10/2025
Packt Publishing
from
€46.79
Available for download
Persons
Belinda Allen is a Microsoft Most Valuable Professional for Dynamics GP (MVP) and a GPUG (GP User Group) All-Star. Belinda is currently the Business Intelligence Program Manager for the new Azure Cloud-based SaaS ERP offering, PowerGP Online. This is an amped-up version of the GP we all love, running in the Microsoft Azure Cloud. In this role, she helps both Partners and Customers design and implement BI methodologies, allowing businesses to make decisions based on timely and accurate information. Belinda was one of the co-founders of Smith & Allen Consulting, Inc. (SACI), a New York City based firm with over 25 years' experience specializing in business intelligence, analytics and ERP software. On April 1, 2016, SACI joined forces with Njevity, Inc. (www.NjevityToGo.com). Now she gets to spend time in her favorite place, the world of Business Intelligence (BI). NjevityToGo offers solutions for ERP, CRM, BI, and much more in the cloud. Njevity is also the force behind PowerGP Online. Belinda's first book, Real-world Business Intelligence with Microsoft Dynamics GP was co-written with Mark Polino. It's a dive into where to Implementing a Business Intelligence Methodology with Microsoft Dynamics GP. Currently a member of the Credentialing Council for the Association of Dynamics Professionals, Belinda was the first Council Chair. In this role, she led a team of community leaders providing guidance and insight in the delivery and development of credentials for both Microsoft Dynamics GP and Microsoft Dynamics NAV. Belinda is also an inaugural member of the Board of Advisors for PBIUG (Power BI User Group.) In this role she provides her experience to the User Board Members, while they create the foundation for this new organization. The goal is to make Power BI a critical tool in the user's organizations. Belinda began implementing ERP systems so long ago that Windows was not an operating system but an application. And at that time, larger businesses used main frames with monitors that projected green type on black backgrounds, and smaller business did their accounting by hand. Having seen the evolution that has taken place over the years from sheets of paper to integrated analytics, Belinda still gets excited every time she helps a business improve. Belinda is also well known for her blog, www.BelindaTheGPcsi.com. On her blog, she shares really useful information about the product quickly and succinctly. She has earned the nickname GP CSI because she excels at reviewing GP problems and figuring out what went wrong... and why. With followers from all over the globe, she is able to share knowledge and achieve her mission--"To improve the lives and business success of my followers." Belinda has just started her new blog, www.BIbelinda.com, which is devoted to Microsoft Power BI. When not delving into GP problems and spearheading business success for clients, Belinda enjoys sailing, crochet/knitting, sewing/quilting, reading, and turning wood. Mark Polino is CPA, with additional certifications in financial forensics (CFF) and information technology (CITP). He is a Microsoft MVP for Business Solutions and a GPUG All Star who has worked with Dynamics GP and its predecessors since 1999. He works as the Director of Client Services for Fastpath, and he runs the DynamicAccounting.net website dedicated to all things Dynamics GP. He is a regularly featured speaker at Dynamics GP related events. This is Mark's tenth book, and his seventh GP related book with Packt Publishing. His work includes eight technology-focused books and two novels. He is also the author of the best-selling Microsoft Dynamics GP 2010 Cookbook, the spin off Lite edition, and a co-author for updated GP 2013 and 2016 editions, all from Packt Publishing.
Content
Table of Contents
What is BI and what are BI Tools for Microsoft Dynamics GP
The General Ledger Holds It All
Business Intelligence for Bank Reconciliation
Making Money by Paying Bills in Payables Management
Collect What Is Owed in Receivables Management
SOP Sales at Your Mouse Click! (Sales Order Processing)
Managing SOP just got easier (Sales Order Processing)
Managing your Inventory (Control)
Inventory (Control) with a boomerang effect
Gain Control of Your Spending with Purchase Order Processing (POP)
Payroll, Commissions and More oh my
What is BI and what are BI Tools for Microsoft Dynamics GP
The General Ledger Holds It All
Business Intelligence for Bank Reconciliation
Making Money by Paying Bills in Payables Management
Collect What Is Owed in Receivables Management
SOP Sales at Your Mouse Click! (Sales Order Processing)
Managing SOP just got easier (Sales Order Processing)
Managing your Inventory (Control)
Inventory (Control) with a boomerang effect
Gain Control of Your Spending with Purchase Order Processing (POP)
Payroll, Commissions and More oh my