Buy used: $27.00
Get Fast, Free Shipping with Amazon Prime
FREE delivery May 1 - 3 on orders shipped by Amazon over $35
Or fastest delivery April 29 - May 1
Used: Acceptable | Details
Sold by book-exchange
Fulfilled by Amazon
Condition: Used: Acceptable
Comment: Well worn but still totally useable. Your satisfaction is guaranteed!

Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.

If you're a seller, Fulfillment by Amazon can help you grow your business. Learn more about the program.

Access codes and supplements are not guaranteed with used items.
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 Paperback – January 1, 2016

by Rob Collie (Author), Avichal Singh (Author)
4.5 4.5 out of 5 stars 979 ratings
See all formats and editions
Microsoft Power BI, including Power Pivot and Power Query, are a set of free add-ons to Excel that allow users to produce new kinds of reports and analyses that were simply impossible before.This book, printed in full-gorgeous color, gives you an overview of Power BI, Power Pivot and Power Query, and then dives into DAX formulas, the core capability of Power Pivot. Always from the perspective of the Excel audience.Written by the world's foremost Power BI bloggers and practitioners, the book's concepts and approach are introduced in a simple, 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. This book includes lessons on:-
  • difference between calculated columns and measures
  • how formulas can be reused across reports of completely different shapes
  • how to merge disjointed sets of data into unified reports
  • how to make certain columns in a pivot behave as if the pivot were filtered while other columns do not
  • how to create time-intelligent calculations in pivot tables such as "Year over Year" and "Moving Averages" whether they use a standard, fiscal, or a complete custom calendar.
  • how to leverage Power Query to make your Power Pivot models awesome!
  • how to use Power BI Desktop and PowerBI.com and how they fit into the Excel landscape
The "pattern-like" techniques and best practices contained in this book have been developed and refined over several 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 to you, within the pages of this easy-to-follow guide. This updated second edition covers new features introduced with Office 2016 and Power BI Desktop.
Previous page
  1. Print length
    308 pages
  2. Language
    English
  3. Publisher
    Holy Macro! Books
  4. Publication date
    January 1, 2016
  5. Dimensions
    8.25 x 0.6 x 10.5 inches
  6. ISBN-10
    1615470395
  7. ISBN-13
    978-1615470396
  8. See all details
Next page
Amazon First Reads | Editors' picks at exclusive prices

Editorial Reviews

From the Author

At PowerPivotPro, I have really enjoyed working with the Power Pivot and Power BI community. This book, with Rob Collie, was an effort to reach out and help an even greater audience. Little did I know what I was signing up for :-)

It was hard juggling book writing with the training/consulting/travel. But I am glad we persevered. Big thanks to our IndieGoGo crowdfunding supporters, who not only made it possible to print this book in full-gorgeous color, but also inspired us to burn the night oil in writing those last chapters.

I sincerely believe that Power Pivot and Power BI can transform the lives of Excel users worldwide - after all I was one of them. But change is hard, even when it's for the better. We hope we can help you go from Excel to Power BI with this book and our services at PowerPivotPro.

Power On!
-Avi Singh

From the Back Cover

Power Pivot for Excel and its close cousin Power BI Desktop are Microsoft's tightly-related pair of revolutionary analytical tools - tools that are fundamentally changing the way organizations work with data. We have repeatedly witnessed the "Power tools" transformative impact on the bottom line - far more robust and elegant than Excel alone, and much more agile and affordable than traditional BI tools. Their shared state of the art calculation engines (DAX and M) turn any PC into an analytical supercomputer, but the real secret is people - these tools are 100% learnable by today's users of Excel. The data revolution lays not in the hands of an elite few, but in YOUR hands, and we want to help you seize that opportunity.

Product details

  • Publisher ‏ : ‎ Holy Macro! Books; Second Edition, Second edition (January 1, 2016)
  • Language ‏ : ‎ English
  • Paperback ‏ : ‎ 308 pages
  • ISBN-10 ‏ : ‎ 1615470395
  • ISBN-13 ‏ : ‎ 978-1615470396
  • Item Weight ‏ : ‎ 2.06 pounds
  • Dimensions ‏ : ‎ 8.25 x 0.6 x 10.5 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