$26.71 with 14 percent savings
List Price: $30.95

The List Price is the suggested retail price of a new product as provided by a manufacturer, supplier, or seller. Except for books, Amazon will display a List Price if the product was purchased by customers on Amazon or offered by other retailers at or above the List Price in at least the past 90 days. List prices may not necessarily reflect the product's prevailing market price.
Learn more
Get Fast, Free Shipping with Amazon Prime FREE Returns
FREE delivery Saturday, May 11 on orders shipped by Amazon over $35
Or fastest delivery Thursday, May 9. Order within 6 hrs 40 mins
In Stock
$$26.71 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$26.71
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Ships from
Amazon.com
Ships from
Amazon.com
Sold by
Amazon.com
Sold by
Amazon.com
Returns
Eligible for Return, Refund or Replacement within 30 days of receipt
Eligible for Return, Refund or Replacement within 30 days of receipt
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.
Read full return policy
Returns
Eligible for Return, Refund or Replacement within 30 days of receipt
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.
Read full return policy
Payment
Secure transaction
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
Payment
Secure transaction
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
Amazon book clubs early access
Loading your book clubs
There was a problem loading your book clubs. Please try again.
Not in a club? Learn more
Amazon book clubs early access

Join or create book clubs

Choose books together

Track your books
Bring your club to Amazon Book Clubs, start a new book club and invite your friends to join, or find a club that’s right for you for free.
Explore Amazon Book Clubs
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

Follow the authors

Rob Collie
Follow
Avichal Singh
Follow
Something went wrong. Please try your request again later.

Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016 Second edition

by Rob Collie (Author), Avichal Singh (Author)
4.5 4.5 out of 5 stars 979 ratings
See all formats and editions
{"desktop_buybox_group_1":[{"displayPrice":"$26.71","priceAmount":26.71,"currencySymbol":"$","integerValue":"26","decimalSeparator":".","fractionalValue":"71","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"TjT%2BO1%2Fz9hHMe0Fxv4C3rIpcLwx%2FOl9WFbyJvk5VCvQWwf1k%2FtvcWRNsRRcDqHdBeK9QknWBhFU5C5ktlJQFMfMITh7Jq01OEELxsf07eiR359TREibxbCXkd%2BhhiZsm0%2F8hQIaiiT1A5Q%2Br13IU0A%3D%3D","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}]}

Purchase options and add-ons

Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. Written by the world's foremost PowerPivot blogger and practitioner, the book's concepts and approach are introduced in a step-by-step manner tailored to the learning style of Excel users everywhere. The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce. The "pattern-like" techniques and best practices contained in this book have been developed and refined over two years of onsite training with Excel users around the world, and the key lessons from those seminars costing thousands of dollars per day are now available within the pages of this easy-to-follow guide. This updated edition covers new features introduced with Office 2015.
Previous page
  1. ISBN-10
    1615470751
  2. ISBN-13
    978-1615470754
  3. Edition
    Second edition
  4. Publisher
    Holy Macro! Books
  5. Publication date
    December 1, 2021
  6. Language
    English
  7. Dimensions
    8.5 x 0.73 x 11 inches
  8. Print length
    320 pages
  9. See all details
Next page
Amazon First Reads | Editors' picks at exclusive prices

Frequently bought together

Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016
$26.71
Get it as soon as Saturday, May 11
In Stock
Ships from and sold by Amazon.com.
+
Master Your Data with Power Query in Excel and Power BI: Leveraging Power Query to Get & Transform Your Task Flow
$21.99
Get it as soon as Saturday, May 11
In Stock
Ships from and sold by Amazon.com.
+
The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edi
$35.55
Get it as soon as Saturday, May 11
In Stock
Ships from and sold by Amazon.com.
Total price:
To see our price, add these items to your cart.
Details
Added to Cart
Choose items to buy together.

Editorial Reviews

About the Author

