© 2011

PowerPivot for Business Intelligence Using Excel and SharePoint

  • Authors


  • Pivot for Business Intelligence Using Excel and Share.

  • Point takes a scenario-based approach to helping you master Microsoft's groundbreaking technology for data mining on the desktop.


Table of contents

  1. Front Matter
    Pages i-xiii
  2. Barry Ralston
    Pages 11-23
  3. Barry Ralston
    Pages 25-41
  4. Barry Ralston
    Pages 43-64
  5. Barry Ralston
    Pages 65-92
  6. Barry Ralston
    Pages 93-126
  7. Barry Ralston
    Pages 153-188
  8. Barry Ralston
    Pages 189-218
  9. Barry Ralston
    Pages 219-264
  10. Barry Ralston
    Pages 265-276
  11. Back Matter
    Pages 277-288

About this book


PowerPivot comprises a set of technologies for easy access to data mining and business intelligence analysis from Microsoft Excel and SharePoint. Power users and developers alike can create sophisticated, online analytic processing (OLAP) solutions using PowerPivot for Excel, and then share those solutions with other users via PowerPivot for SharePoint. Data can be pulled in from any of the leading database platforms, as well as from spreadsheets and flat files.

PowerPivot for Business Intelligence Using Excel and SharePoint is your key to mastering PowerPivot. The book takes a scenario-based approach to showing you how to collect data, to mine that data through insightful analysis, and to draw conclusions that drive business performance. Each chapter in the book is focused on a specific challenge that you’ll encounter when using PowerPivot. Each chapter takes you through a solution technique that’s been proven in the real world.

  • Covers the leading technology for bringing data analytics to the desktop
  • Presents real-world solutions to real-world scenarios
  • Written by a Microsoft Virtual Technical Specialist (VTS) for business intelligence

About the authors

Barry Ralston is the chief architect for business intelligence with Birmingham-based ComFrame Software. Barry is also Microsoft s Virtual Technical Specialist (VTS) for business intelligence, responsible for assisting in Alabama, Mississippi, and northwest Florida in sales efforts including customer meetings, software demonstrations and proof-of-concept efforts. Barry s client successes include: American Cast Iron Pipe Company, Georgia Tech Research Institute, Bank of Hawaii, Honda Manufacturing of Alabama and Aflac.

Bibliographic information