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:Manchester, London
  • Next Reporting Services course locationNext course:Thu 10 January 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

"I attended the 2 Day SSRS course in London this week. Just wanted to say a big thank you - the content and pace was excellent. The trainer was very engaging and knowledgeable - happy to help with off topic questions. Would definitely use you guys again."

Alison Atterbury (Collinson Group)

"Excellent course - brilliant and useful (Intro to SQL). Excellent course - small groups make it easier to ask questions and the pace is suited to everyone. The exercises are all good. Would highly recommend (Advanced SQL)."

Helen Seymour (University of Leeds)

"Very knowledgeable trainer!"

David Norrington-Moore (DNM Business Intelligence Ltd)

"Really good all round. Manual seems very thorough and exercises were really helpful. I thought the course was great and it’s been really helpful!"

Felix Michaux (Royal College of Veterinary Surgeons)

"This was a great course and pitched perfectly for my needs. I have been on a course where I was the only delegate and it descended into farce - not the case here, the trainer managed this superbly! Faultless."

Neil Meredith (Costcutter Supermarkets Group Ltd)

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 10-11 January 2019 2 £850 Book places
Thu/Fri 17-18 January 2019 2 £695 Book places
Thu/Fri 17-18 January 2019 2 £695 Fully booked
Thu/Fri 28th Feb/1st March 2019 2 £850 Book places
Thu/Fri 07-08 March 2019 2 £695 Book places
Tue/Wed 16-17 April 2019 2 £695 Book places
Date(s) Venue
10/01
17/01
17/01
28/02
07/03
16/04

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