Business Intelligence training -  Fast track SSRS

SSRS Training

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

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

  • 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

Covered if time allows If time

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
From our ADVANCED SSRS course

Advanced expressions

  • Training topicUnderstanding scope
  • Training topicUsing RowNumber
  • Training topicRunning totals

Variables

  • Training topicHow variables work
  • Training topicReport variables
  • Training topicGroup variables

Embedding code

  • Training topicSetting code for a report
  • Training topicCalling functions in expressions
  • Training topicBetter ways to write code

Using SQL views

  • Training topicWhy views are a good idea
  • Training topicDesigning views
  • Training topicScripting views
  • Training topicCreating virtual tables

Stored procedures in SSRS

  • Training topicPros and cons of stored procedures
  • Training topicServer Explorer vs SSMS
  • Training topicCreating and editing procedures
  • Training topicUsing for reports

Stored procedure parameters

  • Training topicCreating report parameters
  • Training topicRefreshing fields
  • Training topicDefault and null values

Dropdowns with procedures

  • Training topicThe stored procedures needed
  • Training topicCascading dropdowns
  • Training topicReplacing SELECT A VALUE

Covered if time allows If time

Multivalue parameter procedures

  • Training topicSplitting the choices made in SQL
  • Training topicDisplaying the chosen data
  • Training topicRestricting the number of choices

Improving report navigation

  • Training topicDocument maps
  • Training topicUsing bookmarks
  • Training topicSetting tooltips

Dynamic reports

  • Training topicDynamic datasets
  • Training topicDynamic grouping
  • Training topicDynamic matrices

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?

View full list of benefits View full list of benefits

Sample customer feedback

"The course is very well structured and the trainer is very patient and ready to help! It is a very useful training."

Greta Cipriano (Provident Financial Management Services Ltd)

"Well paced; trainer was great, approachable and well versed."

Ian McIntyre (Medical Protection Society)

"Good pace. Trainer very attentive, no-one was left behind."

David Byrne (Department for Education)

"Very good course with excellent material and trainer. I really enjoyed the interactivity which enhanced the learning experience"

Liam Sutton (Retail Insight (RI))

"Fantastic course, brilliant trainer; extremely friendly and knowledgeable. Learnt a huge amount! Course content was fantastic."

Alex Claydon (UP Global Sourcing (UK) Ltd)

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