LEADER 05463nam 2200745Ia 450 001 9910960506103321 005 20200520144314.0 010 $a9781849689076 010 $a1849689075 010 $a9781299441200 010 $a1299441203 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(FRCYB88850457)88850457 035 $a(DE-B1597)722373 035 $a(DE-B1597)9781849689076 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 08$a9781849689069 311 08$a1849689067 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$01796383 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910960506103321 996 $aBuilding dashboards with Microsoft Dynamics GP 2013 and Excel 2013$94338109 997 $aUNINA LEADER 00768nam 2200265 450 001 9910991696003321 005 20250411150351.0 010 $a9789597257158 100 $a20250410d2021----u y0engy50 ba 101 0 $aspa 102 $aES 105 0 $a 00 200 1 $aFemminielli$ecuerpo, género, cultura$fcompiladores Eugenio Zito, Paolo Valerio 210 $aLa Habana$cCenesex$d2021 215 $a343 p.$d24 cm 454 0$12001$a9910991394803321$aFemminielli$94351771 610 0 $aOmosessualità$aIdentità sessuale 676 $a306.766$v23$zita 702 1$aZito,$bEugenio 702 1$aValerio,$bPaolo 912 $a9910991696003321 952 $a306.766 ZIT 2$b12787$fbfs 959 $aBFS 996 $a9910991394803321$94351771 997 $aUNINA