skip to content
PowerPivot Alchemy : Patterns and Techniques for Excel. Preview this item
ClosePreview this item
Checking...

PowerPivot Alchemy : Patterns and Techniques for Excel.

Author: Bill Jelen; Rob Collie
Publisher: Chicago : Holy Macro! Books, 2014.
Edition/Format:   eBook : Document : EnglishView all editions and formats
Summary:
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  Read more...
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

 

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Additional Physical Format: Print version:
Jelen, Bill.
PowerPivot Alchemy : Patterns and Techniques for Excel.
Chicago : Holy Macro! Books, ©2014
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Bill Jelen; Rob Collie
ISBN: 9781615472147 1615472142
OCLC Number: 881571318
Description: 1 online resource (257 pages)
Contents: 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.

Abstract:

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.

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/881571318> # PowerPivot Alchemy : Patterns and Techniques for Excel.
    a schema:MediaObject, schema:CreativeWork, schema:Book ;
   library:oclcnum "881571318" ;
   library:placeOfPublication <http://dbpedia.org/resource/Chicago> ; # Chicago
   library:placeOfPublication <http://id.loc.gov/vocabulary/countries/ilu> ;
   schema:about <http://experiment.worldcat.org/entity/work/data/1373562621#CreativeWork/microsoft_powerpivot_computer_file> ; # Microsoft PowerPivot (Computer file)
   schema:about <http://dewey.info/class/005.54/e23/> ;
   schema:about <http://experiment.worldcat.org/entity/work/data/1373562621#Topic/electronic_spreadsheets_computer_programs> ; # Electronic spreadsheets--Computer programs
   schema:about <http://experiment.worldcat.org/entity/work/data/1373562621#CreativeWork/microsoft_excel_computer_file> ; # Microsoft Excel (Computer file)
   schema:bookFormat schema:EBook ;
   schema:contributor <http://experiment.worldcat.org/entity/work/data/1373562621#Person/collie_rob> ; # Rob Collie
   schema:creator <http://experiment.worldcat.org/entity/work/data/1373562621#Person/jelen_bill> ; # Bill Jelen
   schema:datePublished "2014" ;
   schema:description "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."@en ;
   schema:description "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."@en ;
   schema:exampleOfWork <http://worldcat.org/entity/work/id/1373562621> ;
   schema:genre "Electronic books"@en ;
   schema:inLanguage "en" ;
   schema:isSimilarTo <http://worldcat.org/entity/work/data/1373562621#CreativeWork/powerpivot_alchemy_patterns_and_techniques_for_excel> ;
   schema:name "PowerPivot Alchemy : Patterns and Techniques for Excel."@en ;
   schema:productID "881571318" ;
   schema:publication <http://www.worldcat.org/title/-/oclc/881571318#PublicationEvent/chicago_holy_macro_books_2014> ;
   schema:publisher <http://experiment.worldcat.org/entity/work/data/1373562621#Agent/holy_macro_books> ; # Holy Macro! Books
   schema:url <http://site.ebrary.com/id/10884980> ;
   schema:url <http://public.eblib.com/choice/publicfullrecord.aspx?p=1712158> ;
   schema:url <http://ebookcentral.proquest.com/lib/columbia/detail.action?docID=1712158> ;
   schema:url <http://ebookcentral.proquest.com/lib/ucm/detail.action?docID=1712158> ;
   schema:workExample <http://worldcat.org/isbn/9781615472147> ;
   wdrs:describedby <http://www.worldcat.org/title/-/oclc/881571318> ;
    .


Related Entities

<http://dbpedia.org/resource/Chicago> # Chicago
    a schema:Place ;
   schema:name "Chicago" ;
    .

<http://experiment.worldcat.org/entity/work/data/1373562621#Agent/holy_macro_books> # Holy Macro! Books
    a bgn:Agent ;
   schema:name "Holy Macro! Books" ;
    .

<http://experiment.worldcat.org/entity/work/data/1373562621#CreativeWork/microsoft_excel_computer_file> # Microsoft Excel (Computer file)
    a schema:CreativeWork ;
   schema:name "Microsoft Excel (Computer file)" ;
    .

<http://experiment.worldcat.org/entity/work/data/1373562621#CreativeWork/microsoft_powerpivot_computer_file> # Microsoft PowerPivot (Computer file)
    a schema:CreativeWork ;
   schema:name "Microsoft PowerPivot (Computer file)" ;
    .

<http://experiment.worldcat.org/entity/work/data/1373562621#Topic/electronic_spreadsheets_computer_programs> # Electronic spreadsheets--Computer programs
    a schema:Intangible ;
   schema:name "Electronic spreadsheets--Computer programs"@en ;
    .

<http://worldcat.org/entity/work/data/1373562621#CreativeWork/powerpivot_alchemy_patterns_and_techniques_for_excel>
    a schema:CreativeWork ;
   rdfs:label "PowerPivot Alchemy : Patterns and Techniques for Excel." ;
   schema:description "Print version:" ;
   schema:isSimilarTo <http://www.worldcat.org/oclc/881571318> ; # PowerPivot Alchemy : Patterns and Techniques for Excel.
    .

<http://worldcat.org/isbn/9781615472147>
    a schema:ProductModel ;
   schema:isbn "1615472142" ;
   schema:isbn "9781615472147" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.