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.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.
Download to your computer
Kindle Cloud Reader

Microsoft Excel 2013 Building Data Models with PowerPivot (Business Skills) 1st Edition

by
Alberto Ferrari (Author)
› Visit Amazon's Alberto Ferrari Page
Find all the books, read about the author, and more.
See search results for this author
Are you an author? Learn about Author Central
Alberto Ferrari (Author),
Marco Russo (Author)
› Visit Amazon's Marco Russo Page
Find all the books, read about the author, and more.
See search results for this author
Are you an author? Learn about Author Central
Marco Russo (Author)
4.7 out of 5 stars 34 customer reviews
ISBN-13: 978-0735676343
ISBN-10: 0735676348
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Sell yours for a Gift Card
We'll buy it for $6.56
Learn More
Trade in now
Have one to sell? Sell on Amazon

Sorry, there was a problem.

There was an error retrieving your Wish Lists. Please try again.

Sorry, there was a problem.

List unavailable.
Facebook Twitter Pinterest <Embed>
Buy new
$25.05
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.
Want it Saturday, April 2? Order within and choose Two-Day Shipping at checkout. Details
List Price: $39.99 Save: $14.94 (37%)
59 New from $21.30
FREE Shipping.
Qty:1
Microsoft Excel 2013 Buil... has been added to your Cart
Ship to:
Select a shipping address:
To see addresses, please
or
Please enter a valid US zip code.
or
More Buying Choices
59 New from $21.30 23 Used from $14.99
82 used & new from $14.99
See All Buying Options
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

Save Up to 90% on Textbooks Textbooks
$25.05 FREE Shipping. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

  • Microsoft Excel 2013 Building Data Models with PowerPivot (Business Skills)
  • +
  • Microsoft Excel 2013 Data Analysis and Business Modeling
Total price: $59.40
Buy the selected items together
NO_CONTENT_IN_FEATURE

Product Details

  • 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.3 x 1.1 x 8.9 inches
  • Shipping Weight: 1.6 pounds (View shipping rates and policies)
  • Average Customer Review: 4.7 out of 5 stars  See all reviews (34 customer reviews)
  • Amazon Best Sellers Rank: #41,553 in Books (See Top 100 in Books)

    •  Would you like to update product info or give feedback on images?

Customers Viewing This Page May Be Interested In These Sponsored Links

  (What's this?)
1.  New ASP.NET Spreadsheet opens new browser window
  -  
Excel inspired user experience Includes XLS, XLSX, CSV file support
www.devexpress.com/
2.  Data Analysis in Excel opens new browser window
  -  
SigmaXL User Friendly Excel Add-in For Graphical/Statistical Analysis
www.sigmaxl.com/
3.  Free Excel training opens new browser window
  -  
Financial modelling - Free course materials online.
www.financialtrainingassociates.com/

Customer Reviews

Top Customer Reviews

5.0 out of 5 starsPrepare to Master PowerPivot
By Oleg Gvozdenko on April 8, 2013
Format: Paperback
I got this book as part of the PowerPivot workshop that Marco and Alberto teach. I am about half-way through the book now, and I am at the point where I am starting to re-read chapters to make sure I fully understand the concepts. The material is dense with facts and examples, and the book will take you from 0 to 60 in the first few pages, especially if you have not had a lot of PowerPivot exposure prior to this.

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.
Comment 47 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
5.0 out of 5 starsHow to work with PowerPivot
By Michael Mclaughlin on January 1, 2014
Format: Paperback
I've worked with every release of Microsoft Excel, and I know it takes effort to keep up to date with certain releases. Clearly, the Data Analysis eXpression (DAX) Language introduced in Excel 2010 went unnoticed by many, which was sad. DAX is truly a powerful extension to the analytical and modeling approaches in Microsoft Excel.

I'd like to recommend this book to those who haven't learned or mastered how to use DAX in Excel 2010, 2011, or 2013 and those who want to master PowerPivot.

DAX works with tables but if you don't use tables, I guess you can skip DAX because you must have infinite time to produce marginal analytical outcomes (tongue in cheek humor). However, if you're like most folks, you want a book to get you up-to-speed quickly, and that's what this book will do for you.

Just a couple caveats, the book assumes:
- An intermediate knowledge of Excel functions
- Basic knowledge of SQL and database modeling concepts
- It introduces but doesn't cover all potential advance uses
- It discusses VBA approaches in one short chapter

If you're serious about Business Intelligence (BI), and familiar with getting your data from an Oracle, MySQL, SQL Server database or SharePoint server, this is a great book for you to learn PowerPivot and the DAX language.

Don't forget, you get best results when you pre-select data before applying analytics in Excel. Remember the more refined the data model you start with the easier it is to structure analytical tools to leverage the data model. While DAX is powerful, it doesn't replace the speed and query optimized behaviors of effective Oracle, MySQL, or SQL Server queries.
Comment 16 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
5.0 out of 5 starsPerfect book for the right audience
By Student on March 29, 2013
Format: Paperback
There is a certain niche audience for this book: intermediate to advanced excel users who aren't necessarily BI/datawarehousing types. If you are a fairly basic excel user, this would not be a book to start with. You should already know vlookups, pivot tables, etc. before getting into PowerPivot. And, if you are a grizzled BI professional, this may serve as a good reference, but you can breeze through parts of it.

I guess I'm pretty much the target audience here, then. I'm an all-day excel user, but had not yet gotten PowerPivot as my company was still on excel 2007. Moreover, I only have a passing familiarity with cubes and BI stuff, facts and dimensions and star schemas, oh my!

But I had heard about this PowerPivot fad (kidding!) and have been intrigued.

I recently upgraded to Excel 2013 on my home computer just so I could begin to play around with this new feature. While I don't love the look and feel of excel 2013, it was worth it.

Okay, enough about excel itself. What do I think of this book? Why did I choose this one over one of the many others? How the heck am I reviewing it before it has even been released? Do I like asking questions as a cheap rhetorical device before essentially answering them myself? YES! I also like to refer to myself in the third person, just to sound important.

As for the third question: I subscribe to an online library that, for some reason, already has this available.

Honestly, the main reason I chose this book over many others is that it has a very comprehensive coverage of the subject by authors who's previous book came highly recommended. Some books are more introductory (Jelen's), some focus on DAX alone, some are more for the Sharepoint stuff, this one seemed to have it all.Read more ›
Comment 35 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews

