SQL Server Reporting Services: Data Analysis Beginner Tutorial
Vložit
- čas přidán 5. 08. 2024
- SQL Server Reporting Services: Data Analysis Beginner Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: learnitanytime.com/p/exercise...
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:
www.learnitanytime.com
For Private Group Trainings please visit:
www.learnit.com/private-group...
Manuals: 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.
Exercise Files: learnitanytime.com/p/exercise-files-sql-server-reporting-services-data-analysis-beginner
Excellent Tutorial. Such an insightful and US Teaching Method and Instructors are THE BEST.
You guys are amazing. How I wish you had a subscription for individual users. I'm coming from the power BI course and that was amazing as well. Thanks to Trish and the team.
Wow! Excellent tutorial. You're a great teacher, Trish.
Thank you so much!
Thank you for this Video. I can follow all steps smoothly.
You're welcome!
Very didact. Explains without hurry, step by step and very clearly. Nice video.
Thank you so much!
Have u competed all videos till expert level?
Very easy to follow!
Glad it was helpful!
Dear mam, I know this not right video to put this question but please let me know how can we paste data from sheet 1 to sheet 2 but condition is that col1 data from sheet 1 pasted in col1 of sheet2 but col2 data from sheet 1 pasted in column 3 of sheet2...And going on col3 data from sheet 1 pasted in col5 in sheet2..this is Google sheet
Fabulous
You are welcome!
Enjoy
the sql seems wrong? the TransactionAmount of each row are the same even the quantity and itemNo are different
Am in the right place
Thanks for watching!
Thank you for this tutorial. I'm stuck, I am unavailable to follow through.
Hello Esther! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
4/21/2023 ~11:10