Visual Data with MS SQL Server Reporting Service (SSRS)

Short course

Online

Save 10%
£ 675 VAT exempt

Description

  • Type

    Short course

  • Level

    Beginner

  • Methodology

    Online

  • Duration

    2 Days

Create insightful visual reports using SSRS

This course focus on creating insightful visual reports using MS SQL SSRS. we cover the various features and capabilities of SSRS and practice to create different visual with parameters and interactivity.
The Target Audience for this course would ideally be end-users who need to present data via visual reports without in-depth SQL knowledge.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now closed

About this course

To connect data to SSRS, create data visualisation and BI Reports.

BI Professional, data analysts, anyone using MS SQL Server

Some understanding of SQL queries

Internal Course Attendance Certificate

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

  • Data Mining
  • Data warehousing
  • Server
  • Database
  • SQL
  • Data Collection
  • SQL Database
  • SQL Server
  • Data Types
  • Database Design
  • SQL queries

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

  • Views of Data Sources, Creating a model, introducing the concepts of entities, attributes and roles

Tables

  • Creating tables with sorting and floating headers

Grouping

  • Inserting groups with group headers and group footers, creating group totals, Expanding and collapsing the groups

Expressions

  • Introducing the expression builder, Report Items, Built-in fields and conditional formatting options and expressions

Page set-up

  • Creating page names, numbers, headers, footers

Exporting reports

  • Exporting the reports using various report formats, using RenderFormat.Name

Parameters

  • What are report parameters, creating and editing report parameters, using the parameters to filter reports, creating parameter drop lists. and copying 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, using the part gallery and update report parts

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

Visual Data with MS SQL Server Reporting Service (SSRS)

£ 675 VAT exempt