Skip to main content

Dashboards, PowerPivot, Slicers, and DAX

Things you can do with Excel 2010

Home
Why PowerPivot?
Dashboard Introduction
PowerPivot Example
PowerPivot Formulas
PowerPivot Resources
Consulting
PowerPivot Resources

1) Microsoft Resources


 

PowerPivot Tech Center

 

A collection of Microsoft resources including links to the PowerPivot download site.

 

2) The Best PowerPivot Books


 

PowerPivot for Excel 2010 Give Your Data Meaning by Russo and Ferrari

 

Best explanation of PowerPivot for the Excel Power User. Written for Excel users by two experts in BI systems. Excellent description of PowerPivot formulas.

Read two sample chapters from the book

 

 View the author's 2010 Presentation "Budgeting Solution Built with PowerPivot"


 

 

Pivot Table for the Data Analyst by Jelen

 

Excellent book on PowerPivot written by popular Excel author and trainer. Good insights into how to solve common Excel problems with PowerPivot.

  View videos by the author that accompany each chapter

3) The Best Dashboard Book


 

 

Information Dashboard Design by Few

 

Good book to gain some confidence with the concept of dashboards. Contains good common-sense advice.

Stephen Few is recognized as the leading authority on data visualization. This book contains many examples that illustrate his theories. Fun to look at and provides valuable perspectives.

 

About Stephen Few

 

About his books