Start reading PowerPivot for Advanced Reporting and Dashboards on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here or start reading now with a free Kindle Reading App.

Deliver to your Kindle or other device


Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.
PowerPivot for Advanced Reporting and Dashboards

PowerPivot for Advanced Reporting and Dashboards [Kindle Edition]

Robert Bosco J
4.0 out of 5 stars  See all reviews (1 customer review)

Print List Price: £24.99
Kindle Price: £9.26 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £15.73 (63%)
* Unlike print books, digital books are subject to VAT.


Amazon Price New from Used from
Kindle Edition £9.26  
Paperback £24.99  
Kindle Daily Deal
Kindle Daily Deal: At least 60% off
Each day we unveil a new book deal at a specially discounted price--for that day only. Learn more about the Kindle Daily Deal or sign up for the Kindle Daily Deal Newsletter to receive free e-mail notifications about each day's deal.

Special Offers and Product Promotions

  • Purchase any Kindle Book sold by and receive £1 credit to try out our Digital Music Store. Here's how (terms and conditions apply)

Product Description

Product Description

In Detail

Business intelligence technology gives an organization the power to make decisions using large volumes of data. By obtaining an adequate amount of data and integrating data from a variety of sources, a user can get a comprehensive knowledge of their business and business strategies. PowerPivot is a free add-in to the 2010 version of the spreadsheet application MS Excel. It extends the capabilities of the PivotTable data summarization and cross-tabulation feature with new features such as expanded data capacity, advanced calculations, the ability to import data from multiple sources, and the ability to publish workbooks as interactive web applications.

PowerPivot for Advanced Reporting and Dashboards will teach you the fundamentals of PowerPivot as well as how to use the different data types available. This book also discusses useful tips and tricks for handling and resolving errors that might pop up while creating your report. With this book, you will be able to create relevant BI reports quickly and efficiently.

Moving on from the basics, this book will explain the types of data sources that can be imported into PowerPivot. You will then delve into relationships, hierarchies, and data model creation using imported data. You will also learn how to employ DAX functions to transform unstructured data into structured data. Finally, this book will teach you how to create reports such as Pivot Tables, Pivot Charts, Slicers, KPIs, and Perspective reports using PowerPivot and how to publish them using the SharePoint server.


A step-by-step tutorial with focused examples that builds progressively from basic to advanced topics and helps you create business intelligence reports and dashboards quickly and efficiently using the PowerPivot add-in.

Who this book is for

This book is ideal for data analysts, reporting and MIS professionals, business analysts, managers, dashboard makers, business intelligence professionals, self-service business intelligence personnel, and students. It is assumed that you have basic data analysis skills and intermediate level Excel skills. Familiarity with Pivot Tables as well as basic knowledge of VBA scripting and SharePoint will be useful but not necessary.

About the Author

Robert Bosco J

Robert Bosco J is a BI Reports Developer and holds an international Master's degree in Business Intelligence from Université Tours François Rabelais, Blois, France, along with an internship as a BI Analyst at Yomii (a French e-commerce company for design products) in Paris, France. He has a Bachelor of Engineering degree in Computer Science from the Oxford Engineering college, Tiruchirappalli, India. Robert also worked as a Data Processing Executive at Meritgroup Ltd., India, before pursuing his Master's.

Product details

  • Format: Kindle Edition
  • File Size: 7353 KB
  • Print Length: 150 pages
  • Publisher: Packt Publishing (25 Nov 2013)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B00GX9FFK2
  • Text-to-Speech: Enabled
  • X-Ray:
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: #133,757 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

5 star
3 star
2 star
1 star
4.0 out of 5 stars
4.0 out of 5 stars
Most Helpful Customer Reviews
4.0 out of 5 stars A good intro to PowerPivot 9 Feb 2014
By Benbow
Format:Kindle Edition
PowerPivot for Advanced Reporting and Dashboards is a solid introduction to PowerPivot. If covers the basics, e.g. downloading and installing PowerPivot and the benefits of PowerPivot over plain old Excel, to more complex topics such as data modelling concepts and data analysis expressions.
Chapter 4 contains a well-explained run through of the process of creating reports, pivot tables and pivot charts, and introduces “slicers” (PowerPivot filters that provide interactive reporting features). There’s also some good detail on creating dashboards, i.e. a single view of multiple reports and how to deploy reports to SharePoint.
Overall, this is a good book. I think it is more useful to experienced Excel users looking for something more powerful – experienced users of other BI tools may find that they know much of the background material in this book already.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on (beta) 3.0 out of 5 stars  3 reviews
1 of 1 people found the following review helpful
3.0 out of 5 stars Good, but would like more 17 Dec 2013
By Mark Polino - Published on
Format:Kindle Edition
The title may be slightly misleading. PowerPivot for Advanced Reporting and Dashboard is actually and introduction to PowerPivot. At first glance it looks like an advanced book.

The book is fine but a good chunk of it is dedicated to simply getting PowerPivot installed and then another chunk applies to connecting it to SharePoint. It's a good starting point, but it's very definitely just a start.
2.0 out of 5 stars Not recommended 12 April 2014
By Dimitri Shvorob - Published on
Format:Kindle Edition
Wishing to learn about PowerPivot, I ordered four PowerPivot books - this one, plus those by Jelen, Ferrari and Russo, and Ralston - and had a quick look at each title, to see which one I prefer. "PowerPivot for advanced reporting and dashboards" immediately stood out as the book with the least substance and quality, and was summarily discarded. Sorry I am not going to detail - I just don't want to waste any more of my time on this clearly subpar product.
4.0 out of 5 stars Good Book but not advanced 30 Jan 2014
By Naz Hus - Published on
PowerPivot for Advanced Reporting and Dashboards teaches readers the fundamentals of PowerPivot as well as how to use the different data types available. The book is a good starting point and teaches the essentials well. However I wouldn't really say its advanced.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category