Business Intelligence training -  Report Builder

Report Builder Training

Report Builder training course

£695 + VAT for most venues (£850 + VAT for London)

2 days

Report Builder is almost identical to Reporting Services (the difference is that Report Builder allows you to create reports without having to download or learn Visual Studio). If you're not sure of the differences, speak to us and we can talk you through which application you should be using (or have a look here). 

This two-day course explains how to create reports in Report Builder 2016 (this is pretty much identical to Report Builder 3, so if you're using the older version you can still attend).  During the course you'll learn how to create tables, lists and matrices, format reports so that they look beautiful and add fancy devices like indicators and gauges.

Course details

  • Locations for Report Builder coursesLocations:Manchester, London
  • Next Report Builder course locationNext course:Mon 08 October 2018
  • Report Builder course timesTime:09.30-16.30

Course Contents

Data sources and datasets

  • Training topicData sources
  • Training topicDatasets
  • Training topicUsing query designer

Tables

  • Training topicCreating tables
  • Training topicInteractive sorting
  • Training topicFloating headers

Grouping

  • Training topicInserting groups
  • Training topicGroup headers/footers
  • Training topicDisplaying group totals
  • Training topicExpanding and collapsing

Expressions

  • Training topicThe expression builder
  • Training topicThe ReportItems collection
  • Training topicBuilt-in fields
  • Training topicConditional formatting expressions

Page set-up

  • Training topicPage headers and footers
  • Training topicPage names and numbers

Exporting reports

  • Training topicThe various report formats
  • Training topicUsing RenderFormat.Name

Parameters

  • Training topicCreating parameters
  • Training topicFiltering using parameters
  • Training topicDrop list parameters
  • Training topicCoping with empty tables

Matrices

  • Training topicRow and column groups
  • Training topicSorting and filtering matrices
  • Training topicCreating subtotals

Charts

  • Training topicCreating charts
  • Training topicThe parts of a chart
  • Training topicFormatting charts

Basic reports

  • Training topicText boxes and images
  • Training topicSelecting report items
  • Training topicFormatting parts of a report

Covered if time allows If time

Miniature charts

  • Training topicCreating sparklines
  • Training topicCreating data bars

Graphical indicators

  • Training topicCreating and customising indicators
  • Training topicLinear and radial gauges

Lists

  • Training topicPage-per-record lists
  • Training topicDashboard lists
  • Training topicOther list ideas

Covered if time allows If time

Subreports

  • Training topicCreating a child report
  • Training topicCreating the main report
  • Training topicLinking the two reports

Covered if time allows If time

Drill-through reports

  • Training topicParent and child reports
  • Training topicCreating actions
  • Training topicPassing values to a child report

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

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Trainer was very clear and knowledgeable."

Suzie Pittman (Mount Green Housing Association)

"Good overall experience! Thorough course materials and excellent coverage of theoretical frameworks and practical exercises. Plenty of time dedicated to individual queries. The course was well paced and balanced between basic and more complex functions. I would like to thank the trainer for helping me with my specific queries."

Anthony Dodwell (JoJo Maman Bébé)

"Very efficient booking process, course materials top notch and trainer very knowledgeable and friendly. Lack of shortbread compared to last week - disappointing!"

Jon Arshad (The Camping and Caravanning Club)

"The trainer was very knowledgeable and entertaining."

Vanessa Murray (NHS Digital)

"Very knowledgeable trainer. Patient and went at our speed."

Elloise Morley (Best Food Logistics (formerly Bidvest Logistics))

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

There are no particular pre-requisites for this course, although a passing knowledge of how relational databases are formed will help. In particular, no knowledge of SQL is needed.

Scheduled Report Builder training dates

Here are the Report Builder courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Mon/Tue 08-09 October 2018 2 £695 Book places
Thu/Fri 18-19 October 2018 2 £850 Book places
Mon/Tue 05-06 November 2018 2 £695 Book places
Tue/Wed 11-12 December 2018 2 £695 Book places
Tue/Wed 11-12 December 2018 2 £850 Book places
Thu/Fri 24-25 January 2019 2 £695 Book places
Thu/Fri 07-08 February 2019 2 £850 Book places
Tue/Wed 12-13 March 2019 2 £695 Book places
Thu/Fri 04-05 April 2019 2 £850 Book places
Date(s) Venue
08/10
18/10
05/11
11/12
11/12
24/01
07/02
12/03
04/04

All prices exclude VAT. If you can't see the dates you want, ask us about running onsite Report Builder training at your offices (we'll even provide and set up the computers).

Related Courses

Reporting Services RECOMMENDED

Introduction

2 day course

Advanced SSRS

Advanced

2 day course

Introduction to SQL

Introduction

2 day course

Other Report Builder training resources

Report Builder exercises

Report Builder exercises

We've put all of our exercises on Report Builder online, to allow you to inspect them before booking this two-day course.

View Report Builder or SSRS 2016 exercises

Report Builder videos

Report Builder videos

You can have a look at our Report Builder videos, to help you to learn how to create reports.

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

Report Builder blogs

Report Builder blogs

There are blogs on Report Builder here, which are always worth referring to in an emergency!

View SSRS blogs

This page has 0 threads Add post