Reporting With Microsoft Sql Server 2012 (professional Experience Distilled) [Paperback]

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

Overview

• 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.

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!.

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