By the end of this course, learners will be able to build structured SSRS reports, apply formatting and data organization techniques, design interactive parameter-driven reports, and implement advanced reporting features such as charts, linked reports, and subreports using SQL Server Reporting Services.
This course provides a comprehensive, hands-on pathway to mastering SSRS reporting, starting from core Business Intelligence concepts and progressing through real-world report development scenarios. Learners will gain practical experience using SQL Server Data Tools (SSDT) to create professional, paginated reports that support business decision-making. Through structured modules, the course covers report creation, formatting, grouping, expressions, parameters, drill-down functionality, and reusable reporting components.
What makes this course unique is its end-to-end focus on practical reporting skills, aligned closely with industry workflows rather than isolated features. Each concept builds logically on the previous one, ensuring learners not only understand how SSRS works, but why each reporting decision matters. Upon completion, learners will be well-equipped to design scalable, interactive, and maintainable SSRS reports suitable for enterprise and business intelligence environments.
This module introduces learners to Microsoft Business Intelligence (MSBI) and SQL Server Reporting Services (SSRS), establishing foundational knowledge of BI concepts, reporting architecture, and the development environment required to build SSRS reports using SQL Server Data Tools (SSDT).
涵盖的内容
5个视频3个作业
显示有关单元内容的信息
5个视频•总计30分钟
Introduction to MSBI•4分钟
Introduction to SSRS•8分钟
What Exactly we are Learning in SSRS•3分钟
Introduction to SSDT•6分钟
Introduction to SSDT Continue•8分钟
3个作业•总计50分钟
Understanding MSBI and SSRS•10分钟
SSRS Learning Scope and Environment Setup•10分钟
Graded - Foundations of SSRS and Development Tools•30分钟
Building Your First SSRS Reports
第 2 单元•小时 后完成
单元详情
This module guides learners through the process of creating, formatting, and enhancing basic SSRS reports, focusing on report structure, layout design, and visual presentation best practices.
涵盖的内容
10个视频4个作业
显示有关单元内容的信息
10个视频•总计56分钟
Creating a Basic Report•9分钟
Creating a Basic Report Continue•7分钟
More on Creating a Basic Report•5分钟
Change Font and Background Color•6分钟
Format Number•7分钟
Format Date and Time•6分钟
Header and Footer•5分钟
Repeat Header on Each Page•4分钟
Visible Header While Scrolling•2分钟
Display Image in Report•6分钟
4个作业•总计60分钟
Creating Basic Reports•10分钟
Formatting and Layout Essentials•10分钟
Headers, Footers, and Visual Elements•10分钟
Graded - Building Your First SSRS Reports•30分钟
Data Organization and Report Structuring
第 3 单元•小时 后完成
单元详情
This module focuses on organizing report data effectively using lists, filtering, sorting, grouping, totals, and expressions to produce structured, insightful SSRS reports.
涵盖的内容
10个视频4个作业
显示有关单元内容的信息
10个视频•总计88分钟
Create a List Report•12分钟
Report Filtering•9分钟
Report Sorting•5分钟
Row Grouping•9分钟
Row Grouping Continue•8分钟
Column Grouping•10分钟
Column Grouping Continue•9分钟
Totals and Subtotals•8分钟
Simple Expression•12分钟
Complex Expression•5分钟
4个作业•总计60分钟
Lists, Filtering, and Sorting•10分钟
Grouping Data in Reports•10分钟
Totals and Expressions•10分钟
Graded - Data Organization and Report Structuring•30分钟
Interactive and Parameterized Reports
第 4 单元•小时 后完成
单元详情
This module enables learners to build interactive SSRS reports by using parameters, drill-down functionality, and linked reports to create dynamic, user-driven reporting experiences.
涵盖的内容
6个视频3个作业
显示有关单元内容的信息
6个视频•总计44分钟
Simple Text Parameter•8分钟
Drop Down List Parameter•5分钟
Multiple Parameters•9分钟
Multi-Value Parameter•3分钟
Drill Down Report•12分钟
Introduction to Linked Reports•7分钟
3个作业•总计50分钟
Working with Report Parameters•10分钟
Drill-Down and Linked Reports•10分钟
Graded - Interactive and Parameterized Reports•30分钟
Advanced Reporting and Reusability
第 5 单元•小时 后完成
单元详情
This module covers advanced SSRS features, including charts and subreports, emphasizing modular design, reusability, and best practices for building scalable enterprise reports.
Welcome to EDUCBA, a place where knowledge is limitless! We provide a wide selection of instructive and engaging programmes designed to empower students of all ages and experiences. From the convenience of your home, start a revolutionary educational experience with our cutting-edge technologies courses and experienced instructors.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I purchase the Certificate?
When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.