Reporting with Microsoft SQL Server 2012


Reporting with Microsoft SQL Server 2012
eBook: $20.99
Formats: PDF, PacktLib, ePub and Mobi formats
$17.85
save 15%!
Print + free eBook + free PacktLib access to the book: $55.98    Print cover: $34.99
$52.84
save 6%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Reviews
Support
Sample Chapters
  • Empowers a highly visual design experience
  • Increase productivity and proactive intelligence through operational or ad hoc reports
  • 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 get you developing reports very quickly.  You will learn the strengths and weaknesses of each tool so you understand the best tool to use for the various reporting scenarios you will encounter.

Book Details

Language : English
Paperback : 142 pages [ 235mm x 191mm ]
Release Date : March 2014
ISBN : 178217172X
ISBN 13 : 9781782171720
Author(s) : James Serra, Bill Anton
Topics and Technologies : All Books, Enterprise Products and Platforms, Enterprise


Table of Contents

Preface
Chapter 1: Getting Started with Reporting
Chapter 2: SSRS – Standard Reporting
Chapter 3: Development Activity with SSRS
Chapter 4: Power View – Self-service Reporting
Chapter 5: Development Activity with Power View
Index
  • Chapter 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
  • Chapter 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
  • Chapter 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
  • Chapter 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
  • Chapter 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

James Serra

James Serra is an independent consultant with the title Data Warehouse/Business Intelligence Architect. He is a Microsoft SQL Server MVP with over 25 years of IT experience. He started his career as a software developer, then was a DBA for 12 years, and for the last seven years, he has been working extensively with Business Intelligence using the SQL Server BI stack. At different times, he has been a permanent employee, consultant, contractor, and owner of his own business. All these experiences, along with continuous learning, have helped him to develop many successful data warehouse and BI projects. He is a noted blogger and speaker, having presented at the PASS Summit and the PASS Business Analytics conference. His blog is at JamesSerra.com.

He has earned the MSCE: SQL Server 2012 Business Intelligence, MSCE: SQL Server 2012 Data Platform, MCITP: SQL Server 2008 Business Intelligence Developer, MCITP: SQL Server 2008 Database Administrator, and MCITP: SQL Server 2008 Database. He has a Bachelor of Science degree in Computer Engineering from UNLV.

James resides in Houston, TX, with his wife Mary and three children: Lauren, RaeAnn, and James.


Bill Anton

Bill Anton is an independent consultant whose primary focus is on designing and developing data warehouses and Business Intelligence solutions using the Microsoft BI stack. He has over 10 years of experience in the industry, and enjoys working closely with clients to overcome their data-related challenges. Bill is also an active member in the SQL Server community and enjoys sharing knowledge and helping others. When he's not working with the clients, he can usually be found answering questions on the MSDN forums, attending SQL PASS meetings, or writing blog posts at http://byoBI.com.

Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

Sample chapters

You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

Frequently bought together

Reporting with Microsoft SQL Server 2012 +    Haskell Data Analysis Cookbook =
50% Off
the second eBook
Price for both: $38.55

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

What you will learn from this book

  • 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

In Detail

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!

Approach

This is a step-by-step tutorial that deals with Microsoft Server 2012 reporting tools:SSRS and Power View.

Who this book is for

If you are a BI developer, consultant, or architect who wishes to learn how to use SSRS and Power View, and want to understand the best use for each tool, then this book will get you up and running quickly. No prior experience is required with either tool!

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software