SQL Server Reporting Services: Data Analysis Expert Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join

Exercise Files: https://learnitanytime.com/p/exercise-files-sql-server-reporting-services-data-analysis-expert

Who it's for: This course introduces SQL Server users with Administrator access to SQL Server Reporting Services (SSRS).

What it is: SQL Server Reporting Services (SSRS) is a comprehensive SQL Server-based tool used to create, test, and deploy a variety of reports.

What you'll learn: The ability to sort, group, and summarize data is key as the amount of data we need to deal with increases. First, we focus on providing users with the ability to see the level of detail or summary they need in the order they need to see it. This is accomplished, not only by sorting and grouping, but by creating sub-reports, enabling the drilldown action on reports, and creating drill through reports. Exporting reports to other formats (Word, Excel, PowerPoint) is also addressed. When you have published an SSRS report, users can view the report interactively. In some situations, it can be advantageous to run reports automatically, either to improve performance through caching and snapshots, or to deliver reports to users – by using email or Windows file share. We cover these topics, along with scheduling, comments, subscriptions, and delivery. Finally, we take a look at tasks related to administering SSRS. This includes branding the web portal, setting up security users/groups and assigning SSRS security roles and tasks to the groups. The focus switches to reporting services performance and monitoring it via Task Manager, Event Viewer, and Performance Manager.

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

For Private Group Trainings please visit:
https://www.learnit.com/private-group-classes-workshops

Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password

Start 0:00
Introduction 0:03
Introduction to Summarizing Report Data 1:51
Sorting Table Reports 2:33
Setting Up Interactive Sorting on Report Fields 4:50
Summarizing Data Definitions and Comparisons 7:17
Adding an Order by Clause to a Query in SSMS 9:29
Creating the Main Report 11:59
Formatting Changes and Saving the Main Report 17:01
Creating the SubReport 17:44
Embedding the SubReport in the Main Report 22:17
Creating a Drilldown Report 24:59
Creating a Drill Through Target Report 29:47
Setting Parameters to Allow and Default to Null Values 36:47
Creating a Drill Through Summary Report 41:12
Making Chart Modifications 45:36
Adding Concatenated Tooltips to a Column 47:46
Drill Through Summary and Target Report Exercise 52:39
Summarizing Report Data Recap 54:23
Introduction to Sharing Reports 56:25
Schedule Uses and Types 57:25
Redeploying Projects Properly 59:48
Setting Up a Schedule in SSRS 1:02:17
Introduction to Caching Snapshots and Comments 1:06:09
Creating a Cache that Expires on a Schedule for a Dataset 1:07:41
Creating History Snapshots for a Report 1:09:25
Reviewing Manage Options and Adding Comments in Reports 1:10:40
Setting Up Users and Groups 1:13:05
Account Settings in RSCM 1:15:42
Setting Up File Share Folders 1:17:50
Setting Up Subscriptions 1:18:34
Reviewing Subscription Options in SSRS 1:20:47
Sharing Reports Recap 1:22:45
Introduction to Administering Reporting Services 1:23:49
Reviewing, Configuring, and Branding the Web Portal 1:28:01
Security Assignments 1:31:28
Editing Security Role Assignments at the Report Level 1:34:13
Introduction to Reporting Services Performance 1:38:34
Checking Key Processes in Task Manager 1:40:28
Monitoring and Fixing Errors 1:41:41
Accessing Performance and Resource Monitors 1:49:28
Accessing Process Monitors 1:52:29
Administering Reporting Services Recap 1:54:12
Conclusion 1:56:30

#sqlserver #ssrs #sqlservertutorial

(C) 2023 Learnit, Inc.

Any illegal reproduction of this content will result in immediate legal action.