Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013


Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013
eBook: $29.99
Formats: PDF, PacktLib, ePub and Mobi formats
$25.49
save 15%!
Print + free eBook + free PacktLib access to the book: $79.98    Print cover: $49.99
$49.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Support
Sample Chapters
  • Build a dashboard using Excel 2013 with information from Microsoft Dynamics GP 2013
  • Make Excel a true business intelligence tool with charts, sparklines, slicers, and more
  • Utilize PowerPivot’s full potential to create even more complex dashboards

Book Details

Language : English
Paperback : 268 pages [ 235mm x 191mm ]
Release Date : March 2013
ISBN : 1849689067
ISBN 13 : 9781849689069
Author(s) : Mark Polino
Topics and Technologies : All Books, Enterprise Products and Platforms, Microsoft Dynamics, Enterprise, Microsoft

Table of Contents

Preface
Chapter 1: Getting Data from Dynamics GP 2013 to Excel 2013
Chapter 2: The Ultimate GP to Excel Tool: Refreshable Excel Reports
Chapter 3: Pivot Tables: The Basic Building Blocks
Chapter 4: Making Things Pretty with Formatting and Conditional Formatting
Chapter 5: Charts: Eye Candy for Executives
Chapter 6: Adding Interactivity with Slicers and Timelines
Chapter 7: Drilling Back to Source Data in Dynamics GP 2013
Chapter 8: Bringing it All Together
Chapter 9: Expanding Pivot Tables with PowerPivot
Chapter 10: Slightly Crazy Stuff
Index
  • Chapter 1: Getting Data from Dynamics GP 2013 to Excel 2013
    • SmartList exports
    • SmartList Export Solutions
      • Getting ready
      • Creating macros
      • Creating an export solution
      • Navigation List export
    • Report writer
    • Microsoft Query
    • SQL Server Reporting Services
    • Management Reporter
    • SQL Server Management Studio
    • Analysis Cubes
    • Third-party solutions
    • Licensing
    • Summary
    • Chapter 2: The Ultimate GP to Excel Tool: Refreshable Excel Reports
      • Security
        • Network share security
        • Database-level security
        • Excel 2013 security
      • Running Excel reports
        • From Dynamics GP 2013
        • From Excel 2013
        • Manual versus auto refresh
      • Modifying Excel reports
        • Reformatting Excel data
        • Modifying source data
        • Office data connections
      • Excel Report Builder
        • Restrictions
        • Calculations
        • Options
        • Publish
      • Summary
      • Chapter 3: Pivot Tables: The Basic Building Blocks
        • Creating pivot tables from GP 2013 Excel report data
          • Getting data to Excel
          • Building a pivot table
        • Creating pivot tables from GP 2013 data connections
          • Building a revenue pivot table
        • Copying pivot tables
          • Building the income pivot table
          • Creating a cash pivot table
        • Creating connected pivot tables from inside Excel
          • Building the sales pivot table
          • Adding a receivables pivot table
        • Excel Report Builder pivot tables
        • Creating Power View reports
        • Summary
          • Chapter 5: Charts: Eye Candy for Executives
            • Recap
            • Bar chart
              • Adding a line
            • Pie chart
            • Speedometer chart
              • Building a doughnut
              • Cutting the doughnut in half
              • Building a needle
              • Finishing it off with sprinkles
            • Bar chart with trend line
            • Selecting charts
            • Sparklines
              • Preparing for sparklines
              • Adding sparklines
              • Sparkline idiosyncrasies
              • Deleting sparklines
              • Changing sparkline data
            • Summary
              • Chapter 7: Drilling Back to Source Data in Dynamics GP 2013
                • Recap
                • Learning about hyperlinks
                • Using drill downs in GP 2013
                  • Drill down background
                  • Using drill downs
                  • Fixing the journal entry drill down problem
                  • Drill down link structure
                • Drill Down Builder
                  • Complex drill downs
                    • Drilling down with GP 2013 and Excel 2013 on Citrix or Terminal Server
                    • Drilling down to GP 2013 on Citrix with Excel 2013 installed locally
                  • Other complex drill down scenarios
                • Summary
                • Chapter 8: Bringing it All Together
                  • Adding headers
                  • Cleaning it up
                  • Adding a logo
                  • Creating backgrounds
                    • The Fill Color feature
                    • Inserting a picture
                    • Inserting a background
                  • Good design
                  • Final cleanup
                  • Refreshing the data
                  • Sharing
                    • The quick option – e-mail
                    • Network sharing
                    • Hosting via SkyDrive
                    • Downloading via SkyDrive
                    • Downloading via SharePoint
                    • Hosting via SharePoint Excel Services
                  • Summary
                  • Chapter 9: Expanding Pivot Tables with PowerPivot
                    • PowerPivot Basics
                    • Bringing Dynamics GP 2013 information to PowerPivot
                      • Copying and pasting
                      • Linking to a spreadsheet
                      • Connecting via SQL Server
                    • Learning about relationships
                    • Creating a pivot table
                      • Understanding the Excel data model
                    • Other source options
                      • About Atom feeds
                      • SQL Server Reporting Services (SSRS)
                        • Generating an Atom feed from an SSRS report
                        • SSRS native connections
                      • Windows Azure Marketplace
                    • More PowerPivot options
                      • Millions of rows of data
                      • DAX formulas
                      • SharePoint
                      • Resources
                    • Summary

                      Mark Polino

                      Mark Polino is a Microsoft MVP for Dynamics GP, a Certified Public Accountant, and a Microsoft Certified Business Management Solutions Professional. He is the author of the premier Dynamics GP related blog, DynamicAccounting.net, and the creator and presenter of the successful series Getting More Out of Microsoft Dynamics GP: 50 Tips in 50 minutes. Mark has worked with Dynamics GP and its predecessor, Great Plains, for more than 10 years.

                      He works as a Principal Consultant with I.B.I.S., Inc. and spends his days helping clients implement Microsoft Dynamics GP.

                      Sorry, we don't have any reviews for this title yet.

                      Code Downloads

                      Download the code and support files for this book.


                      Submit Errata

                      Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

                      Sample chapters

                      You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                      Frequently bought together

                      Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 +    IBM Cognos 10 Report Studio Cookbook, Second Edition =
                      50% Off
                      the second eBook
                      Price for both: £27.35

                      Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                      What you will learn from this book

                      • Get Dynamics GP 2013 information into Excel 2013
                      • Set up, deploy, and secure refreshable Excel reports in Dynamics GP 2013 to get live GP data to Excel
                      • Consolidate and present GP 2013 data using Excel pivot tables
                      • Improve the look and feel of a dashboard with conditional formatting
                      • Enhance data clarity with charts and sparklines
                      • Add interactivity to a dashboard using Slicers
                      • Link dashboard data back to Dynamics GP 2013
                      • Approach more complex dashboards and sources using PowerPivot

                      In Detail

                      Accounting systems like Microsoft Dynamics GP 2013 hold a wealth of information. Excel 2013 provides a great tool for linking to, extracting, analysing, and presenting that rich data to help companies make better, faster, and smarter decisions.

                      Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 covers how to get the rich, detailed information contained in Microsoft Dynamics GP 2013 and present it in an attractive, easy-to-understand way using Excel 2013. The book shows in detail how to build great-looking dashboards that enhance a company’s decision-making process.

                      This book shows you how to get at the rich, detailed information contained in Microsoft Dynamics GP 2013 and present it in an attractive, easy-to-understand way using Excel 2013. This guide will take you from the basics of setup and deployment to creating secure, refreshable Excel reports. Using a whole host of tools available within Excel, this tutorial will show you how to visualize your data using simple conditional formatting techniques, easy-to-read charts, and allow you to make your data interactive with Slicers.

                      Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 provides a way for you to easily build that interactive dashboard that your CFO keeps asking for.

                      Approach

                      Follow real-life, step-by-step examples that provide the building blocks to build engaging dashboards. This practical guide is all about doing. Get your data, open up Excel, and go!

                      Who this book is for

                      You don't need to be an expert to get the most out of your Dynamics GP implementation and build great-looking, easily maintained dashboards using Microsoft Excel. If you have a working knowledge of Dynamics and Excel you'll be producing amazing dashboards in hours not days.

                      Code Download and Errata
                      Packt Anytime, Anywhere
                      Register Books
                      Print Upgrades
                      eBook Downloads
                      Video Support
                      Contact Us
                      Awards Voting Nominations Previous Winners
                      Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                      Resources
                      Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software