SQL Server Reporting Services training course

Retrieve Your Corporate Data With SQL Server Reporting Services - And Gain A Competitive Advantage!

NEXT COURSE 20 January (2 days £995 + VAT) BOOK NOW
See more dates …
Highlights Overview Audience Course Details Prices & Dates
JBI training course London UK
  • Create BI Reports
  • Deploy BI Reports
  • Manage BI Reports
  • Maximize powerful, integrated SSRS capabilities
  • Retrieve Your Corporate Data With SQL Server Reporting Services - And Gain A Competitive Advantage
  • Optional days - SSRS more broadly and in more depth.

FULL COURSE DETAILS

This Microsoft SQL Server Reporting Services SSRS training course gets delegates to grips with a key part of the Microsoft BI stack, The course covers the discovery and preparation of data, the modelling of the data, and the presentation of the data in insightful and attractive reports and dashboards.

We spend two days looking at Reporting Services (SSRS) and other visualisation tools such as Power BI – when you return to the office, you will easily be able to create wonderful and informative reports and dashboards.

All the work you do is saved and you can take it with you for future reference.


FULL COURSE DETAILS
JBI training course London UK
JBI training course London UK

Developers and analysts who need to design and build reports. Administrators who wish to deploy and manage reports. Some basic SQL skills would be an advantage.

 


FULL COURSE DETAILS

Related Courses

Microsoft Business Intelligence 2016
SQL Server Analysis & Int Services
Cube Design
Power BI
Power BI - Beyond the Basics
Power BI - Dax

Course Details

SSRS Fundamentals

  • SSRS overview
  • Reporting Services
  • Report Server
  • Report Designer
  • Report Builder
  • Report Manager

Designing reports – fundamentals

  • Report Wizard in SSDT-BI (aka BIDS/Visual Studio)
  • SQL relational reports
  • Tablixes (tables and matrixes)

Previewing reports
Deploying reports to Report Manager

Designing reports – further techniques

  • Formatting (including dates and currency)
  • Using expressions
  • Conditional formatting (and green-band reporting)
  • KPIs for SSRS
  • Grouping and drilldown
  • Grand totals, subtotals, and running totals
  • Interactive sorting
  • Charts and gauges
  • Parameterized SQL reports
  • Exporting reports to Excel or PDF
  • Report templates with global parameters
  • Multiple reports
  • Drilldown versus drillthrough
  • Subreports
  • Jump reports
  • Linked reports

Administration

  • Reporting Services Configuration Manager
  • Report caching
  • Report snapshots
  • Report subscriptions (emailing reports)
  • Security overview
 
Course Updates & Newsletter
 
 

Receive the latest version of this course by email & subscribe to our Newsletter



CONTACT
0800 028 6400

enquiries@jbinternational.co.uk

SHARE

Corporate Policies     Terms & Conditions
JB International Training Ltd  -  Company number 08458005

Registered address 1345 High Road, London, N20 9HR