Vai al contenuto principale della pagina
Autore: |
Collie Rob
![]() |
Titolo: |
Power Pivot alchemy : patterns and techniques for Excel / / Rob Collie and Bill Jelen ; cover design, Jocelyn Hellyer ; indexing, Nellie J. Liwam
![]() |
Pubblicazione: | Uniontown, Ohio : , : Holy Macro! Books, , 2014 |
©2014 | |
Descrizione fisica: | 1 online resource (257 p.) |
Disciplina: | 005.54 |
Soggetto topico: | Electronic spreadsheets - Computer programs |
Soggetto genere / forma: | Electronic books. |
Persona (resp. second.): | HellyerJocelyn |
LiwamNellie J. | |
Note generali: | Includes index. |
Nota di contenuto: | 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 |
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 | |
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 | |
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 | |
Sommario/riassunto: | 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 |
Titolo autorizzato: | Power Pivot alchemy ![]() |
ISBN: | 1-61547-214-2 |
Formato: | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione: | Inglese |
Record Nr.: | 9910458278803321 |
Lo trovi qui: | Univ. Federico II |
Opac: | Controlla la disponibilità qui |