Reporting with Microsoft SQL Server 2012 (Professional Experience Distilled)

James Serra, Bill Anton

ISBN 10: 178217172X / ISBN 13: 9781782171720

Published by Packt Publishing 2014-03-18, 2014

About this Item

Seller Inventory # 6666-IUK-9781782171720

Bibliographic Details

• Title: Reporting with Microsoft SQL Server 2012 (Professional Experience Distilled)
• Publisher: Packt Publishing 2014-03-18
• Publication Date: 2014
• Language: English
• ISBN 10: 178217172X
• ISBN 13: 9781782171720
• Binding: Paperback
• Condition: New

About this title

Synopsis

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

About This Book

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

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!

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

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!

About the Author

James Serra

James Serra is an independent consultant with the title of 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, and 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. He has been, at times, 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.

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, and has a Bachelor of Science degree in Computer Engineering from UNLV.
Bill Anton

Bill Anton is an independent consultant whose primary focus is 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.