Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

SQL Server Reporting Services - Data Analysis Beginner Tutorial

Learnit Training via YouTube

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
This course aims to introduce SQL Server users with Administrator access to SQL Server Reporting Services (SSRS) and covers the basics of creating, testing, and deploying reports using SSRS. By the end of the course, learners will be able to configure SSRS to interact with data sources, create datasets, and generate paginated reports using Report Builder and Report Designer. The course teaches skills such as creating data sources, datasets, and paginated reports, and the teaching method includes hands-on exercises and practical demonstrations. The intended audience for this course includes SQL Server users with Administrator access looking to enhance their skills in data analysis and reporting using SSRS.

Syllabus

Start
Introduction
Introduction to Reporting Services
Reporting Services Components
Reporting Services Tools for Report Authoring
Tools for Report Server Admin - Native Mode
Tools for Report Server Admin - SharePoint Integrated Mode
Tools for Report Content Management
Software Requirements
Introduction to Reporting Services Data Sources
Data Sources
Connecting to SQL Server Management Studio
Restoring the WideWorldImporters Database
Importing Queries for the Class into SSMS
Accessing the Web Portal from RSCM
Creating a Shared Data Source in SSRS
Accessing Report Builder from SSRS
Creating a Dataset in Report Builder
Adding Extensions in Visual Studio
Creating a Project in Visual Studio
Creating a Shared Data Source in Visual Basic
Creating a Shared Dataset in Visual Studio
Reporting Services Data Sources Recap
Introduction to Paginated Reports
Creating Paginated Reports with Report Wizard
Modifying Values and Date Formats
Adjusting Columns and Repeating Items
Creating a Paginated Report from Scratch in Visual Studio
Adjusting Column Headings and Widths
Manually Setting Row Grouping
Changing Date and Number Formats
Grouping Rows and More Adjustments to Columns
Adding and Repeating Report Headers Across All Pages
Using the Wizard to Create a Table Report
Publishing Reports
Setting Target URL and Deploying Solution
Paginated Reports Recap
Conclusion

Taught by

Learnit Training

Reviews

Start your review of SQL Server Reporting Services - Data Analysis Beginner Tutorial

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.