SQL Server Reporting Services - Data Analysis Beginner Tutorial

Overview

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