更新时间：2021-07-27 18:15:36
coverpage
Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013
Credits
About the Author
About the Reviewers
www.PacktPub.com
Support files eBooks discount offers and more
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 1. Getting Data from Dynamics GP 2013 to Excel 2013
SmartList exports
SmartList Export Solutions
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
Running Excel reports
Modifying Excel reports
Excel Report Builder
Chapter 3. Pivot Tables: The Basic Building Blocks
Creating pivot tables from GP 2013 Excel report data
Creating pivot tables from GP 2013 data connections
Copying pivot tables
Creating connected pivot tables from inside Excel
Excel Report Builder pivot tables
Creating Power View reports
Chapter 4. Making Things Pretty with Formatting and Conditional Formatting
Recap
Preparation
Get Pivot Data
Icon sets
Data bars
Color Scales
The green/yellow/red limit
Some more formatting
Chapter 5. Charts: Eye Candy for Executives
Bar chart
Pie chart
Speedometer chart
Bar chart with trend line
Selecting charts
Sparklines
Chapter 6. Adding Interactivity with Slicers and Timelines
Learning about slicers
Timeline
Chapter 7. Drilling Back to Source Data in Dynamics GP 2013
Learning about hyperlinks
Using drill downs in GP 2013
Drill Down Builder
Chapter 8. Bringing it All Together
Adding headers
Cleaning it up
Adding a logo
Creating backgrounds
Good design
Final cleanup
Refreshing the data
Sharing
Chapter 9. Expanding Pivot Tables with PowerPivot
PowerPivot Basics
Bringing Dynamics GP 2013 information to PowerPivot
Learning about relationships
Creating a pivot table
Other source options
More PowerPivot options
Chapter 10. Slightly Crazy Stuff
Using built-in ratios
Current Ratio
Microsoft Dashboard
Negative data bars
Quick Analysis
Index
