Search icon Close icon
Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases now! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Checkout

Change country

Modal Close icon
Country selected Country selected
country flag Germany
Country selected
country flag Slovakia
Country selected
country flag Canada
Country selected
country flag Brazil
Country selected
country flag Singapore
Country selected
country flag Hungary
Country selected
country flag Philippines
Country selected
country flag Mexico
Country selected
country flag Thailand
Country selected
country flag Ukraine
Country selected
country flag Luxembourg
Country selected
country flag Estonia
Country selected
country flag Lithuania
Country selected
country flag Norway
Country selected
country flag Chile
Country selected
country flag United States
Country selected
country flag Great Britain
Country selected
country flag India
Country selected
country flag Spain
Country selected
country flag South Korea
Country selected
country flag Ecuador
Country selected
country flag Colombia
Country selected
country flag Taiwan
Country selected
country flag Switzerland
Country selected
country flag Indonesia
Country selected
country flag Cyprus
Country selected
country flag Denmark
Country selected
country flag Finland
Country selected
country flag Poland
Country selected
country flag Malta
Country selected
country flag Czechia
Country selected
country flag New Zealand
Country selected
country flag Austria
Country selected
country flag Turkey
Country selected
country flag France
Country selected
country flag Sweden
Country selected
country flag Italy
Country selected
country flag Egypt
Country selected
country flag Belgium
Country selected
country flag Portugal
Country selected
country flag Slovenia
Country selected
country flag Ireland
Country selected
country flag Romania
Country selected
country flag Greece
Country selected
country flag Argentina
Country selected
country flag Malaysia
Country selected
country flag South Africa
Country selected
country flag Netherlands
Country selected
country flag Bulgaria
Country selected
country flag Latvia
Country selected
country flag Australia
Country selected
country flag Japan
Country selected
country flag Russia
Country selected
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Building Dashboards with Microsoft Dynamics GP 2016

You're reading from   Building Dashboards with Microsoft Dynamics GP 2016 Excel, Jet Reports, and MS Power BI with GP 2016

Arrow left icon
Product type Paperback
Published in Mar 2017
Publisher
ISBN-13 9781786467614
Length 354 pages
Edition 2nd Edition
Tools
Concepts
Arrow right icon
Authors (2):
Arrow left icon
Belinda Allen Belinda Allen
Author Profile Icon Belinda Allen
Belinda Allen
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.
Read more
See other products by Belinda Allen
Mark Polino Mark Polino
Author Profile Icon Mark Polino
Mark Polino
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.
Read more
See other products by Mark Polino
Arrow right icon
View More author details
Toc

Table of Contents (16) Chapters Close

Preface 1. Getting Data from Dynamics GP 2016 to Excel 2016 FREE CHAPTER 2. The Ultimate GP to Excel Tool – Refreshable Excel Reports 3. Pivot Tables – The Basic Building Blocks 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 Index

Recap

Throughout this book, we've been building a dashboard that looks like the following screenshot:

Recap

We're done with the hard parts, and now, we will connect the pieces and clean things up.

lock icon The rest of the chapter is locked
arrow left Previous Section
Section 2 of 10
Next Section arrow right
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Sign up now
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Start free trial
Renews at $19.99/month. Cancel anytime

Authors (2)

Left arrow icon
Profile icon Belinda Allen
Belinda Allen
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.
Read more
See other products by Belinda Allen
Profile icon Polino
Polino
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.
Read more
See other products by Polino
Right arrow icon

Other recommended products

