Building Dashboards with Microsoft Dynamics GP 2016（Second Edition）
Belinda Allen Mark Polino更新时间：2021-07-09 19:18:54
最新章节：Index封面
版权信息
Credits
About the Authors
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface
Chapter 1. Getting Data from Dynamics GP 2016 to Excel 2016
SmartList exports
SmartList Export Solutions
Office Data Connection files
SQL Server Reporting Services
Jet Reports Express for Excel
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
Excel refreshable reports via SmartList Designer
Summary
Chapter 3. Pivot Tables – The Basic Building Blocks
Creating pivot tables from GP 2016 Excel report data
Creating pivot tables from GP 2016 data connections
Copying pivot tables
Creating connected pivot tables from inside Excel
Summary
Chapter 4. Making Your Data Visually Appealing and Meaningful with Formatting Conditional Formatting and Charts
Recap
Preparation
Get pivot data
Icon sets
Sparklines
Data bars
Bar chart with trend line
Pie chart
Speedometer chart
Slicers and timelines
Some more formatting
Summary
Chapter 5. Drilling Back to the Source Data and Other Cool Stuff
Recap
Slicers and timelines options
Learning about hyperlinks
Using drill downs in GP 2016
Other cool Excel stuff
Good design
Refreshing the data
Sharing
Summary
Chapter 6. Introducing Jet Reports Express
Recap
What is Jet and why should I use it?
What is Table Builder?
Other Jet offerings
Summary
Chapter 7. Building Financial Reports in Jet Express for GP
Recap
Building a balance sheet
Building a profit and loss statement
Summary
Chapter 8. Introducing Microsoft Power BI
Recap
Power BI Desktop versus Service versus Mobile
Power BI Professional (paid) versus Power BI (free)
Typical workflow of Power BI
Update speed
Summary
Chapter 9. Getting Data in Power BI
Recap
Getting data from files
Connecting to data in Dynamics GP
Content packs
Getting data from folders
Summary
Chapter 10. Creating Power BI Visuals
Recap
Using Filters
Formatting as a tool
Understanding standard visuals
Development options - if you have a techie on staff
R - what is it and do I need it?
Summary
Chapter 11. Using the Power BI Service
Recap
Publishing to the service
Creating a dashboard
Getting to know the Q&A feature
Importing an Excel report
Summary
Chapter 12. Sharing and Refreshing Data and Dashboards in Power BI
Recap
Power BI Template
Content Packs
Online Services
Refreshing data
Summary
Chapter 13. Using the Power Query Editor
Recap
What is a query?
Using Applied Steps
Removing unnecessary column(s)
Formatting column Data Types
What is the M language?
Using Replace Values
Transforming data
Working with dates and times
Merging columns
Splitting columns
Merging queries
Appending queries
Summarizing with Group By
Summary
Chapter 14. Bonus Chapter
Recap
Excel 2016
Jet Express for GP
Microsoft Power BI
Summary
Index
更新时间：2021-07-09 19:18:54