SQL Server Report Builder Course

Short course

Online

£ 750 VAT exempt

Description

  • Type

    Short course

  • Level

    Beginner

  • Methodology

    Online

  • Duration

    2 Days

Data analysis using Microsoft SQL Report Builder

Are you ready to separate yourself from the crowd by learning how to use MS SQL Server Report Builder? With the course SQL Server Report Builder Course offered by Emagister and imparted by PCWorkshops you’ll be set!


What makes this course exceptional is its lessons in MS SQL SSRS, which is a report builder especially good, that gives you a user-friendly visual interface to create a report and most importantly, very easy to learn!

The program focuses on making reports with this program, including its features and different tools regarding data retrieval, visualizations and deployment. At the beginning you’ll learn about report models and how data source is composed, also, creating tables and displaying them into groups: expanding and collapsing them.

Furthermore, you’ll get in touch with matrices, charts and expression builder. Exporting reports and how to keep them all updated and published properly.

This programme includes a SSRS Course certificate, including the notes, practical exercises, revisions of your work and also coffee and tea. In order to prepare you for the certification, you’ll have one free session via Skype or TeamViewer for questions online. (Maximum groups of 4 students).

So, if you want to learn more, don’t hesitate to contact PCWorkshops through Emagister

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now closed

About this course

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.


End-users who will produce reports for their department or group without in-depth SQL knowledge.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2018

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 7 years

Subjects

  • Server
  • SQL
  • Builder
  • Visualisation
  • Reports
  • Conditional Formatting
  • Charts
  • Data Analytics
  • Graphical Indicators
  • Data Retrieval

Teachers and trainers (1)

Sarah Barnard

Sarah Barnard

Coder, Instructor

Java Coding, Beginner - Advanced, JDBA, Hibernate, Spring. OO Programming. Android Studio. Excel VBA. Cobol. Databases, MS SQL Server, Oracle 11g, MySQL, Access Database, Excel, MS Power BI, Tableau, SSRS, MS SQL Server Report Builder.

Course programme

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 Report Items collection
  • Built-in fields
  • Conditional formatting expressions
  • 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

Read more:
https://pcworkshopslondon.co.uk/sql-server-report-report-builder.html

SQL Server Report Builder Course

£ 750 VAT exempt