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).
Das ist alles enthalten
5 Videos3 Aufgaben
Infos zu Modulinhalt anzeigen
5 Videos•Insgesamt 30 Minuten
Introduction to MSBI•4 Minuten
Introduction to SSRS•8 Minuten
What Exactly we are Learning in SSRS•3 Minuten
Introduction to SSDT•6 Minuten
Introduction to SSDT Continue•8 Minuten
3 Aufgaben•Insgesamt 50 Minuten
Understanding MSBI and SSRS•10 Minuten
SSRS Learning Scope and Environment Setup•10 Minuten
Graded - Foundations of SSRS and Development Tools•30 Minuten
Building Your First SSRS Reports
Modul 2•2 Stunden abzuschließen
Moduldetails
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.
Das ist alles enthalten
10 Videos4 Aufgaben
Infos zu Modulinhalt anzeigen
10 Videos•Insgesamt 56 Minuten
Creating a Basic Report•9 Minuten
Creating a Basic Report Continue•7 Minuten
More on Creating a Basic Report•5 Minuten
Change Font and Background Color•6 Minuten
Format Number•7 Minuten
Format Date and Time•6 Minuten
Header and Footer•5 Minuten
Repeat Header on Each Page•4 Minuten
Visible Header While Scrolling•2 Minuten
Display Image in Report•6 Minuten
4 Aufgaben•Insgesamt 60 Minuten
Creating Basic Reports•10 Minuten
Formatting and Layout Essentials•10 Minuten
Headers, Footers, and Visual Elements•10 Minuten
Graded - Building Your First SSRS Reports•30 Minuten
Data Organization and Report Structuring
Modul 3•2 Stunden abzuschließen
Moduldetails
This module focuses on organizing report data effectively using lists, filtering, sorting, grouping, totals, and expressions to produce structured, insightful SSRS reports.
Das ist alles enthalten
10 Videos4 Aufgaben
Infos zu Modulinhalt anzeigen
10 Videos•Insgesamt 88 Minuten
Create a List Report•12 Minuten
Report Filtering•9 Minuten
Report Sorting•5 Minuten
Row Grouping•9 Minuten
Row Grouping Continue•8 Minuten
Column Grouping•10 Minuten
Column Grouping Continue•9 Minuten
Totals and Subtotals•8 Minuten
Simple Expression•12 Minuten
Complex Expression•5 Minuten
4 Aufgaben•Insgesamt 60 Minuten
Lists, Filtering, and Sorting•10 Minuten
Grouping Data in Reports•10 Minuten
Totals and Expressions•10 Minuten
Graded - Data Organization and Report Structuring•30 Minuten
Interactive and Parameterized Reports
Modul 4•2 Stunden abzuschließen
Moduldetails
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.
Das ist alles enthalten
6 Videos3 Aufgaben
Infos zu Modulinhalt anzeigen
6 Videos•Insgesamt 44 Minuten
Simple Text Parameter•8 Minuten
Drop Down List Parameter•5 Minuten
Multiple Parameters•9 Minuten
Multi-Value Parameter•3 Minuten
Drill Down Report•12 Minuten
Introduction to Linked Reports•7 Minuten
3 Aufgaben•Insgesamt 50 Minuten
Working with Report Parameters•10 Minuten
Drill-Down and Linked Reports•10 Minuten
Graded - Interactive and Parameterized Reports•30 Minuten
Advanced Reporting and Reusability
Modul 5•2 Stunden abzuschließen
Moduldetails
This module covers advanced SSRS features, including charts and subreports, emphasizing modular design, reusability, and best practices for building scalable enterprise reports.
Das ist alles enthalten
5 Videos3 Aufgaben
Infos zu Modulinhalt anzeigen
5 Videos•Insgesamt 45 Minuten
Configuring and Managing Linked Reports•9 Minuten
Practical Use Cases of Linked Reports•8 Minuten
Charts•11 Minuten
Introduction to Subreports•7 Minuten
Implementing Subreports in SSRS•9 Minuten
3 Aufgaben•Insgesamt 50 Minuten
Managing Linked Reports•10 Minuten
Visual and Modular Reports•10 Minuten
Graded - Advanced Reporting and Reusability•30 Minuten
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.