Book

Building Dashboards with Microsoft Dynamics GP 2016

The book shows you in detail how to build great-looking dashboards with Microsoft Dynamics GP. It will take you from creating amazing dashboards using various tools such as Excel 2016, Power BI to Jet Express. We will also cover core topics such as Business Analyzer, Microsoft SQL Reporting services reports, BI360, and more.

Offered byPackt Logo

Difficulty Level

Intermediate

Completion Time

11h48m

Language

English

About Book

Who Is This Book 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.

Book content

chapters 11h48m total length

Getting Data from Dynamics GP 2016 to Excel 2016

The Ultimate GP to Excel Tool – Refreshable Excel Reports

Pivot Tables – The Basic Building Blocks

Making Your Data Visually Appealing and Meaningful with Formatting, Conditional Formatting, and Charts

Drilling Back to the Source Data and Other Cool Stuff

Introducing Jet Reports Express

Building Financial Reports in Jet Express for GP

Introducing Microsoft Power BI

Getting Data in Power BI

Creating Power BI Visuals

Using the Power BI Service

Sharing and Refreshing Data and Dashboards in Power BI

Using the Power Query Editor

Bonus Chapter

Related Resources

Access Ready-to-Use Books for Free!

Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!

No credit card required