Business Intelligence training - Reporting Services

SSRS Training

Reporting Services (SSRS) Training Course

£695 + VAT for most venues (£850 + VAT for London)

2 days

If you're wondering whether you should be learning SQL Server Reporting Services, the answer is yes! SSRS (as it's often called) allows you to create impressive reports, including drill-through, indicators, gauges and lots of other whizzy features. You can then publish these reports directly to your company's website in a number of different formats, or push them out to subscribers by email.

This two-day course runs in SSRS 2016, but if you're using SSRS 2012 you'll still be able to attend, as the report design interface has barely changed (even since SSRS 2008 R2).

Course details

Locations:London, Manchester
Next course:Thu 06 February 2020
Time:09.30-16.30

SCHEDULED DATES Course Contents - PDF

Course Contents

The content of this course are as follows:

Introduction to SSRS

Visual Studio and SQL Server Data Tools
Solutions and projects
The Visual Studio environment

Designing a Simple Report

Authoring a report
Using report items
Selecting and formatting report items
Number formats

Data sources and datasets

Shared data sources
Shared versus embedded datasets
Using Query Designer

Tables

Structure of a table
Formatting tables
Inserting rows
Interactive sorting
Repeating page headers

Grouping tables

Using the grouping panes
Row and column groups
Displaying subtotals
Outlining

Expressions

Calculated fields
The ReportItems collection
Using built-in fields
Conditional formatting using expressions

Pages and printing

Page headers and footers
Pagination between groups
Header and footer expressions

Parameters

Using query parameters
Creating drop lists
Multi-value drop lists
Formatting using parameters

Indicators

Creating indicators
Changing the symbols displayed
Stopping indicators stretching

Gauges

Creating and formatting gauges
Gauge panels
Pointers, scales and ranges

Matrices

Areas of a matrix
Sorting and grouping matrices
Creating and formatting subtotals

Charts

The areas of a chart
Creating charts
Formatting charts

Data bars and sparklines

Need for a grouped row
Creating data bars
Creating sparklines

Lists

Creating and formatting lists
Grouping using lists
Using rectangles in lists

Covered if time allows If time

Subreports

Creating a child report
Creating the main report
Creating and formatting subreports

Drill-through reports

Parent and child reports
Creating actions
Passing values to a child report

Covered if time allows If time

Maps

ESRI shapefiles / SQL spatial data
Linking to datasets
Map layers
Center points and point layers

Deploying reports

Setting the target server
Deploying an entire project
Deploying single reports

The SSRS web portal

Browsing to the web portal
Viewing reports
Managing reports

Covered if time allows If time

KPIs and mobile reports

Creating a KPI
Installing Mobile Report Publisher
Creating a mobile report

Covered if time allows If time

Subscriptions

How subscriptions work
Creating a new subscription
Managing subscriptions

You do not need any prior knowledge of SQL to attend this course (although you should have an understanding of tables and databases).

Why Choose Us?

No more than 6 people per class
Proper restaurant lunch included
499 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

"Great course and content, very professionally delivered."

Mark Potter (Linney Group Ltd)

"We had a wonderful trainer, very attentive and helpful, would highly recommend him."

James Wright (Warwick International Computing Systems)

"Fab course. Loved the food."

Claire Wilcock (NHS Midlands & Lancashire CSU)

"Great lunches, very enjoyable course at a good speed and perfect mix of lecturing and practical exercises, would definitely recommend Wise Owl."

Kevin Stirrup (Stirrup Computing Services Ltd)

"I would like to say that I enjoyed the course very much and found it very informative. The trainer was incredibly professional and helped explain all the elements in the SSRS Course, ensuring that we fully understood each topic before moving on. I really liked the fact that the trainer explained multiple methods of achieving the same outcome in the use of SSRS as it helped us all to find what method was best suited for us. The course was really well structured and I didn’t feel rushed when completing the exercises, which were an added benefit as they allowed us to expand on the skills we were learning during the training. The course was beneficial to my personal development and I have already begun applying the training in my role. The supporting documents provided have also been great in helping me implement the training in practice."

Matt Hardy (Derbyshire County Council)

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

Scheduled Reporting Services training dates

Here are the Reporting Services courses we have scheduled for the next 3 months:

Dates	Days	Venue	Price	Booking
Thu/Fri 06-07 February 2020	2	Manchester	£695	Book places
Tue/Wed 17-18 March 2020	2	London	£850	Book places
Tue/Wed 24-25 March 2020	2	Manchester	£695	Book places
Thu/Fri 07-08 May 2020	2	London	£850	Book places
Wed/Thu 27-28 May 2020	2	Manchester	£695	Book places
Tue/Wed 30th Jun/1st July 2020	2	London	£850	Book places
Thu/Fri 09-10 July 2020	2	Manchester	£695	Book places
Thu/Fri 20-21 August 2020	2	London	£850	Book places
Tue/Wed 25-26 August 2020	2	Manchester	£695	Book places
Tue/Wed 29-30 September 2020	2	London	£850	Book places
Thu/Fri 08-09 October 2020	2	Manchester	£695	Book places
Tue/Wed 17-18 November 2020	2	London	£850	Book places
Thu/Fri 26-27 November 2020	2	Manchester	£695	Book places
Thu/Fri 03-04 December 2020	2	London	£850	Book places

Date(s)	Venue
06/02	Manchester
17/03	London
24/03	Manchester
07/05	London
27/05	Manchester
30/06	London
09/07	Manchester
20/08	London
25/08	Manchester
29/09	London
08/10	Manchester
17/11	London
26/11	Manchester
03/12	London

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