Business Intelligence training - Advanced SSRS

SSRS Training

Advanced SSRS Training Course

£750 + VAT for most venues (£895 + VAT for London)

2 days

If you can already create reports using either Report Builder or Reporting Services, we'd like to show you what else SSRS can do! This two-day advanced course will show you how to create and use variables; why and how you should base your reports on views and stored procedures; and how to use bookmarks, document maps and dynamic reports. If you're getting a group of people up to speed on SSRS from scratch, combining this and our two-day Introduction to SSRS course together makes for a nice three-day onsite course.

Course details

Locations:Manchester
Next course:Tue 25 February 2020
Time:09.30-16.30

SCHEDULED DATES Course Contents - PDF

Course Contents

The content of this course are as follows:

Revision of grouping

Creating grouped tables
Fixing page headers
Collapsing and expanding

Revision of expressions

Calculated fields
Using the expression builder
Conditional formatting

Advanced expressions

Understanding scope
Using RowNumber
Running totals

Variables

How variables work
Report variables
Group variables

Embedding code

Setting code for a report
Calling functions in expressions
Better ways to write code

Using SQL views

Why views are a good idea
Designing views
Scripting views
Creating virtual tables

Revision of parameters

Configuring parameters
Referencing parameters
Dealing with no rows
Default and null values
Dropdown parameters

Stored procedures in SSRS

Pros and cons of stored procedures
Server Explorer vs SSMS
Creating and editing procedures
Using for reports

Stored procedure parameters

Creating report parameters
Refreshing fields
Default and null values

Dropdowns with procedures

The stored procedures needed
Cascading dropdowns
Replacing SELECT A VALUE

Multivalue parameter procedures

Splitting the choices made in SQL
Displaying the chosen data
Restricting the number of choices

Improving report navigation

Document maps
Using bookmarks
Setting tooltips

Dynamic reports

Dynamic datasets
Dynamic grouping
Dynamic matrices

The ideal preparation for this course is to attend our two-day Reporting Services course. We will accept other delegates, but you must have a good understanding of how to create reports in SSRS. Delegates must also know some SQL. This course is taught using SQL Server 2016, although the version isn't particularly important.

Why Choose Us?

No more than 6 people per class
Proper restaurant lunch included
503 references viewable online
Free USB stick containing course files
Genuine Wise Owl trainers only
Unbelievably good courseware

View full list of benefits

Sample customer feedback

"It is very good course. I find it filling the gap I had in my SSRS knowledge and motivated me to take it to next level. Amazing instructor. I am really addicted to your U-tube videos. They are amazing, I hope you do similar videos for these courses."

Petros Negusse (Medecin Sans Frontiere (MSF) UK)

"Nicely paced with great instructor. Also, worth mentioning that the tutor went the extra mile to help me with material at the end of each day. I had seen many of his videos online which I found immensely helpful and was really pleased to find he was just as great a teacher face-to-face."

Quentin Harris (NEL CSU (NHS))

"Excellent course, excellent trainer and excellent course manual."

Ilkka Laurmaa (Delta Motor Group)

"The trainer was very competent, knowledgeable and enthusiastic. Well done!"

Sandro Fasolo (Moorfields Eye Hospital NHS Foundation Trust)

"l thought the course was fantastic and really helpful and the training materials were of a really high standard. It is not often when going on a training course that you can work through the training and manual afterwards which is a credit to Wise Owl Training. I also wanted to thank your excellent trainer; his style of teaching was very good. He has a lot of patience with less experienced people like myself and was always willing to help us when we got stuck. I would definitely like to attend some other courses."

John Groves (Kinase Consulting Limited)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Scheduled Advanced SSRS training dates

Here are the Advanced SSRS courses we have scheduled for the next 3 months:

Dates	Days	Venue	Price	Booking
Tue/Wed 25-26 February 2020	2	Manchester	£750	Book places
Thu/Fri 07-08 May 2020	2	Manchester	£750	Book places
Thu/Fri 16-17 July 2020	2	Manchester	£750	Book places
Thu/Fri 01-02 October 2020	2	Manchester	£750	Book places
Thu/Fri 03-04 December 2020	2	Manchester	£750	Book places

Date(s)	Venue
25/02	Manchester
07/05	Manchester
16/07	Manchester
01/10	Manchester
03/12	Manchester

All prices exclude VAT. If you can't see the dates you want, ask us about running onsite SSRS training at your offices (we'll even provide and set up the computers).

Other Reporting Services training resources

SSRS exercises

To help you decide whether you like the Wise Owl approach to classroom training, take a look at some of the Reporting Services exercises we've published online.

View SSRS 2016 exercises

SSRS videos

We don't just do classroom training! There is a whole series of Reporting Services videos on the Wise Owl YouTube channel too.

View Reporting Services - Introduction, SSRS 2016, Report Builder 2016 or Reporting Services - Advanced videos

SSRS blogs

Exercises, videos and blogs on Reporting Services too, as you can see by following this link.

View SSRS blogs

This page has 0 threads Add post