PowerPivot for the Data Analyst
and over one million other books are available for Amazon Kindle .
Learn more
| |||||||||||||||
 Trade In this Item for up to £6.25
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in PowerPivot for the Data Analyst: Microsoft Excel 2010 (MrExcel Library) for an Amazon.co.uk gift card of up to £6.25, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Frequently Bought Together
Product details
|
More About the Author
Product Description
Product Description
Business intelligence (BI) tools make it possible for companies to gain deep, actionable insights for faster, better decision-making - and greater competitiveness. Until recently, however, access to BI has largely been restricted to experts using complex, specialized tools. With PowerPivot for Excel 2010, Microsoft has changed that. Together with SQL Server 2008 and Microsoft's new SharePoint Analysis Services, PowerPivot makes advanced business intelligence available to any mainstream business user working with Excel 2010. Of course, having the tools isn't enough: you must learn how to use them. That's where PowerPivot for the Data Analyst comes in. In this book, legendary Excel expert and instructor Bill Jelen shows exactly how to use PowerPivot to gain deep, actionable insights for more effective business decision-making. Using concrete examples and real-life scenarios, Jelen walks through setting up PowerPivot and integrating multiple data sources; creating and sharing dynamic dashboards; slicing and dicing to perform fast, interactive, ad hoc analyses; leveraging Excel's familiar features in advanced BI applications; and much more. This book is part of the new MrExcel Library series.
- The first book on PowerPivot, the breakthrough Microsoft technology that can extend business intelligence to any Excel user
- Use PowerPivot, SharePoint Analysis Services, and Microsoft SQL Server together, to slice and dice huge amounts of data, and create and share powerful business models
- Written by Microsoft MVP Bill Jelen ("MrExcel"), as part of his new MrExcel Library series
About the Author
Bill Jelen known worldwide as MrExcel, presents live Excel seminars to accountants throughout the U.S. His 20 books on Microsoft Excel include Special Edition Using Excel 2007, Pivot Table Data Crunching, and VBA and Macros for Microsoft Excel. Honored by Microsoft as an Excel MVP, he has produced 500 episodes of the "Learn Excel from MrExcel" video podcast.
Inside This Book
(Learn More)
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
7 of 7 people found the following review helpful
Format:Paperback|Amazon Verified Purchase
I would normally recommend Bill Jelen's books without hesitation (I do have many of them) but I was very disappointed with this book (PowerPivot for the Data Analyst).
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.
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.
4 of 4 people found the following review helpful
Format:Paperback
PowerPivot is an add-in for Excel. This program within a program is not really aimed at the average person, it is meant for high end analysis. Basically, if your data analysis involves millions of entries and requires that you compare several complex data sets, then PowerPivot might be for you. Otherwise, you might do better sticking with Excel.
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.
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.
3 of 3 people found the following review helpful
Format:Kindle Edition
The author spends so much time complaining about various things that by the end of the book you'll be forgiven if you didn't bother installing Power Pivot - as I nearly didn't.
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.
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.
Would you like to see more reviews about this item?
Were these reviews helpful?
Let us know
Most Recent Customer Reviews
Excellent introduction to PowerPivot
This book examines in detail PowerPivot which is a free add-in for Excel 2010. It makes possible the analysis of very large amounts of data normally beyond the capability of Excel. Read more
Published 17 months ago by Max Woodhead
Powerpivot for Excel 2010
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
If you want to learn Powerpivot for Excel 2010 using the sample data that's available for this... Read more
Published 20 months ago by eccles42
Awesome review of powerpivotting!
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 more
Published 22 months ago by hjp
another microsoft business intelligence tool
Don't have Powerpivot installed and fast read this book. The negatives as well as positives clearly explained so I quickly grasped how this new tool may fit in to a low cost... Read more
Published 22 months ago by ferux
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
