Details

Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports


Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports


1. Aufl.

von: Paul Turley, Riccardo Muti, Christopher Finlan

35,99 €

Verlag: Wiley
Format: PDF
Veröffentl.: 17.01.2017
ISBN/EAN: 9781119258384
Sprache: englisch
Anzahl Seiten: 816

DRM-geschütztes eBook, Sie benötigen z.B. Adobe Digital Editions und eine Adobe ID zum Lesen.

Beschreibungen

<b>Optimize reporting and BI with Microsoft SQL Server 2016</b> <p><i>Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports</i> 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.</p> <p>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.</p> <ul> <li>Understand BI fundamentals and Reporting Services architecture</li> <li>Learn the ingredients to a successful report design</li> <li>Get up to speed on Microsoft SQL Server 2016</li> <li>Grasp the purpose behind common designs to optimize your reporting</li> </ul> <p>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, <i>Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports</i> is the ideal guide for getting up to speed and producing successful reports.  </p>
<p>INTRODUCTION xxix</p> <p><b>PART I: GETTING STARTED</b></p> <p><b>CHAPTER 1: INTRODUCING REPORTING SERVICES 3</b></p> <p>Who Uses Reporting Services? 4</p> <p>Information Workers and Data Analysts 5</p> <p>Information Consumers 6</p> <p>Business Managers and Leaders 6</p> <p>Software Developers 6</p> <p>System Administrators 7</p> <p>Dashboards, Reports, and Applications 7</p> <p>Application Integration 7</p> <p>Business Intelligence and Analytics Solutions 10</p> <p>Mobile Reports and KPIs 11</p> <p>Report Tool Choices 14</p> <p>Simple Report Design 15</p> <p>IT-Designed Reports 16</p> <p>User-Designed Reports 16</p> <p>Server-Based Reports 17</p> <p>Report Data Sources 18</p> <p>Enterprise Scale 19</p> <p>Optimizing Performance 19</p> <p>Performance 20</p> <p>Summary 20</p> <p><b>CHAPTER 2: WHAT’S NEW IN SQL SERVER 2016 REPORTING SERVICES? 23</b></p> <p>Report Builder and Designer Enhancements 25</p> <p>Modern Browser Rendering 26</p> <p>Parameter Layout Control 26</p> <p>Updated RDL Specifi cation 27</p> <p>Mobile Reports 28</p> <p>KPIs 30</p> <p>Native Printing Control 31</p> <p>PowerPoint Rendering 31</p> <p>Integrated and Improved Web Portal 31</p> <p>New Charts and Visual Enhancements 32</p> <p>Standardized, Modern Browser Rendering 33</p> <p>Power BI Dashboard Pinning 33</p> <p>Summary 36</p> <p><b>CHAPTER 3: REPORTING SERVICES INSTALLATION AND ARCHITECTURE 39</b></p> <p>What’s Changed in SQL Server 2016? 41</p> <p>The Basic Installation 41</p> <p>Installing Reporting Services 42</p> <p>Installing the Reporting Services Samples, Exercises, and SQL Server Databases 56</p> <p>The Enterprise Deployment 57</p> <p>SQL Server Editions 58</p> <p>Default and Named Instances 58</p> <p>Topology 60</p> <p>Modes 61</p> <p>Installation Options 61</p> <p>The Reporting Life Cycle 63</p> <p>Authoring 63</p> <p>Management 63</p> <p>Delivery 64</p> <p>Reporting Services Tools 64</p> <p>Report Builder 64</p> <p>Web Portal 64</p> <p>SharePoint Libraries and Web Parts 64</p> <p>Reporting Services Confi guration Manager 65</p> <p>SQL Server Management Applications 65</p> <p>Command-Line Utilities 65</p> <p>HTML Viewer 66</p> <p>Report Viewer Control 66</p> <p>Reporting Services Web Service 67</p> <p>Reporting Services Windows Service 68</p> <p>HTTP.SYS and the HTTP Listener 69</p> <p>The Security Sublayer 69</p> <p>Web Portal and the Web Service 70</p> <p>Core Processing 71</p> <p>Service Management 71</p> <p>WMI and the RPC Interface 72</p> <p>Reporting Services Processors and Extensions 73</p> <p>The Report Processor 74</p> <p>Data Processing Extensions 75</p> <p>Report Items 76</p> <p>Rendering Extensions 77</p> <p>The Scheduling and Delivery Processor 80</p> <p>Delivery Extensions 80</p> <p>Reporting Services Application Databases 80</p> <p>ReportServer 80</p> <p>ReportServerTempDB 82</p> <p>Summary 82</p> <p><b>PART II: BASIC REPORT DESIGN</b></p> <p><b>CHAPTER 4: REPORT LAYOUT AND FORMATTING 87</b></p> <p>Using Report Design Tools 88</p> <p>Understanding Report Data Building Blocks 89</p> <p>Data Sources 89</p> <p>Datasets 90</p> <p>Data Regions 90</p> <p>Report Items 93</p> <p>Samples and Exercises 93</p> <p>Preparing the Report Data 96</p> <p>Designing the Report Layout 100</p> <p>Reviewing the Report 104</p> <p>Setting Formatting Properties 105</p> <p>Validating Report Design and Grouping Data 108</p> <p>Summary 112</p> <p><b>CHAPTER 5: DATA ACCESS AND QUERY BASICS 113</b></p> <p>Database Essentials 114</p> <p>Relational Database Concepts 114</p> <p>What’s a Sequel? 114</p> <p>Data Source Management 115</p> <p>Embedded and Shared Data Sources 115</p> <p>Datasets and Fields 119</p> <p>Embedded and Shared Datasets 120</p> <p>Exercises 120</p> <p>Authoring a Query with SQL Server Management Studio 120</p> <p>Add the Query to the Report Dataset 124</p> <p>Design the Report Body 128</p> <p>Enhance the Parameter 131</p> <p>Using Multiple Parameter Values 134</p> <p>Summary 138</p> <p><b>CHAPTER 6: GROUPING AND TOTALS 139</b></p> <p>SQL Server Data Tools 140</p> <p>Getting Started 140</p> <p>Getting Started with Sample Reports Projects 144</p> <p>Report Groups 150</p> <p>Adding Totals to a Table or Matrix Report 153</p> <p>Expression Basics 154</p> <p>Introducing Aggregate Functions and Totals 155</p> <p>Sorting 155</p> <p>Exercise 158</p> <p>Design the Dataset Query 158</p> <p>Design and Lay Out a Table Report 160</p> <p>Add Summary Totals and Drill-Down 163</p> <p>Aggregate Detail Row Summaries 167</p> <p>Create Parameter List 168</p> <p>Summary 171</p> <p><b>PART III: ADVANCED AND ANALYTIC REPORTING</b></p> <p><b>CHAPTER 7: ADVANCED REPORT DESIGN 175</b></p> <p>Pagination and Flow Control 176</p> <p>Headers and Footers 178</p> <p>Tablix Headers and Detail Cells 182</p> <p>Designing the Page Headers 182</p> <p>Composite Reports and Embedded Content 187</p> <p>Unlocking the Textbox 187</p> <p>Padding and Indenting 188</p> <p>Embedded Formatting 189</p> <p>Designing Master/Detail Reports 195</p> <p>Repeating Data Regions: Table, Matrix, and List 196</p> <p>Groups and Dataset Scope 200</p> <p>More Aggregate Functions and Totals 200</p> <p>Designing Subreports 203</p> <p>Federating Data with a Subreport 205</p> <p>Navigating Reports 208</p> <p>Creating a Document Map 209</p> <p>Exercises 210</p> <p>Exercise 1: Create a Report Template 210</p> <p>Exercise 2: Create a Report from the Template with Dynamic Expressions 215</p> <p>Summary 219</p> <p><b>CHAPTER 8: GRAPHICAL REPORT DESIGN 221</b></p> <p>Visual Design Principles 222</p> <p>Keep Charts Simple 222</p> <p>Properties, Oh My! 223</p> <p>The Fashion of Visualization 223</p> <p>Visual Storytelling 224</p> <p>Perspective and Skewing 224</p> <p>Chart Types 225</p> <p>Chart Type Summary 225</p> <p>Column and Stacked Charts 228</p> <p>Area and Line Charts 229</p> <p>Pie and Doughnut Charts 229</p> <p>Bubble and Stock Charts 233</p> <p>New Chart Types 233</p> <p>The Anatomy of a Chart 235</p> <p>Multiple Series, Axes, and Areas 237</p> <p>Exercises 240</p> <p>Exercise 1: Creating and Styling a Simple Chart 240</p> <p>Exercise 2: Creating a Multi-series Chart 245</p> <p>Useful Properties and Settings 248</p> <p>Summary 249</p> <p><b>CHAPTER 9: ADVANCED QUERIES AND PARAMETERS 251</b></p> <p>T-SQL Queries and Parameters 252</p> <p>Parameter Lists and Multi-select 252</p> <p>Cascading Parameters 257</p> <p>Arranging Parameters in the Parameter Bar 259</p> <p>Managing Long Parameter Lists 259</p> <p>All Value Selection 261</p> <p>Handling Conditional Logic 264</p> <p>MDX Queries and Parameters 266</p> <p>Single-Valued Parameter 270</p> <p>Multi-Valued Parameter 270</p> <p>Date Value Ranges 271</p> <p>Summary 275</p> <p><b>CHAPTER 10: REPORTING WITH ANALYSIS SERVICES 277</b></p> <p>Analysis Services for Reporting 278</p> <p>Using Reporting Services with Analysis Services Data 279</p> <p>Working with Multidimensional Expression Language 280</p> <p>MDX: Simple or Complex? 280</p> <p>Building Queries with the MDX Query Designer 281</p> <p>Modifying an MDX Query 293</p> <p>Adding Nonadditive Measures 302</p> <p>When to Use the Aggregate Function 304</p> <p>MDX Properties and Cube Formatting 305</p> <p>Drill-Through Reports 307</p> <p>Parameter Safety Precautions 308</p> <p>Best Practices and Provisions 308</p> <p>Summary 309</p> <p><b>CHAPTER 11: SSAS REPORTING ADVANCED TECHNIQUES 311</b></p> <p>Building a Dynamic Cube Browser with SSRS 312</p> <p>Cube Dynamic Rows 312</p> <p>Cube Dynamic Rows Anatomy 313</p> <p>Cube Dynamic Rows Summary 322</p> <p>Cube Dynamic Rows Expanded 324</p> <p>MDX Query Modifi cations 324</p> <p>Design Surface Modifi cations 325</p> <p>Cube Restricting Rows 326</p> <p>Designing the Report 326</p> <p>Cube Metadata 332</p> <p>Designing the Report 332</p> <p>Adding Other Cube Metadata 336</p> <p>Cube Browser 342</p> <p>Anatomy of the Reports 342</p> <p>Behind the Scenes 346</p> <p>Final Thoughts 362</p> <p>Summary 364</p> <p><b>CHAPTER 12: EXPRESSIONS AND ACTIONS 365</b></p> <p>Basic Expressions Recap 365</p> <p>Using the Expression Builder 367</p> <p>Calculated Fields 369</p> <p>Conditional Expressions 371</p> <p>The IIF() Function 372</p> <p>Using Custom Code 375</p> <p>Using Custom Code in a Report 376</p> <p>Links and Drill-Through Reports 378</p> <p>Reporting on Recursive Relationships 381</p> <p>Actions and Report Navigation 385</p> <p>Summary 392</p> <p><b>PART IV: SOLUTION PATTERNS</b></p> <p><b>CHAPTER 13: REPORT PROJECTS AND CONSOLIDATION 397</b></p> <p>SSDT Solutions and Projects 398</p> <p>Project Structure and Development Phases 399</p> <p>Shared Datasets and Data Sources 401</p> <p>Key Success Factors 402</p> <p>Report Specifi cations 403</p> <p>Report Template 406</p> <p>Version Control 407</p> <p>Setting Up Version Control 408</p> <p>Getting the Latest Version 408</p> <p>Viewing a Report’s History 409</p> <p>Restoring a Previous Version of a Report 409</p> <p>Setting Check-out and Check-in Policies 409</p> <p>Applying Labels 409</p> <p>Synchronizing Content 409</p> <p>Deploying an Individual Report 410</p> <p>Deploying a Suite of Reports 410</p> <p>Checking for Build Errors 410</p> <p>Excluding a Report from a Deployment 410</p> <p>Managing Server Content 410</p> <p>Checking the Deployment Location 411</p> <p>Managing Content in Native Mode 412</p> <p>Managing Content in SharePoint 413</p> <p>Report Builder and Self-Service Reporting Strategies 414</p> <p>Report Builder and Semantic Model History 415</p> <p>Planning a Self-Service Reporting Environment 416</p> <p>You Need a Plan 416</p> <p>Design Approaches and Usage Scenarios 416</p> <p>Defi ne Ownership 417</p> <p>Data Governance 418</p> <p>Data Source Access and Security 419</p> <p>User Education 419</p> <p>Data Source and Query Options 421</p> <p>User Report Migration Strategies 425</p> <p>Review 425</p> <p>Consolidate 426</p> <p>Design 426</p> <p>Test 426</p> <p>Maintain 426</p> <p>Summary 427</p> <p><b>CHAPTER 14: REPORT SOLUTIONS, PATTERNS, AND RECIPES 429</b></p> <p>Super Reports 430</p> <p>Working with the Strengths and Limitations of the Reporting Services Architecture 431</p> <p>Seeking the Excel Export Holy Grail 431</p> <p>Report Recipes: Building on Basic Skills 435</p> <p>Dashboard Solution Data Sources and Datasets 436</p> <p>KPI Scorecard 437</p> <p>Gauges 441</p> <p>Interactive Sparkline and Chart 443</p> <p>Thumbnail Map with Drill-Through Navigation 450</p> <p>Summary 456</p> <p><b>PART V: REPORTING SERVICES CUSTOM PROGRAMMING</b></p> <p><b>CHAPTER 15: INTEGRATING REPORTS INTO CUSTOM APPLICATIONS 461</b></p> <p>URL Access 462</p> <p>URL Syntax 463</p> <p>Accessing Reporting Services Objects 463</p> <p>Reporting Services URL Parameters 469</p> <p>Passing Report Information Through the URL 474</p> <p>Programmatic Rendering 477</p> <p>Common Scenarios 478</p> <p>Rendering Through Windows 479</p> <p>Rendering to the Web 502</p> <p>Using the ReportViewer Control 509</p> <p>Embedding a Server-Side Report in a Windows Application 512</p> <p>Summary 519</p> <p><b>CHAPTER 16: EXTENDING REPORTING SERVICES 521</b></p> <p>Extension Through Interfaces 524</p> <p>What Is an Interface? 524</p> <p>Interface Language Differences 524</p> <p>A Detailed Look at Data Processing Extensions 527</p> <p>Creating a Custom Data Processing Extension 529</p> <p>The Scenario 530</p> <p>Creating and Setting Up the Project 530</p> <p>Creating the DataSetConnection Object 533</p> <p>Creating the DataSetParameter Class 542</p> <p>Implementing IDataParameter 543</p> <p>Creating the DataSetParameterCollection Class 545</p> <p>Creating the DataSetCommand Class 547</p> <p>Creating the DataSetDataReader Object 562</p> <p>Installing the DataSetDataProcessing Extension 566</p> <p>Testing DataSetDataExtension 569</p> <p>Summary 572</p> <p><b>PART VI: MOBILE REPORT SOLUTIONS</b></p> <p><b>CHAPTER 17: INTRODUCING REPORTING SERVICES MOBILE REPORTS 575</b></p> <p>The Mobile Report Experience and Business Case 576</p> <p>Report Drill-Through Navigation 579</p> <p>When to Use Mobile Reports 579</p> <p>Connection and Dataset Design Basics 581</p> <p>Introducing Mobile Report Publisher 581</p> <p>Layout View 582</p> <p>Data View 582</p> <p>Dashboard Settings 583</p> <p>Preview 583</p> <p>Visual Control Categories 584</p> <p>Navigators 585</p> <p>Summary 592</p> <p><b>CHAPTER 18: IMPLEMENTING A MOBILE REPORT WITH DESIGN-FIRST DEVELOPMENT 593</b></p> <p>Design-First Mobile Report Development Exercise 593</p> <p>Add Visual Controls 598</p> <p>Preview the Mobile Report 601</p> <p>Add Data to the Report 602</p> <p>Apply Mobile Layouts and Color Styling 613</p> <p>Test the Completed Mobile Report from the Server 616</p> <p>Summary 620</p> <p><b>CHAPTER 19: MOBILE REPORT DESIGN PATTERNS 623</b></p> <p>Key Performance Indicators 623</p> <p>The Thing About KPIs 630</p> <p>You Need Goals 630</p> <p>Time-Series Calculations and Time Grain 631</p> <p>Creating a Time-Series Mobile Report 632</p> <p>Lay Out the Report Using Design-First Report Development 633</p> <p>Add Data and Set Control Data Properties 635</p> <p>Set Color Palette and Mobile Device Layouts 642</p> <p>Server Access and Live Mobile Connectivity 647</p> <p>Summary 650</p> <p><b>CHAPTER 20: ADVANCED MOBILE REPORT SOLUTIONS 653</b></p> <p>Designing a Chart Data Grid Mobile Report 653</p> <p>Exercise: Chart Data Grid 654</p> <p>Exercise: Adding a Drill-Through Mobile Report 662</p> <p>Exercise: Adding a Drill-Through Paginated Report 666</p> <p>Getting Serious with Maps 671</p> <p>Summary 676</p> <p><b>PART VII: ADMINISTERING REPORTING SERVICES</b></p> <p><b>CHAPTER 21: CONTENT MANAGEMENT 679</b></p> <p>Using Web Portal 680</p> <p>Content Management Activities 683</p> <p>Folders 684</p> <p>Shared Data Sources 685</p> <p>Reports 688</p> <p>Report Resources 694</p> <p>Shared Schedules 695</p> <p>Site and Content Security 696</p> <p>Site Security 697</p> <p>Item-Level Security 697</p> <p>Site Branding 707</p> <p>Content Management Automation 710</p> <p>The RS Utility 710</p> <p>Reporting Services Scripts 713</p> <p>Summary 714</p> <p><b>CHAPTER 22: SERVER ADMINISTRATION 715</b></p> <p>Security 716</p> <p>Account Management 717</p> <p>System-Level Roles 721</p> <p>Surface Area Management 723</p> <p>Backup and Recovery 724</p> <p>Application Databases 725</p> <p>Encryption Keys 727</p> <p>Confi guration Files 730</p> <p>Other Items 730</p> <p>Monitoring 731</p> <p>Setup Logs 731</p> <p>Windows Application Event Logs 731</p> <p>Trace Logs 732</p> <p>Execution Logs 735</p> <p>Performance Counters 736</p> <p>Server Management Reports 741</p> <p>Confi guration 742</p> <p>Memory Management 742</p> <p>URL Reservations 743</p> <p>E-mail Delivery 745</p> <p>Rendering Extensions 747</p> <p>My Reports 749</p> <p>Summary 751</p> <p>INDEX 753</p>
<p><b>About the author</b> <p><b>Paul Turley</b> 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. <p>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.
<p><b>Create optimized reports and enhance BI with SQL Server 2016</b> <p>Microsoft SQL Server 2016 offers new functionality, new capabilities, improved processes, and much more. This book takes you step by step through the upgrades and prepares you to take full advantage of the latest in report design and business intelligence solutions. Along with Reporting Services architecture and BI fundamentals, expert Paul Turley explains key elements of successful report design and leads you through the various design types, explaining their uses and how to maximize each one. Get up to speed and begin optimizing web, desktop, and portal reporting solutions right away. <p><i>Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports:</i> <ul> <li>Explains report design techniques for operational, mobile and analytical reporting, BI fundamentals and Reporting Services architecture</li> <li>Covers Mobile Report Publisher, and improvements to the SQL Server Data Tools/Visual Studio Report Designer and Report Builder</li> <li>Examines the new Web Portal Interface, HTML-5 Rendering, KPIs, Power BI integration, Custom Parameters Pane, and more</li> <li>Shows you how to improve usability, query design, and filtering techniques in your reports</li> <li>Offers real-world advice on best-practice report design and optimizing common report types</li> <li>Brings you fully up to speed on all the features of this significant Microsoft SQL Server upgrade</li> </ul> <p><b>Wrox Professional</b> guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

Diese Produkte könnten Sie auch interessieren:

MDX Solutions
MDX Solutions
von: George Spofford, Sivakumar Harinath, Christopher Webb, Dylan Hai Huang, Francesco Civardi
PDF ebook
53,99 €
Concept Data Analysis
Concept Data Analysis
von: Claudio Carpineto, Giovanni Romano
PDF ebook
107,99 €
Handbook of Virtual Humans
Handbook of Virtual Humans
von: Nadia Magnenat-Thalmann, Daniel Thalmann
PDF ebook
150,99 €