Avi Singh built a successful Power Pivot BI platform during his tenure at Microsoft. Avichal has a Masters in Computer Science from the University of Washington and spend 10+ years as a business analyst at Microsoft. Rob Collie, one of the founding engineers behind Power Pivot during his 14-year career at Microsoft and creator of the world's first Power Pivot service, is one of the foremost authorities on self-service business intelligence and next-generation spreadsheet technology. In 2010, he realized that Power Pivot was not "just another tech" and that its power resided not in the software itself, but in the unique way it empowers human beings. Inspired, he left Microsoft and founded a consulting and training company, P3Adaptive.com to make that human empowerment his full-time mission.

Product details

  • Publisher ‏ : ‎ Holy Macro! Books; Second edition (December 1, 2021)
  • Language ‏ : ‎ English
  • Paperback ‏ : ‎ 320 pages
  • ISBN-10 ‏ : ‎ 1615470751
  • ISBN-13 ‏ : ‎ 978-1615470754
  • Item Weight ‏ : ‎ 1.64 pounds
  • Dimensions ‏ : ‎ 8.5 x 0.73 x 11 inches
  • Customer Reviews:
    4.5 4.5 out of 5 stars 979 ratings

About the authors

Follow authors to get new release updates, plus improved recommendations.
Previous page
  1. Rob Collie

    Rob Collie

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    During his 13 years at Microsoft, Rob Collie led the BI-focused capabilities in Excel and was subsequently one of the founding engineers on Power BI. Through that insider’s perspective and experience with Microsoft, Rob developed successful and groundbreaking strategies that can be utilized across almost any industry. A sought-after public speaker and author of the #1-selling Power BI book, Rob and his team are relentlessly committed to “the new way forward,” making P3 a leading consulting firm in the industry, pioneering an agile, results-first methodology that bucks the traditional BI company model.

    See more on the author's page
  2. Avichal Singh

    Avichal Singh

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    Avichal “Avi” Singh - Principal Consultant at PowerPivotPro - has most recently worked at Microsoft, where he built a successful Power Pivot BI platform serving 600+ users – replacing the far more expensive and less effective BI methodology formerly utilized by that division. Avi has a Masters in Computer Science from the University of Washington and spent 10+ years as a business analyst across various verticals, helping transform data into insight.

    Avi has personally lived the amazing transformation that Power Pivot brings to our professional lives. His passion for empowering others led him, like Rob, to depart Microsoft and make that his full-time focus at PowerPivotPro. Since joining the team, Avi has worked closely with clients all over the US, including onsite engagements with NBC Universal and NASA.

    Avi brings an infectious energy to everything he does, which keeps everyone here on their toes. In between client engagements, he has co-authored the “Power Pivot and Power BI” book with Rob and is developing additional training modules for PowerPivotPro University.

    See more on the author's page
Next page

Customer reviews

4.5 out of 5 stars
4.5 out of 5
979 global ratings
Makes learning Power Pivot & Power BI a pleasure
5 Stars
Makes learning Power Pivot & Power BI a pleasure
Do you use Excel for more than 10 hours per week? Do you create pivot tables on a regular basis? If so, this book was written for you. Power Pivot and the standalone tool Power BI use DAX, a functional language similar to Excel formulas. Using plain language and a clear, step-by-step process, Rob and Avi introduce the reader to the fundamental concepts of data modeling and business intelligence reporting. They then move steadily to advanced concepts and applications, and the book can be used as a reference for challenging projects. Whether you are looking to supercharge your Excel analysis with a Power Pivot data model in the background, or looking to make stunning dashboards in Power BI, this guide will get you there.
Hide
Thank you for your feedback
Sorry, there was an error
Sorry we couldn't load the review

Top reviews from the United States

