PacktLib: Reporting with Microsoft SQL Server 2012

Reporting with Microsoft SQL Server 2012

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Preface

Getting Started with Reporting

Standard reporting with SSRS

Self-service reporting with Power View

Power View limitations

Reporting scenarios

Summary

SSRS – Standard Reporting

Primary components of a report

Additional components of a report

Report development environment

Server features and functionality

Consuming reports

Summary

Development Activity with SSRS

Prerequisites

Tutorial scenario

Summary

Power View – Self-service Reporting

Getting started

PowerPivot

Business Intelligence Semantic Model

Power View within SharePoint

Power View within Excel 2013

Data visualizations

The user interface

Enhancing data models

Deploying and sharing reports

Presentation modes

Reports with multiple views in Power View

Chart highlighting, slicers, and filtering

Sorting

Export reports to Microsoft Office PowerPoint

Design tips

Summary

Development Activity with Power View

Prerequisites

Tutorial scenario

Summary

Index