Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013

Mark Polino

  • 出版商: Packt Publishing
  • 出版日期: 2013-03-24
  • 售價: $2,140
  • 貴賓價: 9.5$2,033
  • 語言: 英文
  • 頁數: 268
  • 裝訂: Paperback
  • ISBN: 1849689067
  • ISBN-13: 9781849689069
  • 相關分類: Excel
  • 下單後立即進貨 (約3~4週)

相關主題

商品描述

Microsoft Dynamics GP and Excel are made for each other. With this book you'll learn to use Excel to present the information contained in Dynamics in a data-rich dashboard. Step-by-step instructions come with real-life examples.

Overview

  • 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

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.

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

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 written 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.

商品描述(中文翻譯)

Microsoft Dynamics GP 和 Excel 是天作之合。透過這本書,您將學會如何使用 Excel 來呈現 Dynamics 中包含的資訊,並製作資料豐富的儀表板。書中提供逐步指導,並附有實際案例。

概述
- 使用 Excel 2013 建立包含 Microsoft Dynamics GP 2013 資訊的儀表板
- 使 Excel 成為真正的商業智慧工具,搭配圖表、迷你圖、切片器等功能
- 利用 PowerPivot 的全部潛力來創建更複雜的儀表板

詳細內容
像 Microsoft Dynamics GP 2013 這樣的會計系統擁有豐富的資訊。Excel 2013 提供了一個極佳的工具,用於連結、提取、分析和呈現這些豐富的數據,幫助公司做出更好、更快、更聰明的決策。

《使用 Microsoft Dynamics GP 2013 和 Excel 2013 建立儀表板》涵蓋了如何獲取 Microsoft Dynamics GP 2013 中的豐富詳細資訊,並使用 Excel 2013 以吸引人且易於理解的方式呈現。這本書詳細說明了如何建立美觀的儀表板,以增強公司的決策過程。

這本書教您如何獲取 Microsoft Dynamics GP 2013 中的豐富詳細資訊,並使用 Excel 2013 以吸引人且易於理解的方式呈現。這本指南將帶您從基本的設置和部署開始,直到創建安全且可更新的 Excel 報告。利用 Excel 中的各種工具,本教程將教您如何使用簡單的條件格式化技術、易於閱讀的圖表來視覺化您的數據,並使您的數據與切片器互動。

《使用 Microsoft Dynamics GP 2013 和 Excel 2013 建立儀表板》提供了一種簡單的方法,讓您能夠輕鬆建立 CFO 不斷要求的互動式儀表板。

您將從這本書中學到的內容
- 將 Dynamics GP 2013 資訊導入 Excel 2013
- 在 Dynamics GP 2013 中設置、部署和保護可更新的 Excel 報告,以將即時 GP 數據導入 Excel
- 使用 Excel 樞紐分析表整合和呈現 GP 2013 數據
- 透過條件格式化改善儀表板的外觀和感覺
- 使用圖表和迷你圖增強數據的清晰度
- 使用切片器為儀表板添加互動性
- 將儀表板數據鏈接回 Dynamics GP 2013
- 使用 PowerPivot 處理更複雜的儀表板和數據來源

方法
遵循實際的逐步範例,提供建立引人入勝的儀表板的基礎。這本實用指南專注於實踐。獲取您的數據,打開 Excel,開始吧!

本書的讀者對象
您不需要成為專家,就能充分利用 Dynamics GP 的實施,並使用 Microsoft Excel 建立美觀且易於維護的儀表板。如果您對 Dynamics 和 Excel 有基本的了解,您將在幾小時內而非幾天內製作出驚人的儀表板。