PacktLib: PowerPivot for Advanced Reporting and Dashboards

PowerPivot for Advanced Reporting and Dashboards

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

Principles and Installing PowerPivot

The principle of PowerPivot for Excel

Benefits of using PowerPivot

Installing PowerPivot

Testing the PowerPivot add-in

Summary

Preparation Analysis of Data Source

List of data sources

Purpose of importing data from a variety of sources

Adding a data source in a single worksheet from a variety of data sources

Data refresh

Summary

Data Model

General overview of a data model

A data model in PowerPivot

Sales analysis data model design process

E-commerce data model design process

Summary

Business Intelligence Solutions Analysis

A general overview of BI reports creation

Creating a report using the PowerPivot interface

Summary

Publishing Reports Using the SharePoint Server

PowerPivot for SharePoint

Deploying the reports in a PowerPivot site

Summary

Index