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.
Autorentext
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. He blogs at SqlServerBiBlog.com.
Visit us at wrox.com where you have access to free code samples, Programmer to Programmer forums, and discussions on the latest happenings in the industry from around the world.
Zusammenfassung
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.
Inhalt
INTRODUCTION xxix
PART I: GETTING STARTED
CHAPTER 1: INTRODUCING REPORTING SERVICES 3
Who Uses Reporting Services? 4
Information Workers and Data Analysts 5
Information Consumers 6
Business Managers and Leaders 6
Software Developers 6
System Administrators 7
Dashboards, Reports, and Applications 7
Application Integration 7
Business Intelligence and Analytics Solutions 10
Mobile Reports and KPIs 11
Report Tool Choices 14
Simple Report Design 15
IT-Designed Reports 16
User-Designed Reports 16
Server-Based Reports 17
Report Data Sources 18
Enterprise Scale 19
Optimizing Performance 19
Performance 20
Summary 20
CHAPTER 2: WHAT'S NEW IN SQL SERVER 2016 REPORTING SERVICES? 23
Report Builder and Designer Enhancements 25
Modern Browser Rendering 26
Parameter Layout Control 26
Updated RDL Specifi cation 27
Mobile Reports 28
KPIs 30
Native Printing Control 31
PowerPoint Rendering 31
Integrated and Improved Web Portal 31
New Charts and Visual Enhancements 32
Standardized, Modern Browser Rendering 33
Power BI Dashboard Pinning 33
Summary 36
CHAPTER 3: REPORTING SERVICES INSTALLATION AND ARCHITECTURE 39
What's Changed in SQL Server 2016? 41
The Basic Installation 41
Installing Reporting Services 42
Installing the Reporting Services Samples, Exercises, and SQL Server Databases 56
The Enterprise Deployment 57
SQL Server Editions 58
Default and Named Instances 58
Topology 60
Modes 61
Installation Options 61
The Reporting Life Cycle 63
Authoring 63
Management 63
Delivery 64
Reporting Services Tools 64
Report Builder 64
Web Portal 64
SharePoint Libraries and Web Parts 64
Reporting Services Confi guration Manager 65
SQL Server Management Applications 65
Command-Line Utilities 65
HTML Viewer 66
Report Viewer Control 66
Reporting Services Web Service 67
Reporting Services Windows Service 68
HTTP.SYS and the HTTP Listener 69
The Security Sublayer 69
Web Portal and the Web Service 70
Core Processing 71
Service Management 71
WMI and the RPC Interface 72
Reporting Services Processors and Extensions 73
The Report Processor 74
Data Processing Extensions 75
Report Items 76
Rendering Extensions 77
The Scheduling and Delivery Processor 80
Delivery Extensi…