Skip to main content
SpringerLink
Log in
Apress

PowerPivot for Business Intelligence Using Excel and SharePoint

  • Book
  • © 2011

Overview

Authors:
  1. Barry Ralston
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • 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.

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 34.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 44.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (11 chapters)

  1. Front Matter

    Pages i-xiii
    Download chapter PDF

  2. Getting Started with PowerPivot for Excel

    • Barry Ralston
    Pages 1-9

  3. Hello World, PowerPivot Style

    • Barry Ralston
    Pages 11-23

  4. Combining Data Sources

    • Barry Ralston
    Pages 25-41

  5. Data Analysis Expressions

    • Barry Ralston
    Pages 43-64

  6. A Method to the Madness

    • Barry Ralston
    Pages 65-92

  7. Installing PowerPivot for SharePoint

    • Barry Ralston
    Pages 93-126

  8. Collaboration, Version Control, and Management

    • Barry Ralston
    Pages 127-151

  9. PowerPivot As a Data Source

    • Barry Ralston
    Pages 153-188

  10. PowerPivot and SQL Server Reporting Services

    • Barry Ralston
    Pages 189-218

  11. PowerPivot and Predictive Analytics

    • Barry Ralston
    Pages 219-264

  12. Tips, Tricks, and Traps

    • Barry Ralston
    Pages 265-276

  13. Back Matter

    Pages 277-288
    Download chapter PDF
Back to top

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 author

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

Publish with us

Policies and ethics

Back to top

Search

Navigation