Reporting with Microsoft SQL Server 2012

Learn to quickly create reports in SSRS and Power View as well as understand the best use of each reporting tool.

Reporting with Microsoft SQL Server 2012

James Serra, Bill Anton

1 customer reviews
Learn to quickly create reports in SSRS and Power View as well as understand the best use of each reporting tool.
Mapt Subscription
FREE
$29.99/m after trial
eBook
$14.70
RRP $20.99
Save 29%
Print + eBook
$34.99
RRP $34.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$14.70
$34.99
$29.99p/m after trial
RRP $20.99
RRP $34.99
Subscription
eBook
Print + eBook
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
Code Files
Preview in Mapt

Book Details

ISBN 139781782171720
Paperback142 pages

Book Description

Reporting with Microsoft SQL Server 2012 will cover all the features of SSRS and Power View and will provide a step-by-step lab activity to help you develop reports very quickly.

Starting with the difference between standard and self- service reporting, this book covers the main features and functionality offered in SQL Server Reporting Services 2012 including a breakdown of the report components, development experience, extensibility, and security. You will also learn to set up and use Power View within Excel and SharePoint and connect to a tabular model as well as a multidimensional model. The book provides real-life reporting scenarios that help to clarify when those scenarios are discussing standard reporting, in which case SSRS is the best choice, and when they are discussing self-service reporting, in which case Power View is the best choice.

This book will have you creating reports in SSRS and Power View in no time!

Table of Contents

Chapter 1: Getting Started with Reporting
Standard reporting with SSRS
Self-service reporting with Power View
Power View limitations
Reporting scenarios
Summary
Chapter 2: SSRS – Standard Reporting
Primary components of a report
Additional components of a report
Report development environment
Server features and functionality
Consuming reports
Summary
Chapter 3: Development Activity with SSRS
Prerequisites
Tutorial scenario
Summary
Chapter 4: 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
Chapter 5: Development Activity with Power View
Prerequisites
Tutorial scenario
Summary

What You Will Learn

  • Get to grips with reporting scenarios that describe the best reporting tool to use
  • Follow the step-by-step exercises to build a report in SSRS and Power View
  • Visualize and interact with data in bold new ways with Power View
  • Generate reports quickly using intuitive interfaces
  • Create self-service reports with a wide variety of formats

Authors

Table of Contents

Chapter 1: Getting Started with Reporting
Standard reporting with SSRS
Self-service reporting with Power View
Power View limitations
Reporting scenarios
Summary
Chapter 2: SSRS – Standard Reporting
Primary components of a report
Additional components of a report
Report development environment
Server features and functionality
Consuming reports
Summary
Chapter 3: Development Activity with SSRS
Prerequisites
Tutorial scenario
Summary
Chapter 4: 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
Chapter 5: Development Activity with Power View
Prerequisites
Tutorial scenario
Summary

Book Details

ISBN 139781782171720
Paperback142 pages
Read More
From 1 reviews

Read More Reviews

Recommended for You

SQL Server Analysis Services 2012 Cube Development Cookbook Book Cover
SQL Server Analysis Services 2012 Cube Development Cookbook
$ 35.99
$ 25.20
Microsoft Tabular Modeling Cookbook Book Cover
Microsoft Tabular Modeling Cookbook
$ 32.99
$ 23.10
Oracle Hyperion Interactive Reporting 11 Expert Guide Book Cover
Oracle Hyperion Interactive Reporting 11 Expert Guide
$ 32.99
$ 23.10
SQL Server 2012 with PowerShell V3 Cookbook Book Cover
SQL Server 2012 with PowerShell V3 Cookbook
$ 35.99
$ 25.20
Microsoft SQL Server 2012 Performance Tuning Cookbook Book Cover
Microsoft SQL Server 2012 Performance Tuning Cookbook
$ 35.99
$ 25.20
Learning SQL Server Reporting Services 2012 Book Cover
Learning SQL Server Reporting Services 2012
$ 32.99
$ 23.10