Cargando…
Building dashboards with Microsoft dynamics GP 2013 and Excel 2013 /
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!You don't need to be an expert to get the most out of your Dynamics GP implementation and build great-looking, eas...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Publishing,
2013.
|
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a2200000Ii 4500 | ||
|---|---|---|---|
| 001 | EBSCO_ocn836400774 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 130406s2013 enk o 000 0 eng d | ||
| 040 | |a EBLCP |b eng |e pn |c EBLCP |d OCLCQ |d IDEBK |d UMI |d DEBSZ |d OCLCQ |d YDXCP |d OCLCO |d OCLCQ |d OCLCO |d COO |d OCLCF |d OCLCO |d OCLCQ |d OCLCO |d CNNOR |d N$T |d ZCU |d AGLDB |d MERUC |d OCLCQ |d OCLCO |d D6H |d OCLCQ |d VTS |d CEF |d ICG |d AU@ |d OCLCQ |d OCLCO |d STF |d UAB |d DKC |d OCLCQ |d UKAHL |d OCL |d OCLCQ |d OCLCO |d OCLCQ |d AJS |d QGK |d OCLCO |d OCLCQ |d OCLCO | ||
| 019 | |a 852513249 |a 853063250 |a 1241817404 |a 1290095865 |a 1300706741 | ||
| 020 | |a 9781849689076 |q (electronic bk.) | ||
| 020 | |a 1849689075 |q (electronic bk.) | ||
| 020 | |z 9781849689069 | ||
| 020 | |z 1849689067 | ||
| 020 | |a 1299441203 | ||
| 020 | |a 9781299441200 | ||
| 029 | 1 | |a AU@ |b 000052007112 | |
| 029 | 1 | |a AU@ |b 000053037872 | |
| 029 | 1 | |a DEBBG |b BV041430947 | |
| 029 | 1 | |a DEBBG |b BV044174467 | |
| 029 | 1 | |a DEBSZ |b 397519281 | |
| 029 | 1 | |a DEBSZ |b 398267677 | |
| 029 | 1 | |a DEBSZ |b 493117466 | |
| 029 | 1 | |a DKDLA |b 820120-katalog:999941729005765 | |
| 035 | |a (OCoLC)836400774 |z (OCoLC)852513249 |z (OCoLC)853063250 |z (OCoLC)1241817404 |z (OCoLC)1290095865 |z (OCoLC)1300706741 | ||
| 050 | 4 | |a TK5105 | |
| 072 | 7 | |a COM |x 054000 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.276 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Polino, Mark, |e author. | |
| 245 | 1 | 0 | |a Building dashboards with Microsoft dynamics GP 2013 and Excel 2013 / |c Mark Polino. |
| 264 | 1 | |a Birmingham : |b Packt Publishing, |c 2013. | |
| 300 | |a 1 online resource (422 pages) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 588 | 0 | |a Online resource; title from PDF title page (EBSCO, viewed July 7, 2017). | |
| 505 | 0 | |a Table of Contents; Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013; 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; Why Subscribe?; Free Access for Packt account holders; Instant Updates on New Packt Books; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Downloading the support files; Errata; Piracy; Questions. | |
| 505 | 8 | |a 1. Getting Data from Dynamics GP 2013 to Excel 2013SmartList 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; 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. | |
| 505 | 8 | |a Modifying Excel reportsReformatting Excel data; Modifying source data; Office data connections; Excel Report Builder; Restrictions; Calculations; Options; Publish; Summary; 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. | |
| 505 | 8 | |a Adding a receivables pivot tableExcel Report Builder pivot tables; Creating Power View reports; Summary; 4. Making Things Pretty with Formatting and Conditional Formatting; Recap; Preparation; Get Pivot Data; Revenue; Net Income; Formatting; Icon sets; Data bars; Color Scales; Adjusting Color Scales; The green/yellow/red limit; Some more formatting; Summary; 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. | |
| 505 | 8 | |a Selecting chartsSparklines; Preparing for sparklines; Adding sparklines; Sparkline idiosyncrasies; Deleting sparklines; Changing sparkline data; Summary; 6. Adding Interactivity with Slicers and Timelines; Recap; Learning about slicers; Creating slicers; Connecting slicers; Slicer orientation; Slicer options; Timeline; Timeline options; Summary; 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. | |
| 520 | |a 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!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. | ||
| 546 | |a English. | ||
| 590 | |a eBooks on EBSCOhost |b EBSCO eBook Subscription Academic Collection - Worldwide | ||
| 630 | 0 | 0 | |a Microsoft Excel (Computer file) |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file) |2 blmlsh |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file) |2 fast |
| 650 | 0 | |a Dashboards (Management information systems) | |
| 650 | 0 | |a Accounting |v Software. | |
| 650 | 0 | |a Business enterprises |x Finance |x Data processing. | |
| 650 | 6 | |a Tableaux de bord (Gestion) | |
| 650 | 7 | |a COMPUTERS |x Desktop Applications |x Spreadsheets. |2 bisacsh | |
| 650 | 7 | |a Accounting |2 fast | |
| 650 | 7 | |a Business enterprises |x Finance |x Data processing |2 fast | |
| 650 | 7 | |a Dashboards (Management information systems) |2 fast | |
| 655 | 7 | |a Software |2 fast | |
| 776 | |z 1-84968-906-7 | ||
| 856 | 4 | 0 | |u https://ebsco.uam.elogim.com/login.aspx?direct=true&scope=site&db=nlebk&AN=562030 |z Texto completo |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26851052 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL1165032 | ||
| 938 | |a EBSCOhost |b EBSC |n 562030 | ||
| 938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n cis25210307 | ||
| 938 | |a YBP Library Services |b YANK |n 10407533 | ||
| 994 | |a 92 |b IZTAP | ||