PowerPivot for Advanced Reporting and Dashboards
By Robert Bosco J
Publisher: Packt Publishing
Final Release Date: November 2013
Pages: 133

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.

Product Details
Recommended for You
Customer Reviews


by PowerReviews
oreillyPowerPivot for Advanced Reporting and Dashboards

(based on 1 review)

Ratings Distribution

  • 5 Stars



  • 4 Stars



  • 3 Stars



  • 2 Stars



  • 1 Stars



Reviewed by 1 customer

Displaying review 1

Back to top


A good intro to PowerPivot

By Benbow

from UK

Verified Reviewer



      Best Uses

      • Novice

      Comments about oreilly PowerPivot for Advanced Reporting and Dashboards:

      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.

      Displaying review 1

      Back to top

      Buy 2 Get 1 Free Free Shipping Guarantee
      Buying Options
      Immediate Access - Go Digital what's this?
      Ebook: $23.99
      Formats:  ePub, Mobi, PDF