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 SSDT
  • 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 - 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

"Very engaging, good examples and exercises."

Charlotte Hill (Derby and Burton Hospitals NHS FT)

"Excellent course. Very good pace and examples."

Colin Halliday (North West Ambulance Service)

"Very well delivered course with excellent guidance and manual. (Recommendation came from our ICT team.)"

Graham Rose (City of Lincoln Council)

"Really good, managed to fit so much in. Online tutorials were great."

Elisabeth Turner (Appleyard Lees)

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

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
Thu/Fri 02-03 April 2020 2 £695 Book places
Tue/Wed 28-29 April 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
02/04
28/04
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