COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
Classroom training -  Fast track SSRS

Classroom Training

Intensive fast-track 3-day Reporting Services (SSRS)

Available as classroom training course only

3 days

Sometimes our clients want to learn everything about SSRS (SQL Server Reporting Services) in one go, minimising the amount of time spent out of the office.  We've combined all of the units from our Introduction to SSRS course and the most useful ones from our Advanced SSRS course to create this intensive three-day course, aimed at the select class of people (you'll know if you're one of them) who aren't fazed by the prospect of an intensive three-day period of training.  We only offer this as a tailored course (here's why).

Our fast-track courses are only available as tailored training, either at your premises or at either our London or Manchester venues (here's why).

Course Contents

This fast-track course combines topics from the following other Wise Owl courses:

From our REPORTING SERVICES course

Introduction to SSRS

  • Visual Studio and SSDT
  • 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 - 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

Covered if time allows If time

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 don't need any pre-existing knowledge of SQL or SQL Server to attend this course, although if you understand how databases are constructed using tables and relationships you'll have a head start.  What you must have is a very good aptitude for IT, otherwise you won't enjoy your three days!

Why Choose Us?

Sample customer feedback

Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).

"Excellent course - great content, delivery, manual & lunches!"

Helen Goodall (The Kings School, Chester)

"Excellent organisation, manuals are great, fantastic trainer. Used Wise Owl previously (and would definitely use again.) The course was chosen as it provided the ideal content for our requirements to produce reporting dashboards."

Julian Hill (Marley Ltd)

"Certainly learnt a lot. Very good and personable trainer."

Gareth Hampson (Mastercall Healthcare)

"Excellent. Very encouraging tutor, useful manuals, enjoyed the course. Contents excellent for level being taught."

Chas Mills (Guardian Industries UK Ltd)

"Very engaging course, complete walk through of the software and was easy to pick up as a Power BI novice. Materials very good and nice to have to refer back to."

Emily Steer (Cheshire East Council)

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

Related Courses

Reporting Services

Basic

2 day course

Advanced SSRS

Advanced

2 day course

Other Reporting Services training resources

SSRS exercises

SSRS exercises

We've published our SSRS exercises on our website, so you can see what we will include on your course.

View SSRS 2016 exercises

SSRS videos

SSRS videos

As an alternative (or supplement) to classroom training, we've created a series of SSRS videos.

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

SSRS blogs

SSRS blogs

We've got all sorts of blogs on Reporting Services on our website.

View SSRS blogs

This page has 0 threads Add post