SQL SERVER REPORTING SERVICES TRAINING COURSES SOMERSET
About Enable Technology Somerset SQL Server Reporting Services Training Courses
Enable Technology has twenty year track record of providing short intensive SQL Server Reporting Services skills based training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Every course participant will receives course practice files and SQL Server Reporting Services course resources that can be referenced post training. Enable Technology offer post course help to all delegates. Participants on the SQL Server Reporting Services course can contact the tutor for as long as they like if they encounter SQL Server Reporting Services problems.
SQL Server Reporting Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. During the current lockdown this course is delivered in a virtual classroom. Delegates can log into a scheduled SQL Server Reporting Services course, watch the tutor demonstrate tasks, ask questions and share their own screen. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Reporting Services training needs.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Halfords Group PLC, Queen's Medical Centre Nottingham, Capita Group PLC, Total Telecommunications Limited, Barclays Bank PLC, Norwich Union PLC, Royal & Sun Alliance Group PLC and Boots UK Limited.
Microsoft SQL Server 2016 Report Builder SSRS
- 2 day course
- Location: Somerset
- Telephone on 01952 305730
- Course Outline
-
Aimed at Data Analysts and SQL users this instructor-led course provides participants with the necessary knowledge to develop reports using Microsoft SQL Server 2016 Report Builder. The course covers Report Builder wizards, basics of report design, report parameters, report expressions, filters, report visualisations including graphs, charts, images and gauges. The course also covers the use of maps, interactive reports, report parts, sub reports, subscriptions and exporting options.
- Some of the training topics covered include ... Understanding Variances Between SQL Versions
- See Training Course Details...
Working with Map Wizard
Exploring Subscriptions
Examining Management
Using Tables
Exploring the Report Builder Interface
Examining Parameters
Utilizing Chart Wizard
Working with Expressions
SQL Server 2016 Report Builder Wizards
Examining Maps
Exploring Table or Matrix Wizard
Working with Datasets
Filtering, Grouping, and Sorting
Planning Your Reports
Utilizing Charts
Examining Security
Introduction to SQL Server 2016 Report Builder
Visualizing Your Company Report Templates
SQL Server 2005 Reporting Services SSRS
- 2 day course
- Location: Somerset
- Telephone on 01952 305730
- Course Outline
-
This is a two day course which equips participants with the skills necessary to effectively use SQL Server 2005 Reporting Services. Enable Technology also run a comparable two day Reporting Services 2000 training course.
- Some of the training topics covered include ... Reporting Services 2005 Menus
- See Training Course Details...
The Reporting Services 2005 Report Designer
Understand the Report Model Architecture
Model Designer Layout
Using the Expression Editor Dialog
Understanding the Model Designer
Previewing Reporting Services 2005 Reports
Changing Columns and Rows
Reporting Services 2005 Query and Report Parameters
Report Borders Toolbar
Formatting
General
Adding Reporting Services 2005 Users
Attributes
Using Reporting Services 2005 Report Builder
Creating a Subscription
Table Data Region Record Sorting
Filters
Sorting
Reporting Services 2005 Diagram Pane
SQL Server 2008 Reporting Services SSRS
- 2 day course
- Location: Somerset
- Telephone on 01952 305730
- Course Outline
-
A two day intensive course introducing the comprehensive range of SQL Server Reporting Services 2008 report writing and deployment features.
- Some of the training topics covered include ... Discover how to create standard report subscriptions
- See Training Course Details...
Discover the various global collections that you can reference in your expressions
Learn how to create custom functions using the Code window
Investigate the list data region
Explore how to create expressions in your reports using
Investigate what SQL Server Reporting Services can do
Find out how to display parameter values in report headers
Learn how to call the Report Server Web Service
Learn the differences between Report Builder 1.0 and Report Builder 2.0
Learn how to create Report Model projects using Visual Studio and deploy them to a Reporting Services server
Explore creating groups
Calculation and Formatting
Explore how to use Report Builder to build ad-hoc tabular, matrix and chart reports Discover how to create Report Builder reports without using the wizards
Investigate the scheduling of report snapshots
Security
Explore the potential deployment and security issues that might arise when working with custom assemblies
SQL Server Reporting Services SSRS 2012/2014
- 2 day course
- Location: Somerset
- Telephone on 01952 305730
- Course Outline
-
Aimed at Report Writers using SQL Server Reporting Services (SSRS) 2012 and 2014 this intensive two day course demonstrates how to create and deploy parameterised reports using Report Builder and Report Designer. No prior Reporting Services experience is assumed but a reasonable grasp of SQL is essential.
- Some of the training topics covered include ... Create a Map Report
- See Training Course Details...
Designing the Page Layout
Synchronized Data Alignment Using the Tablix Report Type
Create a Parameterised Report
Report Project Configurations Creating a New Report in the Report Designer
Preview Performance
Data Bars
Formatting Text Boxes in the Text Box Properties Dialogue Box
Report Project Types Working with Report Server Projects
Report Items Collection
Formatting a Chart Visualising Performance with Data Bars, Sparklines and Indicators
Drilldown Reports Managing Page Layout and Adding Interactivity
Installing and Configuring Reporting Services Reporting Services Architecture
Rein in the Length of a Text Field
Native Mode Architecture
The Tablix Properties Dialogue Box
Interactive Sorting
Create a Matrix Report
Globals Collection
Globals Collection Creating Custom Functions
Variable Collection
Microsoft SQL Server Reporting Services SSRS 2016
- 3 day course
- Location: Somerset
- Telephone on 01952 305730
- Course Outline
-
This three day intensive course will give delegates a comprehensive understanding of how to design and publish parametrised reports, manage permissions, schedule automated reporting and configure report caching. The course also demonstrates how to build reports designed for tablets and mobile devices.
- Some of the training topics covered include ... Images and charts
- See Training Course Details...
Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
Data filters
Drilldown and drill through Sharing Reporting Services Reports
Report sub-reports
Formatting data
Secure access to reports by using authentication, permissions, and SSL encryption.
Work with expressions and embedded code.
Create a report using report builder or report designer.
Drillthrough in mobile reports
Topics include Introduction to Reporting Services
Reporting services components
Publish a report to reporting services Working with Reporting Services Data
Schedules
Preparing data for mobile reports
Creating a report with the report wizard
Report subscription and delivery Administering Reporting Services
Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
Report caching, snapshots, and comments
Add a drillthrough to a custom URL
Mobile report publisher
Email us about this courses
Other Somerset Enable Technology Training Courses
Crystal 2008 - Somerset Crystal Reports Training Courses
SSIS 2014 - Somerset SQL Server Integration Services Training Courses
Access 2016 - Somerset Access Training Courses
JQuery - Somerset JavaScript Training Courses
Crystal 2013 Somerset Training Courses
Excel Basic - Somerset Excel Training Courses
Crystal 2011 - Somerset Crystal Reports Training Courses
SQL - Somerset SQL Training Courses
SSIS 2008 Somerset Training Courses
TSQL Somerset Training Courses
Microsoft Project Level 3 Somerset Training Courses
CSS - Somerset Web Development Training Courses
Project 2016 - Somerset Microsoft Project Training Courses
JQuery Mobile - Somerset JavaScript Training Courses
Oracle BI - Somerset Data Analytics Training Courses
South West - Possible Sql Server Reporting Services Training Course Locations
Dorchester, Bath, Weymouth, Somerset, Plymouth, Christchurch, Cheltenham, Bournemouth, Tewkesbury, Trowbridge, Stroud, Devon, South West, Bristol, Gloucestershire, Poole, Yoevil, Taunton, Salisbury, Wells, Torquay, Wiltshire, Dorset, Swindon, Chippenham, Exeter, Gloucester, Cirencester