Have a personal or library account? Click to login
Building Dashboards with Microsoft Dynamics GP 2016 Cover

Building Dashboards with Microsoft Dynamics GP 2016

Excel, Jet Reports, and MS Power BI with GP 2016

Publisher:Packt Publishing Limited
By: Belinda Allen and  Mark Polino  
Paid access
|Mar 2017
Product purchase options

Learn to build professional and powerful dashboards with Microsoft Dynamics GP and Excel

Key Features

  • This book provides a core foundation for you to understand the ever-changing Microsoft Power BI
  • Through this book, you’ll understand how data flows and is secured between Microsoft Dynamics GP and Microsoft Excel
  • You’ll see how to create amazing dashboards using various tools such as Excel 2016, Power BI, Jet Express, and more

Book Description

Microsoft Dynamics GP is a complete ERP solution that is extremely beneficial for small to midsize organizations in helping them grow exponentially.

The book shows you in detail how to build great-looking dashboards with Microsoft Dynamics GP that enhance a company’s decision-making processes.

This guide will take you from the basics of setting up and deploying to creating secure, refreshable Excel reports. Using a whole host of tools available within Microsoft Dynamics GP and Excel, this tutorial will show you how to visualize your data using simple conditional formatting techniques and easy-to-read charts, and allow you to make your data interactive with slicers.

We will also cover core topics such as Business Analyzer, Microsoft SQL Reporting services reports, BI360, and more. You will find out to use Power BI, share and refresh data and dashboards in Power BI, and use Power BI Query Editor.

By the end of this book, you will have all the information required to build interactive dashboards using Dynamics GP.

What you will learn

  • Use GP Data in Excel 2016 in a meaningful way
  • Build basic financial statements using Jet Reporting Express, including visualizations
  • Understand the foundation of Power BI and its components
  • Get and maintain data from Dynamics GP in Power BI
  • Find out how to use the Power BI Query Editor (the Get and Transform feature in Excel 2016)
  • Format basic visualizations to get better insights
  • Understand Jet Reports Express, which is used to create basic financial statements
  • Use the new Dynamics GP features, such as OData and adding Power BI tiles on the home page

Who this book is for

This book is geared up for analysts and accountants keen on building and maintaining professional dashboards with Microsoft Excel 2016 for Microsoft Dynamics GP 2016 data, and building financials with visuals using the New Jet Reports Express Tool for Dynamics GP. An introduction is provided for those who want to maintain dashboards in Microsoft Power BI.

Table of Contents

  1. Getting Data from Dynamics GP 2016 to Excel 2016
  2. The Ultimate GP to Excel Tool
  3. Pivot Tables
  4. Making Your Data Visually Appealing and Meaningful with Formatting, Conditional Formatting, and Charts
  5. Drilling Back to the Source Data and Other Cool Stuff
  6. Introducing Jet Reports Express
  7. Building Financial Reports in Jet Express for GP
  8. Introducing Microsoft Power BI
  9. Getting Data in Power BI
  10. Creating Power BI Visuals
  11. Using the Power BI Service
  12. Sharing and Refreshing Data and Dashboards in Power BI
  13. Using the Power Query Editor
  14. Bonus Chapter
PDF ISBN: 978-1-78646-404-0
Publisher: Packt Publishing Limited
Copyright owner: © 2017 Packt Publishing Limited
Publication date: 2017
Language: English
Pages: 354
Related subjects:
Computer sciences,
Computer sciences, other

People also read

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013
Book

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013

Polino, Mark
Real-world Business Intelligence with Microsoft Dynamics GP
Book
New

Real-world Business Intelligence with Microsoft Dynamics GP

Allen, Belinda, Polino, Mark
The Absolute Guide to Dashboarding and Reporting with Power BI
Book

The Absolute Guide to Dashboarding and Reporting with Power BI

Books, MrExcel's Holy Macro!, Jonge, Kasper de
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
Learn Power BI
Book

Learn Power BI

Deckler, Greg
Microsoft Power BI Cookbook
Book

Microsoft Power BI Cookbook

Test, Author, Powell, Brett
Power BI for the Excel Analyst
Book

Power BI for the Excel Analyst

Books, MrExcel's Holy Macro!, Hopkins, Wyn
Microsoft Power BI Quick Start Guide
Book

Microsoft Power BI Quick Start Guide

Knight, Devin, Quintana, Manuel, Knight, Brian, Pearson, Mitchell