Book now

Data Analysis using Microsoft SQL Report Builder

Course summary

This course focus on producing reports using MS SQL Server Report Builder 3.0 : how to use the product features and tools related to data retrieval, visualisations and deployment.
The Target Audience: end-users who will produce reports for their department or group without in-depth SQL knowledge.

MS SQL Server Report Builder 3.0 gives you a user-friendly visual interface to create report.

Course Outline

Report Models

  • Data source views
  • Creating a model
  • Entities, attributes and roles

Tables

  • Creating tables
  • Interactive sorting
  • Floating headers

Grouping

  • Inserting groups
  • Group headers/footers
  • Displaying group totals
  • Expanding and collapsing

Expressions

  • The expression builder
  • The ReportItems collection
  • Built-in fields
  • Conditional formatting expressions

Page set-up

  • Page headers and footers
  • Page names and numbers

Exporting reports

  • The various report formats
  • Using RenderFormat.Name

Parameters

  • Creating parameters
  • Filtering using parameters
  • Drop list parameters
  • Coping with empty tables

Matrices

  • Row and column groups
  • Sorting and filtering matrices
  • Creating subtotals

Charts

  • Creating charts
  • The parts of a chart
  • Formatting charts

Basic reports

  • Text boxes and images
  • Selecting report items
  • Formatting parts of a report

Miniature charts

  • Creating sparklines
  • Creating data bars

Graphical indicators

  • Creating and customising indicators
  • Linear and radial gauges

Lists

  • Page-per-record lists
  • Dashboard lists
  • Other list ideas

Subreports

  • Creating a child report
  • Creating the main report
  • Linking the two reports

Report parts

  • Publishing report parts
  • The report part gallery
  • Updating report parts

Book this course

Choose from the start dates and other options below. Click on each row to get more information. When you have found your ideal combination click "Book now" to proceed.

Buy a voucher
Starting How long Where Price

Mon 27th Nov
11:00am - 6:00pm

2 Days
Full time
London,
WC2N 5BY
Map

£750.00 30% off
£525
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Mon 27th Nov
11:00am - 6:00pm

2 days
Full time
Milton Keynes,
MK9 2UB
Map

£750.00 30% off
£525
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Mon 27th Nov
11:00am - 6:00pm

2 Days
Full time
Southend-On-Sea,
SS1 1NE
Map

£750.00 30% off
£525
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Mon 27th Nov
11:00am - 6:00pm

2 Days
Full time
Manchester,
M2 2AN
Map

£750.00 30% off
£525
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 29th Nov
11:00am - 6:00pm

2 Days
Full time
London,
WC2N 5BY
Map

£750.00 30% off
£525
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 29th Nov
11:00am - 6:00pm

2 Days
Full time
Manchester,
M2 2AN
Map

£750.00 30% off
£525
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 29th Nov
11:00am - 6:00pm

2 days
Full time
Milton Keynes,
MK9 2UB
Map

£750.00 30% off
£525
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 29th Nov
11:00am - 6:00pm

2 Days
Full time
Southend-On-Sea,
SS1 1NE
Map

£750.00 30% off
£525
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 27th Dec
11:00am - 6:00pm

2 Days
Full time
London,
WC2N 5BY
Map

£750.00 30% off
£525
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 27th Dec
11:00am - 6:00pm

2 days
Full time
Milton Keynes,
MK9 2UB
Map

£750.00 30% off
£525
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher