SQL Server Reporting Services: Data Analysis Beginner 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-beginner

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: We start with an introduction to SSRS, as well as its components and tools. Next, we go hands-on with a focus on the data sources that are supported in SSRS. We explain how to configure SSRS to interact with source data systems via data sources. You will learn how to create a data source with the appropriate connection string and then move on to creating datasets based off the data source. Finally, we work on creating paginated reports in both Report Builder and Report Designer (via Visual Studio) and we end with learning how to publish (deploy) reports to the report server.

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 Reporting Services 1:43
Reporting Services Components 3:31
Reporting Services Tools for Report Authoring 4:27
Tools for Report Server Admin - Native Mode 5:23
Tools for Report Server Admin - SharePoint Integrated Mode 6:49
Tools for Report Content Management 7:36
Software Requirements 8:08
Introduction to Reporting Services Data Sources 11:09
Data Sources 12:29
Connecting to SQL Server Management Studio 15:58
Restoring the WideWorldImporters Database 17:12
Importing Queries for the Class into SSMS 19:33
Accessing the Web Portal from RSCM 22:21
Creating a Shared Data Source in SSRS 24:11
Accessing Report Builder from SSRS 30:27
Creating a Dataset in Report Builder 32:22
Adding Extensions in Visual Studio 34:09
Creating a Project in Visual Studio 36:48
Creating a Shared Data Source in Visual Basic 39:10
Creating a Shared Dataset in Visual Studio 41:05
Reporting Services Data Sources Recap 42:49
Introduction to Paginated Reports 43:30
Creating Paginated Reports with Report Wizard 43:55
Modifying Values and Date Formats 48:56
Adjusting Columns and Repeating Items 54:15
Creating a Paginated Report from Scratch in Visual Studio 1:00:10
Adjusting Column Headings and Widths 1:04:28
Manually Setting Row Grouping 1:07:54
Changing Date and Number Formats 1:10:44
Grouping Rows and More Adjustments to Columns 1:12:10
Adding and Repeating Report Headers Across All Pages 1:16:39
Using the Wizard to Create a Table Report 1:21:13
Publishing Reports 1:23:33
Setting Target URL and Deploying Solution 1:25:33
Paginated Reports Recap 1:31:12
Conclusion 1:32:50

#sqlserver #ssrs #sqlservertutorial

(C) 2023 Learnit, Inc.

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