5.0 out of 5 starsAn exemplary guide to serious use of PowerPivot

I am only at the middle of chapter 12 but I feel compelled to recommend this book to anyone who wants to get serious about PowerPivot. Read more

Published 1 day ago by Jean
4.0 out of 5 starsFour Stars

It's a good book, course require it but I barely read it, don't have time, but book is good

Published 24 days ago by Likey
5.0 out of 5 starsFive Stars

One of the best books that I have ever owned. Love it. Thanks.

Published 2 months ago by Johary G
5.0 out of 5 starsBecome efficient Power Pivot user

Excellent book for someone who starts working with Power Pivot. It goes from essentials to more difficult topics still using examples to strengthen your understanding what has been... Read more

Published 7 months ago by Vaclav Ulrych
2.0 out of 5 starsAbsoulte waste of time

I brought this book to understand and master Powerpivot and DAX. Although I had learned the basics myself before the book came, I am really frustrated by the way this book is... Read more

Published 10 months ago by Tarar
5.0 out of 5 starsGood quality!

Brand new. Good quality!

Published 12 months ago by Jeffrey Xie
5.0 out of 5 starsBeware - NOT in color like shown in the kindle preview. Great text,...

Excellent text. This is a fantastic book. I wish I could give it higher, but I feel deceived, as the kindle preview had color screen shots. Read more

Published 12 months ago by R. Caplan
5.0 out of 5 starsA great book. Filled with some many important details about ...

A great book. Filled with some many important details about Excel 2013 PowerPivot! Thanks for making such a great book!

Published 14 months ago by Mike Excelisfun
5.0 out of 5 starsExcellent deep-dive into the inner workings of the DAX engine...

The authors are well known BI gurus, who have unique insight into how the PowerPivot DAX engine functions under different conditions. Read more

Published 15 months ago by John M. Mcnally
5.0 out of 5 starsGood Book

Good book get one if you are intersted in data analysis

Published 17 months ago by khaldoon Slaiai

Set up an Amazon Giveaway

Microsoft Excel 2013 Building Data Models with PowerPivot (Business Skills)
Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
This item: Microsoft Excel 2013 Building Data Models with PowerPivot (Business Skills)
Set up a giveaway

There's a problem loading this menu right now.

Learn more about Amazon Prime.



Pages with Related Products. See and discover other items: power query