Master SQL Server Reporting Services (SSRS) in this comprehensive tutorial designed for SQL Server users with Administrator access. Learn to create, test, and deploy various reports while exploring advanced data analysis techniques. Dive into sorting, grouping, and summarizing data, creating sub-reports, enabling drilldown actions, and developing drill-through reports. Discover how to export reports to different formats and set up automatic report generation for improved performance. Explore caching, snapshots, and report delivery methods, including email and Windows file share. Gain insights into SSRS administration, including web portal branding, security setup, and performance monitoring using Task Manager, Event Viewer, and Performance Manager. Enhance your data analysis skills and become proficient in managing and optimizing SSRS for your organization's reporting needs.
SQL Server Reporting Services - Data Analysis Expert Tutorial
Overview
Syllabus
Start
Introduction
Introduction to Summarizing Report Data
Sorting Table Reports
Setting Up Interactive Sorting on Report Fields
Summarizing Data Definitions and Comparisons
Adding an Order by Clause to a Query in SSMS
Creating the Main Report
Formatting Changes and Saving the Main Report
Creating the SubReport
Embedding the SubReport in the Main Report
Creating a Drilldown Report
Creating a Drill Through Target Report
Setting Parameters to Allow and Default to Null Values
Creating a Drill Through Summary Report
Making Chart Modifications
Adding Concatenated Tooltips to a Column
Drill Through Summary and Target Report Exercise
Summarizing Report Data Recap
Introduction to Sharing Reports
Schedule Uses and Types
Redeploying Projects Properly
Setting Up a Schedule in SSRS
Introduction to Caching Snapshots and Comments
Creating a Cache that Expires on a Schedule for a Dataset
Creating History Snapshots for a Report
Reviewing Manage Options and Adding Comments in Reports
Setting Up Users and Groups
Account Settings in RSCM
Setting Up File Share Folders
Setting Up Subscriptions
Reviewing Subscription Options in SSRS
Sharing Reports Recap
Introduction to Administering Reporting Services
Reviewing, Configuring, and Branding the Web Portal
Security Assignments
Editing Security Role Assignments at the Report Level
Introduction to Reporting Services Performance
Checking Key Processes in Task Manager
Monitoring and Fixing Errors
Accessing Performance and Resource Monitors
Accessing Process Monitors
Administering Reporting Services Recap
Conclusion
Taught by
Learnit Training
