CUSTOMISED
Expert-led training for your team

Dismiss

SQL Server Reporting Services training course

Retrieve Your Corporate Data With SQL Server Reporting Services - And Gain A Competitive Advantage!

"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"

Brian Leek, Data Analyst, May 2022

Public Courses

04/08/25 - 2 days

£995 +VAT

Enrol

15/09/25 - 2 days

£995 +VAT

Enrol

27/10/25 - 2 days

£995 +VAT

Enrol

Customised Courses

* Train a team
* Tailor content
* Flex dates

From £1200 / day

Highlights Details Audience Feedback Prices/Dates Related Courses

Public Courses

Highlights

Gain an understanding of SQL Server Reporting Services (SSRS)
Learn how to maximise the powerful and integrated SSRS capabilities
Retrieve your corporate data with SSRS to gain a competitive advantage
Create Business Intelligence (BI) reports
Deploy BI reports
Manage BI reports
Optional days - explore SSRS more broadly and in more depth

Course Details

SSRS Fundamentals

SSRS overview
Reporting Services
Report Server
Report Designer
Report Builder
Report Manager

Designing reports – fundamentals

Report Wizard in SSDT-BI (aka BIDS/Visual Studio)
SQL relational reports
Tablixes (tables and matrixes)

Previewing reports
Deploying reports to Report Manager

Designing reports – further techniques

Formatting (including dates and currency)
Using expressions
Conditional formatting (and green-band reporting)
KPIs for SSRS
Grouping and drilldown
Grand totals, subtotals, and running totals
Interactive sorting
Charts and gauges
Parameterized SQL reports
Exporting reports to Excel or PDF
Report templates with global parameters
Multiple reports
Drilldown versus drillthrough
Subreports
Jump reports
Linked reports

Administration

Reporting Services Configuration Manager
Report caching
Report snapshots
Report subscriptions (emailing reports)
Security overview

Who should attend

Developers and analysts who need to design and build reports. Administrators who wish to deploy and manage reports. Some basic SQL skills would be an advantage.

Feedback

4.8 out of 5 average

Brian Leek, Data Analyst, May 2022

“JBI did a great job of customizing their syllabus to suit our business needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and the Instructor handled this particularly well - very impressive”

Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022

Sign up for the JBI Training newsletter to receive technology tips directly from our instructors - Analytics, AI, ML, DevOps, Web, Backend and Security.

More about this course

This Microsoft SQL Server Reporting Services (SSRS) training course lets delegates get to grips with a key part of the Microsoft BI stack. The course covers the discovery and preparation of data, the modelling of the data, and the presentation of the data in insightful and attractive reports and dashboards.

We spend two days looking at Reporting Services (SSRS) and other visualisation tools such as Power BI, and when you return to your office you will easily be able to create powerful and informative reports and dashboards.

All the work you do is saved and you can take it with you for future reference.

FAQs

CONTACT
+44 (0)20 8446 7555

[email protected]

SHARE

Copyright © 2025 JBI Training. All Rights Reserved.
JB International Training Ltd - Company Registration Number: 08458005
Registered Address: Wohl Enterprise Hub, 2B Redbourne Avenue, London, N3 2BS

Modern Slavery Statement & Corporate Policies | Terms & Conditions | Contact Us