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 09 May 2019
  • Reporting Services course timesTime:09.30-16.30

Course Contents

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

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

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

James Wright (Warwick International Computing Systems)

"Great introduction and aimed just right."

Tom Wallace (St Mungos )

"Course delivered effectively. Friendly and interactive trainer who knows his stuff. Not one moment of boredom or tension from classroom; relaxing environment. I am a newbie to SSRS and refreshingly Wise Owl does actually deliver what they promise"

Hian Soh (Bechtel Limited)

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

"Amazing, trainer was brilliant."

Jelani Ahmed (London Borough of Newham)

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

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

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 09-10 May 2019 2 £695 Book places
Thu/Fri 13-14 June 2019 2 £850 Book places
Tue/Wed 25-26 June 2019 2 £695 Book places
Thu/Fri 18-19 July 2019 2 £850 Book places
Thu/Fri 08-09 August 2019 2 £695 Book places
Tue/Wed 10-11 September 2019 2 £695 Book places
Thu/Fri 12-13 September 2019 2 £850 Book places
Tue/Wed 15-16 October 2019 2 £695 Book places
Thu/Fri 24-25 October 2019 2 £850 Book places
Tue/Wed 19-20 November 2019 2 £695 Book places
Thu/Fri 28-29 November 2019 2 £850 Book places
Tue/Wed 17-18 December 2019 2 £695 Book places
Date(s) Venue
09/05
13/06
25/06
18/07
08/08
10/09
12/09
15/10
24/10
19/11
28/11
17/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