Build and Analyze SSRS Reports with SQL Server

Instructor: EDUCBA

Included with

Learn more

5 modules

Gain insight into a topic and learn the fundamentals.

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

5 modules

Gain insight into a topic and learn the fundamentals.

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Build structured SSRS reports using SQL Server Data Tools.
Design interactive reports with parameters, drill-downs, and grouping.
Implement charts, subreports, and linked reporting features.

Details to know

Shareable certificate

Add to your LinkedIn profile

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 5 modules in this course

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).

What's included

5 videos3 assignments

5 videos Total 30 minutes

Introduction to MSBI 4 minutes
Introduction to SSRS 8 minutes
What Exactly we are Learning in SSRS 3 minutes
Introduction to SSDT 6 minutes
Introduction to SSDT Continue 8 minutes

3 assignments Total 50 minutes

Understanding MSBI and SSRS 10 minutes
SSRS Learning Scope and Environment Setup 10 minutes
Graded - Foundations of SSRS and Development Tools 30 minutes

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.

What's included

10 videos4 assignments

10 videos Total 56 minutes

Creating a Basic Report 9 minutes
Creating a Basic Report Continue 7 minutes
More on Creating a Basic Report 5 minutes
Change Font and Background Color 6 minutes
Format Number 7 minutes
Format Date and Time 6 minutes
Header and Footer 5 minutes
Repeat Header on Each Page 4 minutes
Visible Header While Scrolling 2 minutes
Display Image in Report 6 minutes

4 assignments Total 60 minutes

Creating Basic Reports 10 minutes
Formatting and Layout Essentials 10 minutes
Headers, Footers, and Visual Elements 10 minutes
Graded - Building Your First SSRS Reports 30 minutes

This module focuses on organizing report data effectively using lists, filtering, sorting, grouping, totals, and expressions to produce structured, insightful SSRS reports.

What's included

10 videos4 assignments

10 videos Total 88 minutes

Create a List Report 12 minutes
Report Filtering 9 minutes
Report Sorting 5 minutes
Row Grouping 9 minutes
Row Grouping Continue 8 minutes
Column Grouping 10 minutes
Column Grouping Continue 9 minutes
Totals and Subtotals 8 minutes
Simple Expression 12 minutes
Complex Expression 5 minutes

4 assignments Total 60 minutes

Lists, Filtering, and Sorting 10 minutes
Grouping Data in Reports 10 minutes
Totals and Expressions 10 minutes
Graded - Data Organization and Report Structuring 30 minutes

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.

What's included

6 videos3 assignments

6 videos Total 44 minutes

Simple Text Parameter 8 minutes
Drop Down List Parameter 5 minutes
Multiple Parameters 9 minutes
Multi-Value Parameter 3 minutes
Drill Down Report 12 minutes
Introduction to Linked Reports 7 minutes

3 assignments Total 50 minutes

Working with Report Parameters 10 minutes
Drill-Down and Linked Reports 10 minutes
Graded - Interactive and Parameterized Reports 30 minutes

This module covers advanced SSRS features, including charts and subreports, emphasizing modular design, reusability, and best practices for building scalable enterprise reports.

What's included

5 videos3 assignments

5 videos Total 45 minutes

Configuring and Managing Linked Reports 9 minutes
Practical Use Cases of Linked Reports 8 minutes
Charts 11 minutes
Introduction to Subreports 7 minutes
Implementing Subreports in SSRS 9 minutes

3 assignments Total 50 minutes

Managing Linked Reports 10 minutes
Visual and Modular Reports 10 minutes
Graded - Advanced Reporting and Reusability 30 minutes

Instructor

EDUCBA

998 Courses 223,202 learners

Offered by

EDUCBA

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

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.

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.

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.