Related to this chapter
Left arrow icon
VBA Automation for Excel 2019 Cookbook
VBA Automation for Excel 2019 Cookbook
Read more
This VBA Automation Cookbook is a recipe-based guide for Office users to automate their daily tasks and extend the capabilities of Excel and other Office applications. With this book, you'll learn the VBA programming language and its components that will help you to build custom programs and procedures to control applications in the Office suite.
Read more
Sep 2020 12h 4m
VBA Automation for Excel 2019 Cookbook
VBA Automation for Excel 2019 Cookbook
Read more
This VBA Automation Cookbook is a recipe-based guide for Office users to automate their daily tasks and extend the capabilities of Excel and other Office applications. With this book, you'll learn the VBA programming language and its components that will help you to build custom programs and procedures to control applications in the Office suite.
Read more
Sep 2020 12h 4m
VBA Automation for Excel 2019 Cookbook
VBA Automation for Excel 2019 Cookbook
Read more
This VBA Automation Cookbook is a recipe-based guide for Office users to automate their daily tasks and extend the capabilities of Excel and other Office applications. With this book, you'll learn the VBA programming language and its components that will help you to build custom programs and procedures to control applications in the Office suite.
Read more
Sep 2020 12h 4m
VBA Automation for Excel 2019 Cookbook
VBA Automation for Excel 2019 Cookbook
Read more
This VBA Automation Cookbook is a recipe-based guide for Office users to automate their daily tasks and extend the capabilities of Excel and other Office applications. With this book, you'll learn the VBA programming language and its components that will help you to build custom programs and procedures to control applications in the Office suite.
Read more
Sep 2020 12h 4m
VBA Automation for Excel 2019 Cookbook
VBA Automation for Excel 2019 Cookbook
Read more
This VBA Automation Cookbook is a recipe-based guide for Office users to automate their daily tasks and extend the capabilities of Excel and other Office applications. With this book, you'll learn the VBA programming language and its components that will help you to build custom programs and procedures to control applications in the Office suite.
Read more
Sep 2020 12h 4m
VBA Automation for Excel 2019 Cookbook
VBA Automation for Excel 2019 Cookbook
Read more
This VBA Automation Cookbook is a recipe-based guide for Office users to automate their daily tasks and extend the capabilities of Excel and other Office applications. With this book, you'll learn the VBA programming language and its components that will help you to build custom programs and procedures to control applications in the Office suite.
Read more
Sep 2020 12h 4m
VBA Automation for Excel 2019 Cookbook
VBA Automation for Excel 2019 Cookbook
Read more
This VBA Automation Cookbook is a recipe-based guide for Office users to automate their daily tasks and extend the capabilities of Excel and other Office applications. With this book, you'll learn the VBA programming language and its components that will help you to build custom programs and procedures to control applications in the Office suite.
Read more
Sep 2020 12h 4m
VBA Automation for Excel 2019 Cookbook
VBA Automation for Excel 2019 Cookbook
Read more
This VBA Automation Cookbook is a recipe-based guide for Office users to automate their daily tasks and extend the capabilities of Excel and other Office applications. With this book, you'll learn the VBA programming language and its components that will help you to build custom programs and procedures to control applications in the Office suite.
Read more
Sep 2020 12h 4m
VBA Automation for Excel 2019 Cookbook
VBA Automation for Excel 2019 Cookbook
Read more
This VBA Automation Cookbook is a recipe-based guide for Office users to automate their daily tasks and extend the capabilities of Excel and other Office applications. With this book, you'll learn the VBA programming language and its components that will help you to build custom programs and procedures to control applications in the Office suite.
Read more
Sep 2020 12h 4m
VBA Automation for Excel 2019 Cookbook
VBA Automation for Excel 2019 Cookbook
Read more
This VBA Automation Cookbook is a recipe-based guide for Office users to automate their daily tasks and extend the capabilities of Excel and other Office applications. With this book, you'll learn the VBA programming language and its components that will help you to build custom programs and procedures to control applications in the Office suite.
Read more
Sep 2020 12h 4m
VBA Automation for Excel 2019 Cookbook
VBA Automation for Excel 2019 Cookbook
Read more
This VBA Automation Cookbook is a recipe-based guide for Office users to automate their daily tasks and extend the capabilities of Excel and other Office applications. With this book, you'll learn the VBA programming language and its components that will help you to build custom programs and procedures to control applications in the Office suite.
Read more
Sep 2020 12h 4m
VBA Automation for Excel 2019 Cookbook
VBA Automation for Excel 2019 Cookbook
Read more
This VBA Automation Cookbook is a recipe-based guide for Office users to automate their daily tasks and extend the capabilities of Excel and other Office applications. With this book, you'll learn the VBA programming language and its components that will help you to build custom programs and procedures to control applications in the Office suite.
Read more
Sep 2020 12h 4m
Right arrow icon

Personalised recommendations for you

Based on your interests and search pattern
Left arrow icon
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Mastering Customer Success
Mastering Customer Success
Read more
This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.
Read more
May 2024 5h 40m
Right arrow icon