Stephanie Dean
5.0 out of 5 stars Many layers of depth in this book - for the beginner and advanced Power BI user
Reviewed in the United States on November 26, 2018
Verified Purchase
I have read the "first half" of this book at least 6 times now! Every time I read it, I got a little farther in my understanding and ability to use the concepts in my everyday work. Just today, after owning the book for almost 2 1/2 years and using it repeatedly as a reference guide, I finished the entire book with full understanding. Learning how to write DAX in Power Pivot has transformed my work, and this book has been my steady number one go-to reference among several books on Power BI that I have ordered over 2 1/2 years.
I decided to write a review today, because I want to share how important it is to take this in small pieces, and really use the power of self-discovery for many of the lessons in Rob and Avi's book. The book is very well written, in easy conversational tone, yet some of the concepts are very hard to grasp, and require lots of hands-on absorption to really understand. I now have a solid 2 1/2 years of intensive hands-on data modelling in Power Pivot under my belt. I have attended public classes, worked with a consultant on a big Power BI project, watched many you-tube videos, read and written blogs, and I even host a couple of Power BI user groups at my office. And yet STILL today, as I read all the way to the end of the book with full understanding for the first time, I caught some new concepts and had to think about it and absorb. This is a both a book for beginners, and it is a book for advanced users to absorb over time. I can't recommend it highly enough.
10 people found this helpful
Helpful
 Report
Edward J. Garrity
5.0 out of 5 stars A great book for all levels of users.
Reviewed in the United States on June 10, 2019
Verified Purchase
This is an excellent book to get you excited about the Microsoft family of Power Business Intelligence products. They provide a nice overview of where this set of products fits into the Microsoft scheme, why this is a very important and trending set of tools to know, and the text gets you very excited to learn more. The writing style is fun and easy and you will find yourself excited to learn more. They provide numerous examples to illustrate concepts and power, and the style of writing is wonderful for this topic. They take an approach from broad overview to beginning commands and usage and then they step you right into very powerful features. I agree with other reviewers that state that you will find yourself going back to this book again and again to re-read and uncover subtleties that you missed the first time. It is just that MS Power Pivot (Excel and Power BI, with DAX) is a very new and powerful way to create looks at data. This is a great book to buy. The topic is complicated enough that you will want to buy more books to get a different perspective. But, this book is good for all levels and I found it a good place to start.
One person found this helpful
Helpful
 Report
E. Hansberry
4.0 out of 5 stars Great book - highly recommended. Accompanying Excel files not quite as helpful
Reviewed in the United States on July 8, 2016
Verified Purchase
I have years experience working with Excel pivot tables and using Microsoft Access databases as a backend. I just recently got a copy of Excel 2016 and wanted something to help me get started with PowerPivot and the DAX engine. The UI and terminology is just different enough I didn't want to slog through it myself.

This book has been perfect in that respect. It starts off assuming you have a good working knowledge of things like tables, relationships, pivot tables, and databases in general, and then shows you how to plug the DAX engine into all of that. This is not a book for Excel Pivot Table beginners, but a book for DAX/PowerPivot beginners.

I disagree with some of the reviewers that the book needs an editor. I've personally not found that to be the case. I found the writing style engaging, with complex subjects approached from different angles.

One issue I have with the book, and the reason I gave it 4 stars instead of 5, is the content that comes with it. The book has no files or CD inside, but it has a link to a ZIP file on their web site with all sorts examples. The problem is everything is done. So when you open up the workbook for CHAPTER 6, there is nothing to do but look at it. I found myself deleting a bunch of stuff, which is tedious as you cannot bulk-delete Measures in PowerPivot.

As much of the book seems to build not only in concept through each chapter, but also with the data model, I went back and grabbed the CHAPTER 4 workbook. This is where the meat of the book really starts. I am working back through to chapter 9 (my current position in the book) and building the Measures, Calculated Columns, etc. which is a much better learning experience for me instead of just looking at formulas in the book and confirming that those are the same formulas in the finished workbooks.

I would really like to give it better than 4 stars, but since it is a book designed to teach, it should be really good at it. The fully completed examples simply fail to teach.

That said, I wholeheartedly recommend this book. I am glad it was my first choice.
26 people found this helpful
Helpful
 Report
