LEADER 04385nam 2200589 450 001 9910458278803321 005 20200520144314.0 010 $a1-61547-214-2 035 $a(CKB)2550000001317379 035 $a(EBL)1712158 035 $a(SSID)ssj0001328851 035 $a(PQKBManifestationID)11728254 035 $a(PQKBTitleCode)TC0001328851 035 $a(PQKBWorkID)11292132 035 $a(PQKB)10097162 035 $a(MiAaPQ)EBC1712158 035 $a(Au-PeEL)EBL1712158 035 $a(CaPaEBR)ebr10884980 035 $a(CaONFJC)MIL619071 035 $a(OCoLC)881571318 035 $a(EXLCZ)992550000001317379 100 $a20140701h20142014 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aPower Pivot alchemy $epatterns and techniques for Excel /$fRob Collie and Bill Jelen ; cover design, Jocelyn Hellyer ; indexing, Nellie J. Liwam 210 1$aUniontown, Ohio :$cHoly Macro! Books,$d2014. 210 4$dİ2014 215 $a1 online resource (257 p.) 300 $aIncludes index. 311 $a1-61547-021-2 327 $aCover; Title page; Copyright; Table of Contents; Dedications; A Note on Hyperlinks; Acknowledgements; Foreword; Introduction; Chapter 1: Dashboard Tricks and Visualization Techniques; Adding a "Last Refreshed Date" Readout; Normalizing Your Measures to First/Average/Max Values for Charts; Bubbling Up Exceptions with "Sarah Problem"; Ranks and Exceptions That Bubble Up to Subtotals; Chapter 2: Slicers: The Gateway to Interactivity; "Initializing" Slicers That Contain Too Many Values to Scroll; Wingdings and Other Symbolic Fonts in Slicers; Using Macros to Change Slicer Fonts 327 $aA Simple Trick for Combatting "Stale" SlicersUser-Friendly Report Sorting with Slicers; Adding State Alpha Sorting to the Sort-by-Slicer Trick; Conditional Formatting Controlled via Slicers; Catching Slicer Selections in a Formula; Chapter 3: Conquering Common Calculated Column Conundrums; An Excel Pro's Primer on Calculated Columns; Subtotaling Calc Columns and the EARLIER() Function; Referencing the Previous Row and Similar Calcs; Referencing Rows "Within Range" of the Current Row; Totaling Data Table Values in Lookup Tables; CONTAINSX: Finding Matching Values in Two Tables 327 $aCONTAINSX Revisited: What Is the Match?Common Calendar Conundrums; Custom Calendar Conundrums; Chapter 4: Modeling and Portable Formulas; Integrating Data of Different "Grains"; A Mystifying and Awesome Solution for the Many-to-Many Problem; Calculating Same-Store Sales in Power Pivot; Same-Store Sales Continued: Using Store Open/Close Dates; Campaign Analysis: Seasonally Adjusted Measures; A/B Campaign Analysis with Start and End Date Slicers; Customers and Website Visitors: Percentage Who Return; Calculating Average Customer Age; Moving Averages, Sums, etc 327 $aMoving Averages Controlled by a SlicerChapter 5: Power Query; Combining Multiple Worksheets or Workbooks into a Single Power Pivot Table; Using Power Query to Merge CSV Files; Using Power Query to "Unpivot" a Table; Using Power Query to Create a Lookup Table from a Data Table; Creating a Calendar Table: Advanced Usage of Power Query; Chapter 6: Power View; How to Use Power View; Chapter 7: Power Map; Thank you; Index; More from Holy Macro! Books 330 $aPowerPivot is an amazing new add-in for Excel 2013 that allows business intelligence pros to process large amounts data. Although it is simple to use in a demo environment, analysts are likely to run into real-life scenarios that are difficult to solve. This guide, dedicated solely to the PowerPivot tool, provides techniques and solutions to real-world problems, including showing the Top N customers by using slicer filters, comparing budget to actuals, drilling across data instead of through data, and joining data from two different sources in a 606 $aElectronic spreadsheets$xComputer programs 608 $aElectronic books. 615 0$aElectronic spreadsheets$xComputer programs. 676 $a005.54 700 $aCollie$b Rob$0912731 702 $aHellyer$b Jocelyn 702 $aLiwam$b Nellie J. 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910458278803321 996 $aPower Pivot alchemy$92094784 997 $aUNINA