LEADER 05268nam 2200673Ia 450 001 9910828277103321 005 20240313192030.0 010 $a1-84968-907-5 010 $a1-299-44120-3 035 $a(CKB)2550000001018325 035 $a(EBL)1165032 035 $a(OCoLC)836400774 035 $a(SSID)ssj0000906370 035 $a(PQKBManifestationID)11536124 035 $a(PQKBTitleCode)TC0000906370 035 $a(PQKBWorkID)10949622 035 $a(PQKB)11753363 035 $a(Au-PeEL)EBL1165032 035 $a(CaPaEBR)ebr10682481 035 $a(CaONFJC)MIL475370 035 $a(PPN)228019176 035 $a(FR-PaCSA)88850457 035 $a(MiAaPQ)EBC1165032 035 $a(EXLCZ)992550000001018325 100 $a20130418d2013 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aBuilding dashboards with Microsoft Dynamics GP 2013 and Excel 2013 /$fMark Polino 205 $a1st ed. 210 $aBirmingham, UK $cPackt Pub.$dc2013 215 $a1 online resource (268 p.) 300 $aIncludes index. 311 $a1-84968-906-7 327 $aCover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; 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 327 $aDatabase-level securityExcel 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 327 $aBuilding the income pivot tableCreating 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 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; Chapter 5: Charts: Eye Candy for Executives; Recap; Bar chart; Adding a line 327 $aPie chartSpeedometer 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 6: Adding Interactivity with Slicers and Timelines; Recap; Learning about slicers; Creating slicers; Connecting slicers; Slicer orientation; Slicer options; Timeline; Timeline options; Summary; Chapter 7: Drilling Back to Source Data in Dynamics GP 2013; Recap 327 $aLearning about hyperlinksUsing 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 clean up 327 $aRefreshing the data 330 $aFollow 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. 606 $aDashboards (Management information systems) 606 $aAccounting$vSoftware 606 $aBusiness enterprises$xFinance$xData processing 615 0$aDashboards (Management information systems) 615 0$aAccounting 615 0$aBusiness enterprises$xFinance$xData processing. 676 $a005.2 676 $a005.276 700 $aPolino$b Mark$01597112 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910828277103321 996 $aBuilding dashboards with Microsoft Dynamics GP 2013 and Excel 2013$93918751 997 $aUNINA