- Paperback: 336 pages
- Publisher: QUE; 1 edition (3 Jun. 2010)
- Language: English
- ISBN-10: 0789743159
- ISBN-13: 978-0789743152
- Product Dimensions: 17.5 x 2.3 x 22.6 cm
- Average Customer Review: 4.0 out of 5 stars See all reviews (9 customer reviews)
- Amazon Bestsellers Rank: 566,388 in Books (See Top 100 in Books)
- See Complete Table of Contents
PowerPivot for the Data Analyst: Microsoft Excel 2010 (MrExcel Library) Paperback – 3 Jun 2010
|New from||Used from|
- Choose from over 13,000 locations across the UK
- Prime members get unlimited deliveries at no additional cost
- Find your preferred location and add it to your address book
- Dispatch to this address when you check out
Frequently Bought Together
Customers Who Bought This Item Also Bought
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.
From the Back Cover
ANALYZE HUGE AMOUNTS OF BUSINESS DATA FASTER, MORE EASILY, AND MORE ACCURATELY! Use Microsoft's free PowerPivot add-in for Excel 2010 to analyze immense amounts of data from any source, perform state-of-the-art business analysis far more easily, and make better decisions in less time! Simple, step-by-step instructions walk you through installing PowerPivot, importing data, using PivotTables with PowerPivot, using super-powerful DAX functions and measures, reporting to print or SharePoint, and a whole lot more. Whatever your Excel data analysis experience, this book will help you use PowerPivot to get the right answers, right now-without IT's help! - Import and integrate data from spreadsheets, SQL Server, Access, Oracle, text files, Atom data feeds, and other sources - Analyze multiple tables together, without complicated VLOOKUPs - Format, sort, and filter data in the PowerPivot window - Add calculated columns using new DAX functions - Create powerful reports from PowerPivot data-and format them so executives instantly get your point - Discover PivotTable tricks that work even better in PowerPivot - Control multiple PivotTable elements on one worksheet, with one set of Excel 2010 Slicers - Use DAX Measures to quickly perform tasks that were difficult or impossible with Calculated Fields - Compare today's sales to yesterday's-or to sales from the parallel period last fiscal year. - Use Named Sets to prepare asymmetric reports, show actuals for past months and plan for future months. About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will - Dramatically increase your productivity-saving you 50 hours a year, or more - Present proven, creative strategies for solving real-world problems - Show you how to get great results, no matter how much data you have - Help you avoid critical mistakes that even experienced users make
About the Author
Bill Jelen , Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. Bill was a regular guest on Call for Help with Leo Laporte and has produced more than 1,200 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 30 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine. You will most frequently find Bill taking his show on the road, doing half-day Power Excel seminars wherever he can find a room full of accountants or Excellers. Before founding MrExcel.com, Jelen spent 12 years in the trenches working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He lives near Akron, Ohio, with his wife, Mary, Ellen and his sons, Josh and Zeke.
What Other Items Do Customers Buy After Viewing This Item?
Top Customer Reviews
Sample files are available but the book does not seem to mention the name of file(s) needed for a particular topic, although you can more-or-less match them to the chapter. However, some of the tables shown in the book have data that does not appear to be in any of the sample files so it would be necessary for you to create them yourself. I like to follow-along with the examples to get a good understanding of the subject but I have not been able to get past Page 2 of Chapter 5 - yes, I could create the three small tables but I then have to wonder how many more later in the book would also need to be created.
I therefore bought another book on the subject of PowerPivot/DAX formulas and that uses the Microsoft Northwind data - I have almost finished working through all the examples.
It seems that the MrExcel book was rushed to Press before being up to the usual MrExcel standard. If you intend only to read the book, it will probably be considered very good - if you want to try the examples yourself, you may be a bit frustrated by having to create some of the data yourself.
With that said, the dashboard layouts by PowerPivot look fabulous. They look more like website layouts and less like Excel spreadsheets. Plus, they are fully interactive.
PowerPivot For the Data Analyst: Microsoft Excel 2010 recognizes the potential of PowerPivot while keeping a tight grip on the limitations and inherent problems. In this way, the author provides a more realistic view of using PowerPivot while giving plenty of tips about how to get what you need from your data.
To take full advantage of the book, you will need to download PowerPivot itself and also the author's example files. There are 32-bit and 64-bit versions of PowerPivot and it is essential that you choose the one which matches your 32-bit or 64-bit version of Excel 2010.
The introductory chapter is a personal and interesting account which puts PowerPivot into context and shows the enthusiasm that Mr Excel has for his subject. After discussing how to obtain and install PowerPivot the book then begins to go into detail about how and when to use this application. Whilst it is clear that the author is a passionate advocate of PowerPivot, he is also critical of what he sees as shortcomings - for example, not easily being able to sort in month order - and he devotes a whole chapter to explaining the circumstances in which you might decide that a conventional pivot table might be a better approach.
The book gives detailed descriptions of the steps involved in many different tasks clearly illustrated with accompanying diagrams and supported by the exercise files that you can work through yourself.Read more ›
Which would be a shame as Power Pivot is an amazing bit of software; incredibly powerful, intuitive and as it turns out, you really don't need to read a book to use it.
If big data is your game, buy this book. If not, stick to regular pivots.
Most Recent Customer Reviews
I have received the text today.
It was well packaged and arrived in good condition.
I started reading it and the material is very well written. Read more
Bill Jelen's books are always well written and a worthwhile investment.
If you want to learn Powerpivot for Excel 2010 using the sample data that's available for this... Read more
This is a great book which clearly take you through what is a complicated topic. Powerpivot tables are a must for any true data analyst! Read morePublished on 10 Aug. 2010 by hjp