SQL Server 2016 Reporting Services Cookbook

Dinesh Priyankara, Robert C. Cain

  • 出版商: Packt Publishing
  • 出版日期: 2016-11-28
  • 售價: $2,200
  • 貴賓價: 9.5$2,090
  • 語言: 英文
  • 頁數: 596
  • 裝訂: Paperback
  • ISBN: 1786461811
  • ISBN-13: 9781786461810
  • 相關分類: MSSQLSQL
  • 下單後立即進貨 (約3~4週)

商品描述

Key Features

  • Get up to speed with the newly-introduced enhancements and the more advanced query and reporting features
  • Easily access your important data by creating visually appealing dashboards in the Power BI practical recipe
  • Create cross-browser and cross-platform reports using SQL Server 2016 Reporting Services

Book Description

Microsoft SQL Server 2016 Reporting Services comes with many new features. It offers different types of reporting such as Production, Ad-hoc, Dashboard, Mash-up, and Analytical. SQL Server 2016 also has a surfeit of new features including Mobile Reporting, and Power BI integration.

This book contains recipes that explore the new and advanced features added to SQL Server 2016. The first few chapters cover recipes on configuring components and how to explore these new features. You’ll learn to build your own reporting solution with data tools and report builder, along with learning techniques to create visually appealing reports. This book also has recipes for enhanced mobile reporting solutions, accessing these solutions effectively, and delivering interactive business intelligence solutions. Towards the end of the book, you’ll get to grips with running reporting services in SharePoint integrated mode and be able to administer, monitor, and secure your reporting solution.

This book covers about the new offerings of Microsoft SQL Server 2016 Reporting Services in comprehensive detail and uses examples of real-world problem-solving business scenarios.

What you will learn

  • Key capabilities, architecture, and components of Reporting Services
  • New features that have been added to Reporting Services
  • Design the architecture for reporting solutions
  • Design the architecture for BI solutions
  • Implement reporting solutions using Reporting Services
  • Improve the performance, availability, and scalability of the reporting solution
  • Enhance reporting solutions with custom programming and improved security

About the Author

Dinesh Priyankara is an experienced professional and database enthusiast with skills in database management systems and business intelligence, especially on the Microsoft SQL Server product suite. Possessing over 16 years of experience on data related technologies, he does training, consulting, and is a top contributor to the local SQL Server community. In recognition of his contributions and expertise he has demonstrated, he was awarded the Microsoft Most Valuable Professional (MVP) award for SQL Server for 11 consecutive years since 2006.

Dinesh is the Founder/Principal Architect of dinesQL (Pvt) Ltd (http://dinesql.com), a company that provides services on database, business intelligence, and training. In his spare time, he runs a blog at http://dinesql.blogspot.com with a follower base of over 100,000 from around the world and is a co-organizer of SQL Server Sri Lanka User Group (http://www.meetup.com/ssslug/).

Even though he has written many articles on the database area, this is his first official book as a co-author.

Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Pluralsight, with over 11 courses to his credit. Robert is a team mate at Linchpin People, and co-author of four books.

A popular speaker, Robert has presented at events such as the SQL PASS Summit, IT/Dev Connections, TechEd, CodeStock, and numerous SQL Saturdays. Robert has over 25 years’ experience in the IT industry, working in a variety of fields including manufacturing, insurance, telecommunications and nuclear power.

Table of Contents

  1. Getting It Ready – Configuring Reporting Services
  2. Authoring Reports with SQL Server Data Tools
  3. Advanced Report Authoring with SQL Server Data Tools
  4. Authoring Reports with Report Builder
  5. Improving User Experience – New Designing and Visualization Enhancements
  6. Authoring Reports with the Mobile Report Publisher
  7. Consuming Reports – Report Access Enhancement
  8. Reporting Solutions for BI – Integration
  9. SharePoint Integration
  10. Administering and Managing Reporting Services
  11. Securing Reports in Reporting Services
  12. Custom Programming and Integration to .NET Applications

商品描述(中文翻譯)

主要特點


  • 熟悉新引入的增強功能和更高級的查詢和報告功能

  • 通過在Power BI實用食譜中創建視覺上吸引人的儀表板,輕鬆訪問重要數據

  • 使用SQL Server 2016 Reporting Services創建跨瀏覽器和跨平台的報告

書籍描述

Microsoft SQL Server 2016 Reporting Services具有許多新功能。它提供了不同類型的報告,如生產報告、即席報告、儀表板報告、混合報告和分析報告。SQL Server 2016還具有許多新功能,包括移動報告和Power BI集成。

本書包含了探索SQL Server 2016新增和高級功能的食譜。前幾章介紹了配置組件和探索這些新功能的食譜。您將學習使用數據工具和報告生成器構建自己的報告解決方案,並學習創建視覺上吸引人的報告的技巧。本書還提供了增強的移動報告解決方案的食譜,有效訪問這些解決方案以及提供互動式商業智能解決方案的食譜。在本書的最後,您將掌握在SharePoint集成模式下運行報告服務並能夠管理、監控和保護報告解決方案的技能。

本書詳細介紹了Microsoft SQL Server 2016 Reporting Services的新功能,並使用了真實世界的問題解決業務場景的示例。

您將學到什麼


  • 報告服務的關鍵能力、架構和組件

  • 報告服務新增的新功能

  • 設計報告解決方案的架構

  • 設計商業智能解決方案的架構

  • 使用報告服務實施報告解決方案

  • 提高報告解決方案的性能、可用性和可擴展性

  • 通過自定義編程和改進的安全性增強報告解決方案

關於作者

Dinesh Priyankara是一位經驗豐富的專業人士和數據庫愛好者,擅長數據庫管理系統和商業智能,尤其是Microsoft SQL Server產品套件。他在數據相關技術方面擁有超過16年的經驗,提供培訓、咨詢服務,並是當地SQL Server社區的頂級貢獻者。由於他的貢獻和專業知識,他自2006年以來連續11年獲得了Microsoft最有價值專家(MVP)獎項。

Dinesh是dinesQL(Pvt)Ltd(http://dinesql.com)的創始人/首席架構師,該公司提供數據庫、商業智能和培訓服務。在空閒時間,他在http://dinesql.blogspot.com上運營一個博客,擁有來自世界各地的超過10萬名追隨者,並且是SQL Server斯里蘭卡用戶組(http://www.meetup.com/ssslug/)的聯合組織者。

儘管他在數據庫領域寫了很多文章,但這是他作為合著者的第一本正式書籍。

Robert C. Cain(http://arcanecode.com)是一位Microsoft MVP,擁有BI認證的MCTS,也是Arcane Training and Consulting, LLC的所有者。他還是Pluralsight的課程作者,已經撰寫了超過11門課程。Robert是Linchpin People的團隊成員,也是四本書的合著者。

作為一位受歡迎的演講者,Robert曾在SQL PASS Summit、IT/Dev Connections、TechEd、CodeStock和眾多SQL Saturdays等活動上發表演講。Robert在IT行業擁有超過25年的經驗,曾在製造、保險、電信和核能等多個領域工作。

目錄


  1. 準備就緒-配置報告服務

  2. 使用SQL Server數據工具編寫報告

  3. 使用SQL Server數據工具進行高級報告編寫

  4. 自動...