LEADER 02964nam 2200481 450 001 9910822220103321 005 20230803221549.0 010 $a1-61547-218-5 035 $a(CKB)2550000001317370 035 $a(EBL)1712161 035 $a(MiAaPQ)EBC1712161 035 $a(Au-PeEL)EBL1712161 035 $a(CaPaEBR)ebr10884973 035 $a(CaONFJC)MIL619059 035 $a(OCoLC)881509805 035 $a(EXLCZ)992550000001317370 100 $a20140701h20142014 uy 0 101 0 $aeng 135 $aurcn#---||||| 181 $2rdacontent 182 $2rdamedia 183 $2rdacarrier 200 10$aDashboarding and reporting with Power Pivot and Excel $ehow to design and create a financial dashboard with Power Pivot - end to end /$fKasper de Jonge ; cover design, Jocelyn Collie ; indexing, Nellie J. Liwam 210 1$aUniontown, Ohio :$cHoly Macro! Books,$d2014. 210 4$d©2014 215 $a1 recurso en li?nea (193 páginas) $cilustraciones 311 $a1-61547-027-1 320 $aIncludes bibliographical references and indexes. 327 $aCover; Title page; Copyright page; Contents; Acknowledgments; Preface; 1- About This Book; 2- Introduction to Dashboards and Reports; 3- Collecting and Preparing the Data; 4- Building a Dashboard in Excel; 5- Building Interactive Reports with Excel and Power View; 6- Sharing Dashboards and Reports Within an Organization; Bibliography and Suggested Readings; Index of Tips; Index; More from Holy Macro! Books. 330 $aMicrosoft's revolutionary Power Pivot is a tool that allows users to create and transform data into reports and dashboards in new and much more powerful ways using the most-used analytical tool in the world: Excel. This book, written by a member of Microsoft's Power Pivot team, provides a practical step by step guide on creating a financial dashboard. The book covers in detail how to combine and shape the relevant data, build the dashboard in Excel, providing layout and design tips and tricks, prepare the model to work with fiscal dates, and show values used in many financial reports, including year-to-date, variance-to-target, percentage-of-total, and running totals reports. Accessibly written, this book offers readers a practical, real-world scenario and can be used as a day-to-day reference. Though the guide focuses on Power Pivot for Excel 2010, a chapter that discusses Power View?compatible with Excel 2013? and Power BI is also included. 606 $aDashboards (Management information systems)$xDesign 615 0$aDashboards (Management information systems)$xDesign. 676 $a658.4038011 700 $ade Jonge$b Kasper$01659892 702 $aCollie$b Jocelyn 702 $aLiwam$b Nellie J. 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910822220103321 996 $aDashboarding and reporting with Power Pivot and Excel$94014781 997 $aUNINA