Press esc to close
Press esc to close
Fill out your contact details below and our training experts will be in touch.
If you wish to make any changes to your course, please log a ticket and choose the category ‘booking change’
Back to Course Information
This course includes the following modules:
Module 1: Introduction to Reporting Services
This module introduces Microsoft SQL Server Reporting Services, its components, and the tools used to work with it.
Lab: Exploring reporting services
Module 2: Reporting Services Data Sources
Almost every report published by using SQL Server Reporting Services (SSRS) is built using data obtained from one or more source systems. This lesson explains how to configure SSRS to interact with source data systems by working with data sources.
Lab: Configuring data access with report builder
Lab: Configuring data access with report designer
Module 3: Creating Paginated Reports
In this module, delegates will discover how to create reports. This module demonstrates how to create different types of reports in both applications, in addition to using the Report Wizard.
Lab: Creating reports
Module 4: Working with Reporting Services Data
It is common for business requirements to change regarding the information they need and how they want data presented. On viewing a detailed report, senior management might ask for higher level, summarised, or filtered versions of the same report. Report Builder and Report Designer support these scenarios via filtering, sorting, drilldowns, grouping and the parameterising of reports. In this module, delegates will learn how to use filters and parameters to make reports more dynamic and useful to business users.
Lab: Create a parameterised report
Module 5: Visualising Data with Report Services
As the amount of data being generated continues to grow, the need to make sense of its meaning increases. Delegates will use data visualisation to make data easier to understand, and faster to interpret. Data visualisations highlight comparisons, show trends, and convey scale much faster than a table of numbers could. The detail is important, but visualisations are a highly effective way of conveying meaning and insights quickly and accurately.
Lab: Manage formatting
Module 6: Summarising Report Data
In this module, delegates will learn how to create group structures, summarise data, and provide interactivity in your reports, so that users see the level of detail or summary that they need.
Lab: Summarising report data
Module 7: Sharing Reporting Services Reports
This module covers report scheduling, caching, and the report life cycle, and automatic subscription and delivery of reports.
Lab: Sharing reporting services reports
Module 8: Administering Reporting Services
System administrators take responsibility for the configuration and day-to-day operations of IT systems. In SQL Server Reporting Services (SSRS), administrative tasks include the configuration of the web portal and web service, branding the web portal, and ensuring that access to sensitive reports is carefully controlled. Administrators also monitor and optimize performance.
Lab: Administering reporting services
Module 9: Extending and Integrating Reporting Services
Although Reporting Services is a powerful tool, its built-in capabilities might not always meet requirements. This module covers the methods for extending the functionality of Reporting Services with expressions and custom code. Delegates will also learn about the methods for working with Reporting Services programmatically, and integrating Reporting Services reports into other applications.
Lab: Extending and integrating reporting services
Module 10: Introduction to Mobile Reports
This module introduces the design and publication of reports that are intended for consumption on mobile devices, such as smartphones and tablets. Microsoft SQL Server Reporting Services (SSRS) includes support for mobile reports, although the tools that are used to design and publish mobile reports are different to the tools used for the paginated reports discussed in the earlier modules of this course.
Lab: Introduction to mobile reports
Module 11: Developing Mobile Reports
In this module, delegates will learn about the element types that can be added to Microsoft SQL Server Reporting Services mobile reports. Delegates will also learn about working with dataset parameters, and how to add drillthrough actions to your reports.
Lab: Developing mobile reports
The primary audience for this course is database professionals who need to undertake a BI developer role to create reports. Primary responsibilities include implementing reports and creating mobile reports.
The secondary audiences for this course are power information workers.
Before attending this course, delegates should possess or be able to demonstrate:
This 5-day course is designed to help delegates learn how to implement an SQL Server 2016 Reporting Services solution for data analysis in an organisation. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.
This Analysing Data with SQL Server Reporting Services course is fully accredited by Microsoft through the Microsoft Silver Partnership held by The Knowledge Academy.
After completing this course, delegates will be able to:
Why choose us
Our easy to use Virtual platform allows you to sit the course from home with a live instructor. You will follow the same schedule as the classroom course, and will be able to interact with the trainer and other delegates.
Our fully interactive online training platform is compatible across all devices and can be accessed from anywhere, at any time. All our online courses come with a standard 90 days access that can be extended upon request. Our expert trainers are constantly on hand to help you with any questions which may arise.
This is our most popular style of learning. We run courses in 1200 locations, across 200 countries in one of our hand-picked training venues, providing the all important ‘human touch’ which may be missed in other learning styles.
All our trainers are highly qualified, have 10+ years of real-world experience and will provide you with an engaging learning experience.
We only use the highest standard of learning facilities to make sure your experience is as comfortable and distraction-free as possible
We limit our class sizes to promote better discussion and ensuring everyone has a personalized experience
Get more bang for your buck! If you find your chosen course cheaper elsewhere, we’ll match it!
This is the same great training as our classroom learning but carried out at your own business premises. This is the perfect option for larger scale training requirements and means less time away from the office.
Our courses can be adapted to meet your individual project or business requirements regardless of scope.
Cut unnecessary costs and focus your entire budget on what really matters, the training.
This gives your team a great opportunity to come together, bond, and discuss, which you may not get in a standard classroom setting.
Keep track of your employees’ progression and performance in your own workspace.
Course was run very smoothly, Richard our trainer was extremely knowledgeable and delivered the course in a succinct fashion with a twist of humour thrown in.
The course was great and the so was the trainer - brilliantly delivered and I would certainly recommend this course to my colleagues. Thanks to Richard for a great course and delivering it a tough environment virtually.
Richard was very knowledgeable and explained well
You won't find better value in the marketplace. If you do find a lower price, we will beat it.
Microsoft Silver Learning Partner
Flexible delivery methods are available depending on your learning style.
Resources are included for a comprehensive learning experience.
"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"
Joshua Davies, Thames Water
"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."
Diane Gray, Shell