Cargando…
PowerPivot alchemy : patterns and techniques for Excel /
PowerPivot 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...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Uniontown, Ohio :
Holy Macro!,
©2014.
|
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | EBOOKCENTRAL_ocn881474971 | ||
| 003 | OCoLC | ||
| 005 | 20240329122006.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 140618s2014 ohua o 001 0 eng d | ||
| 040 | |a VALIL |b eng |e rda |e pn |c VALIL |d IDEBK |d N$T |d VALIL |d TEFOD |d B24X7 |d YDXCP |d OCLCF |d TEFOD |d OCLCQ |d TEFOD |d COCUF |d AGLDB |d CNNOR |d OCLCQ |d OCLCO |d CCO |d LIV |d OCLCQ |d K6U |d U3W |d D6H |d STF |d VNS |d OCLCQ |d VTS |d VT2 |d COO |d MLSOD |d OCLCQ |d OCLCO |d G3B |d TKN |d M8D |d HS0 |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d OCLCL | ||
| 020 | |a 9781615472147 |q (electronic bk.) | ||
| 020 | |a 1615472142 |q (electronic bk.) | ||
| 020 | |a 9781615473373 |q (electronic bk.) | ||
| 020 | |a 1615473378 |q (electronic bk.) | ||
| 020 | |z 9781615470211 | ||
| 029 | 1 | |a AU@ |b 000054997955 | |
| 029 | 1 | |a AU@ |b 000066770212 | |
| 035 | |a (OCoLC)881474971 | ||
| 037 | |a 0007D689-E8D7-4F1B-B286-BC4CCBC84E16 |b OverDrive, Inc. |n http://www.overdrive.com | ||
| 050 | 4 | |a HF5548.4.M5258 | |
| 072 | 7 | |a COM |x 054000 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.54 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Collie, Rob, |e author. | |
| 245 | 1 | 0 | |a PowerPivot alchemy : |b patterns and techniques for Excel / |c by Rob Collie & Bill Jelen. |
| 246 | 3 | |a Power Pivot alchemy | |
| 264 | 1 | |a Uniontown, Ohio : |b Holy Macro!, |c ©2014. | |
| 300 | |a 1 online resource (xiv, 231 pages) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 500 | |a Includes index. | ||
| 588 | 0 | |a Print version record. | |
| 520 | |a PowerPivot 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 single analysis. | ||
| 505 | 0 | |a Cover; 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 | |
| 505 | 8 | |a A 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 | |
| 505 | 8 | |a CONTAINSX 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 | |
| 505 | 8 | |a Moving 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 | |
| 590 | |a ProQuest Ebook Central |b Ebook Central Academic Complete | ||
| 630 | 0 | 0 | |a Microsoft PowerPivot (Computer file) |
| 630 | 0 | 0 | |a Microsoft Excel (Computer file) |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file) |2 fast |
| 630 | 0 | 7 | |a Microsoft PowerPivot (Computer file) |2 fast |
| 650 | 0 | |a Electronic spreadsheets |x Computer programs. | |
| 650 | 6 | |a Tableurs |x Logiciels. | |
| 650 | 7 | |a COMPUTERS |x Desktop Applications |x Spreadsheets. |2 bisacsh | |
| 650 | 7 | |a Electronic spreadsheets |x Computer programs |2 fast | |
| 700 | 1 | |a Jelen, Bill. | |
| 758 | |i has work: |a PowerPivot alchemy (Text) |1 https://id.oclc.org/worldcat/entity/E39PCG8CqQbcbVYCyMjmYHCVcq |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Collie, Rob. |t PowerPivot alchemy. |d Uniontown, Ohio : Holy Macro!, ©2014 |z 9781615470211 |w (OCoLC)855200242 |
| 856 | 4 | 0 | |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=1712158 |z Texto completo |
| 938 | |a Books 24x7 |b B247 |n bko00065959 | ||
| 938 | |a EBSCOhost |b EBSC |n 800089 | ||
| 938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n cis28514801 | ||
| 938 | |a YBP Library Services |b YANK |n 11895015 | ||
| 994 | |a 92 |b IZTAP | ||