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

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Dive into a comprehensive beginner tutorial on SQL Server Reporting Services (SSRS) for data analysis. Learn the fundamentals of this powerful SQL Server-based tool used for creating, testing, and deploying various reports. Explore SSRS components, tools, and supported data sources. Gain hands-on experience configuring SSRS to interact with source data systems, creating data sources with appropriate connection strings, and building datasets. Master the art of crafting paginated reports using both Report Builder and Report Designer in Visual Studio. Conclude by learning how to publish and deploy reports to the report server. Perfect for SQL Server users with Administrator access looking to expand their reporting capabilities.

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.