Professional Microsoft PowerPivot for Excel and SharePoint

by Sivakumar Harinath; Ron Pihlgren; Denny Guang-Yeu Lee

• ISBN13: 9780470912416
• ISBN10: 0470912413
• Copyright: 2010-06-01
• Publisher: Wrox

Summary

With PowerPivot, Microsoft brings the power of Microsoft's business intelligence tools to Excel and SharePoint users. Self-service business intelligence today augments traditional BI methods, allowing faster response time and greater flexibility. If you're a business decision-maker who uses Microsoft Office or an IT professional responsible for deploying and managing your organization's business intelligence systems, this guide will help you make the most of PowerPivot.Featuring insights and tips from the team that built the product, it offers a head start on mastering the features of PowerPivot. The companion Web site includes all the sample applications and reports discussed.Coverage includes: Self-Service Business Intelligence and Microsoft PowerPivot A First Look at PowerPivot Creating Self-Service Bi Applications Using PowerPivot Assembling and Enriching Data Self-Service Analysis and Reporting Preparing for SharePoint 2010 PowerPivot for SharePoint Setup and Configuration Troubleshooting, Monitoring, and Securing PowerPivot Services Diving into the PowerPivot Architecture Enterprise ConsiderationsYou'll learn to use PowerPivot with Excel and SharePoint to improve your business intelligence system.

Table of Contents

Introduction

Introduction

Self-Service Business Intelligence and Microsoft PowerPivot

A First Look at PowerPivot

Creating Self-Service Bi Applications Using PowerPivot

Assembling Data

Enriching Data

Self-Service Analysis

Self-Service Reporting

IT Professional

Preparing for SharePoint 2010

PowerPivot for SharePoint Setup and Configuration

Troubleshooting, Monitoring, and Securing PowerPivot Services

Diving into the PowerPivot Architecture

Enterprise Considerations

Appendix

Setting Up the SDR Healthcare Application

DAX Reference

Index

Table of Contents provided by Publisher. All Rights Reserved.