Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports

  • 10h 39m
  • Paul Turley
  • John Wiley & Sons (US)
  • 2017

Optimize reporting and BI with Microsoft SQL Server 2016

Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports provides a comprehensive lesson in business intelligence (BI), operational reporting and Reporting Services architecture using a clear, concise tutorial approach. You'll learn effective report solution design based upon many years of experience with successful report solutions. Improve your own reports with advanced, best-practice design, usability, query design, and filtering techniques. Expert guidance provides insight into common report types and explains where each could be made more efficient, while providing step-by step instruction on Microsoft SQL Server 2016. All changes to the 2016 release are covered in detail, including improvements to the Visual Studio Report Designer (SQL Server Data Tools) and Report Builder, Mobile Dashboard Designer, the new Report Portal Interface, HTML-5 Rendering, Power BI integration, Custom Parameters Pane, and more.

The Microsoft SQL Server 2016 release will include significant changes. New functionality, new capabilities, re-tooled processes, and changing support require a considerable update to existing knowledge. Whether you're starting from scratch or simply upgrading, this book is an essential guide to report design and business intelligence solutions.

  • Understand BI fundamentals and Reporting Services architecture
  • Learn the ingredients to a successful report design
  • Get up to speed on Microsoft SQL Server 2016
  • Grasp the purpose behind common designs to optimize your reporting

Microsoft SQL Server Reporting Services makes reporting faster, easier, and more powerful than ever in web, desktop and portal solutions. Compatibility with an extensive variety of data sources makes it a go-to solution for organizations across the globe. The 2016 release brings some of the biggest changes in years, and the full depth and breadth of these changes can create a serious snag in your workflow. For a clear tutorial geared toward the working professional, Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports is the ideal guide for getting up to speed and producing successful reports.

About the Author

Paul Turley is an independent BI consultant and trainer, owner of Intelligent Business LLC and Mentor for SolidQ. He is a Microsoft Data Platform MVP and Microsoft Certified Trainer with multiple industry certifications, and teaches classes on SQL Server technologies to companies around the world. Paul has authored several books and courses on database and BI technologies.

In this Book

  • Foreword by Riccardo Muti
  • Foreword by Christopher Finlan
  • Introduction
  • Introducing Reporting Services
  • What's New in SQL Server 2016 Reporting Services?
  • Reporting Services Installation and Architecture
  • Report Layout and Formatting
  • Data Access and Query Basics
  • Grouping and Totals
  • Advanced Report Design
  • Graphical Report Design
  • Advanced Queries and Parameters
  • Reporting with Analysis Services
  • SSAS Reporting Advanced Techniques
  • Expressions and Actions
  • Report Projects and Consolidation
  • Report Solutions, Patterns, and Recipes
  • Integrating Reports into Custom Applications
  • Extending Reporting Services
  • Introducing Reporting Services Mobile Reports
  • Implementing a Mobile Report with Design-First Development
  • Mobile Report Design Patterns
  • Advanced Mobile Report Solutions
  • Content Management
  • Server Administration