Robert D Collet
5.0 out of 5 stars Excellent resource for starting your Power Pivot and BI journey
Reviewed in the United States on March 10, 2016
Verified Purchase
The first thing you notice about the hardcopy book is the very high quality of the pages and the colors in the illustrations. The book is actually heavy - probably because of all the ink that is in it. In my 40 years as an engineer and student I don't recall ever having a technical book that was so pleasant to hold and read. The content is the highest quality too. I covers the basics of the data model to calculated columns and measures. It covers cube formulas, time intelligence and advanced features such as variables. It covers Power Query well; but leaves plenty of room to justify reading M is for Data Monkey by Puls and Escobar. Collie and Singh provide a good explanation of the relationship between Power Pivot and the Microsoft BI platform and SSAS Tabular. The book covers well the DAX programming language including new functions for 2016. The book would be complete if it covered DAX as a query language too. I highly recommend this book because it is very example-driven and practical. It is a great complement to Ferrari and Russo's Building Data Models with Power Pivot which heavier on theory. Both these books, amd M if for Data Monkey are what you would use to help you design and build complex business inteligence systems.
7 people found this helpful
Helpful
 Report

Top reviews from other countries

Translate all reviews to English
BI Analyst
5.0 out of 5 stars Comprehensive and rich content on DAX and Power Pivot
Reviewed in Italy on January 24, 2024
Verified Purchase
I can recommend this book, both for new BI analysts as to those who have experience. It contains a lot of explanation about DAX, measures, calculated columns, Power Query and how these components interact with each other. Also good explanation about filter and row context and how these work in pivot tables.
Report
Gonçalo
5.0 out of 5 stars Crazy Book
Reviewed in Spain on April 30, 2021
Verified Purchase
One of the best books I have read in terms of organizing and planning the learning of those who read it. The way it is written is similar to having an instructor by the side. It is worth every cent, in fact, it could cost 10x more and would continue to be a good buy.
Report
Cliente de Amazon
5.0 out of 5 stars Un gran libro
Reviewed in Mexico on May 13, 2020
Verified Purchase
Totalmente recomendable, una manera muy orgánica de empezar a aprender a usar las herramientas de Power Pivot y su funcionalidad con Power BI
Report
Dhaval Patel
5.0 out of 5 stars Game Changer: Excel Pro --> Excel GOD!
Reviewed in Canada on April 15, 2018
Verified Purchase
This book is the single tool that will take you from being "just another" Excel Wiz to an Excel GOD. Power Pivot and Power BI are rapidly changing the world and the work of Rob Collie and Avi Singh ensure that the knowledge to use these 2 incredible tools is readily available to anyone who is willing to learn. The authors do an excellent job catering to EVERYONE's learning style: We got pictures (colored too!) and practice files for Kinesthetic (hands-on) learners, we got tons of applied examples for auditory and visual learners and best of all loads of delicious THEORY for those who really want to go behind the scenes (authors allow you to skip these very "dry" chapters as necessary). I am very blessed to have found this book and I can proudly say it is my one and only resource I used to learn Power Pivot and Power BI, implement my learnings at work and make the case for the entire Organization to implement it across the business. Thanks Rob and Avi!
One person found this helpful
 Report
Weliton
5.0 out of 5 stars Excelente
Reviewed in Brazil on February 17, 2018
Verified Purchase
Excelente livro.

O tamanho da fonte é importante. NUNCA CRIE LIVROS COM FONTES PEQUENAS. SEU LIVRO PENSOU EM TUDO. MATERIAL EXCELENTE. COMPREM, VALE A PENA.
PARABÉNS, EXCELENTE...
FEEDBACK: VOCÊS VENDEM SEUS LIVROS PARA PESSOAS ESTRANGEIRAS. DEIXE UM ESPAÇO ENTRE LINHAS MAIOR PARA QUE AS PESSOAS TRADUZAM (PUXEM UMA SETINHA E ANOTEM A TRADUÇÃO). PARABÉNS ATÉ NISSO VOCÊS PENSARAM, PODE ATÉ NÃO TER PENSADO, MAIS ACABOU DANDO CERTO. COMPREM VALE A PENA! ACONSELHO...
One person found this helpful
 Report