Minecraft Adventures B2G1 Free
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Original Essays | August 18, 2015

    Rinker Buck: IMG Just Passing Through: Embracing the Covered Wagon Mind-Set



    When people learn that I recently spent a long summer riding 2,000 miles across the Oregon Trail in a covered wagon pulled by mules, they invariably... Continue »
    1. $19.60 Sale Hardcover add to wish list

    spacer
Qualifying orders ship free.
$29.95
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
12 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets

PowerPivot Alchemy: Patterns and Techniques for Excel

by

PowerPivot Alchemy: Patterns and Techniques for Excel Cover

 

Synopses & Reviews

Publisher Comments:

Rob Collie (PowerPivotPro) and Bill Jelen (MrExcel) join forces in this combined sequel to their best-selling Power Pivot books. Alchemy sets aside the fundamentals of past books and provides a series of practical, easy-to-follow “patterns” for dozens of common analysis, reporting, and dashboarding needs. Three “bonus” chapters introduce you to the newer members of the “Power BI” family – Power Query, Power View, and Power Map. Whether you are starting your transformation from “old school” Excel User to Modern Data Professional or a veteran of the Power BI arts, this book will dramatically expand your data superpowers.

Synopsis:

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.

About the Author

Bill Jelen is the host of MrExcel.com and the author of 40 previous books about Microsoft Excel. He has been named a Microsoft MVP for 7 years and is a contributor to CFO Magazine and Strategic Finance Magazine. He lives in Akron, Ohio. Rob Collie is chief technology officer at Pivotstream LLC, where he and other Excel pros utilize PowerPivot to provide actionable business information to dozens of Fortune 500 corporations. He spent 13 years at Microsoft where he led teams of software engineers on projects including PowerPivot v1, multiple versions of Excel, Windows Installer (MSI) v1, the Bing search engine, and MSN Fantasy Sports. He is also the worlds most prolific PowerPivot blogger, running the PowerPivotPro.com and PowerPivotFAQ.com websites since late 2009. He is the author of DAX Formulas for PowerPivot and PowerPivot for Excel. He lives in Cleveland Heights, Ohio.

Product Details

ISBN:
9781615470211
Author:
Collie, Rob
Publisher:
Holy Macro! Books
Author:
Jelen, Bill
Subject:
Spreadsheets - General
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Copyright:
Edition Description:
Trade Paper
Publication Date:
20140631
Binding:
TRADE PAPER
Language:
English
Pages:
223
Dimensions:
10 x 8 in

Related Subjects

Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets
Engineering » Civil Engineering » General
Health and Self-Help » Self-Help » Self Esteem
Religion » Christianity » Pastoral Ministry and Church Leadership

PowerPivot Alchemy: Patterns and Techniques for Excel New Trade Paper
0 stars - 0 reviews
$29.95 In Stock
Product details 223 pages Holy Macro! Books - English 9781615470211 Reviews:
"Synopsis" by ,

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.

spacer
spacer
  • back to top

FOLLOW US ON...

       
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.