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 for Reporting Services coursesLocations:London, Manchester
  • Next Reporting Services course locationNext course:Thu 06 February 2020
  • Reporting Services course timesTime:09.30-16.30

Course Contents

The content of this course are as follows:

Introduction to SSRS

  • Training topicVisual Studio and SQL Server Data Tools
  • Training topicSolutions and projects
  • Training topicThe Visual Studio environment

Designing a Simple Report

  • Training topicAuthoring a report
  • Training topicUsing report items
  • Training topicSelecting and formatting report items
  • Training topicNumber formats

Data sources and datasets

  • Training topicShared data sources
  • Training topicShared versus embedded datasets
  • Training topicUsing Query Designer

Tables

  • Training topicStructure of a table
  • Training topicFormatting tables
  • Training topicInserting rows
  • Training topicInteractive sorting
  • Training topicRepeating page headers

Grouping tables

  • Training topicUsing the grouping panes
  • Training topicRow and column groups
  • Training topicDisplaying subtotals
  • Training topicOutlining

Expressions

  • Training topicCalculated fields
  • Training topicThe ReportItems collection
  • Training topicUsing built-in fields
  • Training topicConditional formatting using expressions

Pages and printing

  • Training topicPage headers and footers
  • Training topicPagination between groups
  • Training topicHeader and footer expressions

Parameters

  • Training topicUsing query parameters
  • Training topicCreating drop lists
  • Training topicMulti-value drop lists
  • Training topicFormatting using parameters

Indicators

  • Training topicCreating indicators
  • Training topicChanging the symbols displayed
  • Training topicStopping indicators stretching

Gauges

  • Training topicCreating and formatting gauges
  • Training topicGauge panels
  • Training topicPointers, scales and ranges

Matrices

  • Training topicAreas of a matrix
  • Training topicSorting and grouping matrices
  • Training topicCreating and formatting subtotals

Charts

  • Training topicThe areas of a chart
  • Training topicCreating charts
  • Training topicFormatting charts

Data bars and sparklines

  • Training topicNeed for a grouped row
  • Training topicCreating data bars
  • Training topicCreating sparklines

Lists

  • Training topicCreating and formatting lists
  • Training topicGrouping using lists
  • Training topicUsing rectangles in lists

Covered if time allows If time

Subreports

  • Training topicCreating a child report
  • Training topicCreating the main report
  • Training topicCreating and formatting subreports

Drill-through reports

  • Training topicParent and child reports
  • Training topicCreating actions
  • Training topicPassing values to a child report

Covered if time allows If time

Maps

  • Training topicESRI shapefiles / SQL spatial data
  • Training topicLinking to datasets
  • Training topicMap layers
  • Training topicCenter points and point layers

Deploying reports

  • Training topicSetting the target server
  • Training topicDeploying an entire project
  • Training topicDeploying single reports

The SSRS web portal

  • Training topicBrowsing to the web portal
  • Training topicViewing reports
  • Training topicManaging reports

Covered if time allows If time

KPIs and mobile reports

  • Training topicCreating a KPI
  • Training topicInstalling Mobile Report Publisher
  • Training topicCreating a mobile report

Covered if time allows If time

Subscriptions

  • Training topicHow subscriptions work
  • Training topicCreating a new subscription
  • Training topicManaging 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?

View full list of benefits 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 £695 Book places
Tue/Wed 17-18 March 2020 2 £850 Book places
Tue/Wed 24-25 March 2020 2 £695 Book places
Thu/Fri 07-08 May 2020 2 £850 Book places
Wed/Thu 27-28 May 2020 2 £695 Book places
Tue/Wed 30th Jun/1st July 2020 2 £850 Book places
Thu/Fri 09-10 July 2020 2 £695 Book places
Thu/Fri 20-21 August 2020 2 £850 Book places
Tue/Wed 25-26 August 2020 2 £695 Book places
Tue/Wed 29-30 September 2020 2 £850 Book places
Thu/Fri 08-09 October 2020 2 £695 Book places
Tue/Wed 17-18 November 2020 2 £850 Book places
Thu/Fri 26-27 November 2020 2 £695 Book places
Thu/Fri 03-04 December 2020 2 £850 Book places
Date(s) Venue
06/02
17/03
24/03
07/05
27/05
30/06
09/07
20/08
25/08
29/09
08/10
17/11
26/11
03/12

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

Related Courses

Introduction to SQL RECOMMENDED

Basic

2 day course

Advanced SQL

Advanced

2 day course

Advanced SSRS

Advanced

2 day course

Other Reporting Services training resources

SSRS exercises

SSRS exercises

Lest you not be sure if this is the right course for you, we've published all of our Reporting Services exercises online.

View SSRS 2016 exercises

SSRS videos

SSRS videos

Look at our range of videos on SSRS, which provide and alternative way of learning to classroom training.

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

SSRS blogs

SSRS blogs

There are lots of good blogs on Reporting Services, which you can inspect at your leisure.

View SSRS blogs

This page has 0 threads Add post