Reporting with Microsoft SQL Server 2012电子书

Reporting with Microsoft SQL Server 2012

Table of Contents

Reporting with Microsoft SQL Server 2012

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers, and more

Why subscribe?

Free access for Packt account holders

Instant updates on new Packt books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Errata

Downloading the color images of the book

Piracy

Questions

1. Getting Started with Reporting

Standard reporting with SSRS

Self-service reporting with Power View

Power View limitations

Reporting scenarios

Scenario 1

Scenario 2

Scenario 3

Scenario 4

Scenario 5

Scenario 6

Scenario 7

Scenario 8

Scenario 9

Scenario 10

Scenario 11

Scenario 12

Scenario 13

Summary

2. SSRS – Standard Reporting

Primary components of a report

Data source

Dataset

Report items

Additional components of a report

Report parameters

Expressions

Actions

Custom code

Report development environment

Server features and functionality

Choosing an installation mode – SharePoint Integrated versus Native

Scheduling

Subscriptions

Report snapshots

Caching

Data alerts

My Reports (Native mode only)

Linked reports (Native mode only)

Consuming reports

Online

Offline

Data feed

Extensibility

Security

Roles and permissions

Securing Report Server objects

Data security

Summary

3. Development Activity with SSRS

Prerequisites

Tutorial scenario

Creating a Reporting Services project

Creating a report object

Creating a shared data source

Adding reference to shared data source

Creating a dataset

Adding a report item

Deploying a report project

Summary

4. Power View – Self-service Reporting

Getting started

PowerPivot

Business Intelligence Semantic Model

Power View within SharePoint

Setup

Tabular model connection

Starting Power View connected to a tabular model connection

Multidimensional model connection

Starting Power View connected to a multidimensional model connection

Power View within Excel 2013

Setup

Data models

Starting Power View in Excel

Importing data into Excel

Adding data to a worksheet and inserting data into Power View

Not adding data to a worksheet and inserting data into Power View

Adding data to a worksheet and using PowerPivot

Not adding data to a worksheet and using PowerPivot

Data visualizations

The user interface

Enhancing data models

Deploying and sharing reports

Presentation modes

Reports with multiple views in Power View

Adding multiple views

Navigating among views

View filters

View preview images

Chart highlighting, slicers, and filtering

Chart highlighting

Slicers

Filtering

View-level/sheet-level filters

Visualization-level filters

Basic filters

Advanced filters

Search in filters

Sorting

Export reports to Microsoft Office PowerPoint

Design tips

Undo/Redo

Arranging visualizations

Fit to window

Pop out

Summary

5. Development Activity with Power View

Prerequisites

Tutorial scenario

Creating a BI Semantic Model (BISM) connection

Opening the Power View design interface

Creating bar charts

Creating pie charts

Creating column charts

Adding a slicer

Deploying reports to SharePoint

Summary

Index