- Series: Business Skills
- Paperback: 500 pages
- Publisher: Microsoft Press; 1 edition (March 25, 2013)
- Language: English
- ISBN-10: 0735676348
- ISBN-13: 978-0735676343
- Product Dimensions: 7.4 x 1.1 x 8.9 inches
- Shipping Weight: 1.6 pounds (View shipping rates and policies)
- Average Customer Review: 42 customer reviews
- Amazon Best Sellers Rank: #154,464 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Microsoft Excel 2013 Building Data Models with PowerPivot (Business Skills) 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
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 increase your sales. We invite you to learn more about Fulfillment by Amazon .
Frequently bought together
Customers who bought this item also bought
Customers who viewed this item also viewed
About the Author
Alberto Ferrari has achieved Microsoft SQL Server Analysis Services (SSAS) Maestro status and is a consultant and trainer who specializes in developing Microsoft BI solutions. He is the coauthor of Microsoft PowerPivot for Excel 2010 and Expert Cube Development with Microsoft SQL Server 2008 Analysis Services and SQLBI Methodology.
Author interviews, book reviews, editors picks, and more. Read it now
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
The only aspect I was disappointed with are the sample excel workbooks that go along with each chapter. At times I found them to be incomplete, in terms of following the examples that are cited in the text. This can be frustrating when trying to understand new concepts. However, the book is brilliant, so this doesn't discourage me from giving it 5 stars.
This book is even better. It shows key differences between the previous version of PowerPivot as well as traditional Pivot in a detailed manner.
It also shows how the approach needs to be different for PowerPivot vs PowerView based BI.
I recommend this book to everyone who needs to go beyond Pivot Tables (which actually means everyone who creates reports in Excel). Yes. There is a constraint because everyone does not have Excel 2013. But from my point of view the business benefits you will get due to better analytics using PowerPivot alone will pay for the incremental cost of upgrade within few months!
In the advanced part of the book we will learn to master the use of DAX as a querying language and a sort of different approaches to daily-to-daily problems in your work.
The great thing about this book is that the authors were able to combine their great technical knowledge with the experience of having teached Dax for the last two years to Excel users all over the world. They know where the difficulities lie, which concepts are difficult grasp for an Excel user and how to best explain them so that they are easily understood.
In case you are using Excel 2010, it is still extremely useful, as only a small portion of the book is limited to things only available in Excel 2013, and it might be good to know about them anyway.
The pace of new information introduction seems to accelerate, and there is more and more reliance on you remembering concepts from earlier in the book, that some may find a bit discouraging (for a shot of confidence boost, check out Collie's book, which is a fantastic beginner's book). I think an expectation on the author's part is that the reader will not understand everything on the first try, and will re-read sections for more complete understanding - just be prepared for that.
I read 4 PowerPivot books so far, and while some go mile wide and a foot deep (Jelen's book), and others go foot wide and a mile deep (Collie's book), this one tries (and does) boil the entire ocean. The book has both a technical edge of thorough, complex DAX scenarios with explanations of potential errors and why the errors occur, and a more conceptual side, which goes in some depth explaining Data Modeling and thinking in Evaluation Context terms.
At its current Amazon price, it is an extremely great value. It is THE book if you want to master PowerPivot. If you are more of a casual user, you may find it more challenging than necessary, but the sections on CALCULATE and Evaluation Context are truly invaluable and are not really well-covered in other books, so it is well worth getting this book just for that.