SQL SERVER REPORTING SERVICES TRAINING COURSES ATHERSTONE
About Enable Technology Atherstone SQL Server Reporting Services Training Courses
We offer intensive two and three days SQL Server Reporting Services courses. The training will be delivered by a Microsoft professional with development experience. Every course participant will receives course practice files and SQL Server Reporting Services course resources that can be referenced post training. It is our company policy to provide SQL Server Reporting Services training participants with ongoing support from the course Tutor. People who attend a SQL Server Reporting Services course can contact the Tutor for as long as they need assistance after the training.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology can provide SQL Server Reporting Services courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a SQL Server Reporting Services course at an alternative training site in Atherstone. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Reporting Services training needs.
We can also deliver SQL Server Reporting Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are GKN PLC, West Bromwich Building Society, Carillion PLC, Lloyds TSB Bank PLC, Canadian High Commission, Shell UK Oil Products Ltd, Barclays Bank PLC and Norwich Union PLC.
SQL Server Reporting Services SSRS 2012/2014
- 2 day course
- Location: Atherstone
- 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 ... Working with Maps and Spatial Data Enhancing Reports with Data Visualisation
- See Training Course Details...
A Tour of the Report Builder Interface
Writing and Using Report Expressions
User Collection
Multivalued Parameters Dynamic Reports with Parameters
Create a Matrix Report
Sharing Custom Code with Multiple Reports Calculations Using Expressions and Functions
Using Parameters with Ad Hoc SQL
Null Handling
Overview
Creating a Custom Age Function
Create a Custom Function Managing Page Layout and Adding Interactivity
Create a Tabular Report Using the Tablix Report Type
Providing a Drop-Down List for a Report Parameter
Field Collection
Creating Report Parameters
The Tablix Component
Globals Collection Creating Custom Functions
Displaying the Parameter Value and Label for a Drop-Down List Parameter
Creating a Customer Contact List Creating Ad Hoc Reports With Report Builder
SQL Server 2008 Reporting Services SSRS
- 2 day course
- Location: Atherstone
- 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 ... Explore the potential deployment and security issues that might arise when working with custom assemblies
- See Training Course Details...
Introducing SQL Server Reporting Services
Learn about datasets and data regions
Learn how to create parameters in ad-hoc SQL
Discover the various global collections that you can reference in your expressions
Learn how to calculate group totals and percentages
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
Master the Reporting Services Grouping pane
Understand how to plan and configure for deployment
Find out how to use Report Manager to manage user accounts and roles
Investigate Reporting Services charts
Learn how to create custom functions using the Code window
Calculation and Formatting
Investigate the scheduling of report snapshots
Discover the classes and methods exposed by the Reporting Services Web Service API
Learn how to solve common parameter issues
Find out how to create drill-down reports
Explore the use of Reporting Services gauges
Microsoft SQL Server Reporting Services SSRS 2016
- 3 day course
- Location: Atherstone
- 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 ... Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
- See Training Course Details...
Overview of mobile reports
Report subscription and delivery Administering Reporting Services
Using Datasets Creating Paginated Reports
Databars, sparklines, indicators, gauges, and maps
Report parameters
Use report services configuration manager to reconfigure SSRS servers.
Topics include Introduction to Reporting Services
Reporting services tools Reporting Services Data Sources
Preparing data for mobile reports
Use databars, sparklines, and indicators in reports Summarising Report Data
Data filters
Introduction to reporting services
Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
Configuring data access with report designer
Creating a report with the report wizard
Mobile report publisher
Images and charts
Report caching, snapshots, and comments
Add a drillthrough to a custom URL
Secure access to reports by using authentication, permissions, and SSL encryption.
SQL Server 2005 Reporting Services SSRS
- 2 day course
- Location: Atherstone
- 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 ... Filters
- See Training Course Details...
General
Quick Formatting using Toolbar and Menu Options
Using the Reporting Services 2005 Graphical Query Designer
Creating Formulas
Creating a Report Model Project
Report Server Components
Getting Started Pane
Reporting Services 2005 Data Processing Extensions
The Reporting Services 2005 Report Wizard
Explorer Pane
Reporting Services 2005 Data Options
Choose Table Style or Matrix Style Dialog
Select the Data Source Dialog
Displaying Parameters in a Report
Understanding Snapshots
Clickthrough Reports
Reporting Services 2005 Diagram Pane
Starting SQL Server Business Intelligence Development Studio
Microsoft SQL Server 2016 Report Builder SSRS
- 2 day course
- Location: Atherstone
- 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 ... Working with Expressions
- See Training Course Details...
SQL Server 2016 Report Builder Graphics
SQL Server 2016 Report Builder Wizards
Exploring Gauges
Planning Your Reports
Utilizing Chart Wizard
Examining Security
SQL Server 2016 Report Builder Advanced Reporting
Creating Subreports and Drillthrough Reports
Examining Maps
Exploring Subscriptions
Working with Datasets
Examining Parameters
Understanding Report Parts
Introduction to SQL Server 2016 Report Builder
Utilizing Charts
Formatting Reports
Exploring the Report Builder Interface
Email us about this courses
Other Atherstone Enable Technology Training Courses
PHP - Atherstone PHP Training Courses
Data Warehouse - Atherstone SQL Training Courses
Crystal 2013 - Atherstone Crystal Reports Training Courses
Excel Power Pivot - Atherstone Excel Training Courses
Microsoft Project Level 2 Atherstone Training Courses
Excel Advanced - Atherstone Excel Training Courses
Visio 2013 - Atherstone Visio Training Courses
Power Query Atherstone Training Courses
Crystal 2011 - Atherstone Crystal Reports Training Courses
SSIS 2014 Atherstone Training Courses
Project 2016 L1 - Atherstone Microsoft Project Training Courses
Power BI Atherstone Training Courses
HTML Atherstone Training Courses
Crystal 2016 - Atherstone Crystal Reports Training Courses
Oracle SQL - Atherstone SQL Training Courses
Midlands - Possible Sql Server Reporting Services Training Course Locations
Tipton Sql Server Reporting Services Training Courses Tipton, Evesham, Kidderminster, Rugeley, Sandwell, Leek, Staffordshire, Burton On Trent, Cannock, Worcester, Midlands, Coventry, Kidsgrove, Cheltenham, Shropshire, Telford, Bedworth, Wednesbury, Stoke On Trent, Milton Keynes, Herefordshire, Worcestershire, Smethwick, Wolverhampton, Bromsgrove, West Midlands, Birmingham, West Bromwich, Rugby, Redditch, Walsall, Warwickshire, Atherstone, Solihull, Nuneaton, Leicester, Oswestry, Lichfield, Stafford, Oxford, Northhampton, Hereford, Dudley, Stratford Upon Avon, Leamington Spa, Kenilworth, Tamworth, Shrewsbury, East Midlands, Stourbridge, Staffordshire, Chester, Newcastle Under Lyme, Leicestershire, Malvern, Halesowen, Bridgnorth, Warwick, Crewe, Droitwich, Derby, Uttoxeter, Nottingham, Rowley, Black Country, Stourbridge
Evesham Sql Server Reporting Services Training Courses
Kidderminster Sql Server Reporting Services Training Courses
Rugeley Sql Server Reporting Services Training Courses
Sandwell Sql Server Reporting Services Training Courses
Leek Sql Server Reporting Services Training Courses
Staffordshire Sql Server Reporting Services Training Courses
Burton On Trent Sql Server Reporting Services Training Courses
Cannock Sql Server Reporting Services Training Courses
Worcester Sql Server Reporting Services Training Courses
Midlands Sql Server Reporting Services Training Courses
Coventry Sql Server Reporting Services Training Courses
Kidsgrove Sql Server Reporting Services Training Courses
Cheltenham Sql Server Reporting Services Training Courses
Shropshire Sql Server Reporting Services Training Courses
Telford Sql Server Reporting Services Training Courses
Bedworth Sql Server Reporting Services Training Courses
Wednesbury Sql Server Reporting Services Training Courses
Stoke On Trent Sql Server Reporting Services Training Courses
Milton Keynes Sql Server Reporting Services Training Courses
Herefordshire Sql Server Reporting Services Training Courses
Worcestershire Sql Server Reporting Services Training Courses
Smethwick Sql Server Reporting Services Training Courses
Wolverhampton Sql Server Reporting Services Training Courses
Bromsgrove Sql Server Reporting Services Training Courses
West Midlands Sql Server Reporting Services Training Courses
Birmingham Sql Server Reporting Services Training Courses
West Bromwich Sql Server Reporting Services Training Courses
Rugby Sql Server Reporting Services Training Courses
Redditch Sql Server Reporting Services Training Courses
Walsall Sql Server Reporting Services Training Courses
Warwickshire Sql Server Reporting Services Training Courses
Atherstone Sql Server Reporting Services Training Courses
Solihull Sql Server Reporting Services Training Courses
Nuneaton Sql Server Reporting Services Training Courses
Leicester Sql Server Reporting Services Training Courses
Oswestry Sql Server Reporting Services Training Courses
Lichfield Sql Server Reporting Services Training Courses
Stafford Sql Server Reporting Services Training Courses
Oxford Sql Server Reporting Services Training Courses
Northhampton Sql Server Reporting Services Training Courses
Hereford Sql Server Reporting Services Training Courses
Dudley Sql Server Reporting Services Training Courses
Stratford Upon Avon Sql Server Reporting Services Training Courses
Leamington Spa Sql Server Reporting Services Training Courses
Kenilworth Sql Server Reporting Services Training Courses
Tamworth Sql Server Reporting Services Training Courses
Shrewsbury Sql Server Reporting Services Training Courses
East Midlands Sql Server Reporting Services Training Courses
Stourbridge Sql Server Reporting Services Training Courses
Staffordshire Sql Server Reporting Services Training Courses
Chester Sql Server Reporting Services Training Courses
Newcastle Under Lyme Sql Server Reporting Services Training Courses
Leicestershire Sql Server Reporting Services Training Courses
Malvern Sql Server Reporting Services Training Courses
Halesowen Sql Server Reporting Services Training Courses
Bridgnorth Sql Server Reporting Services Training Courses
Warwick Sql Server Reporting Services Training Courses
Crewe Sql Server Reporting Services Training Courses
Droitwich Sql Server Reporting Services Training Courses
Derby Sql Server Reporting Services Training Courses
Uttoxeter Sql Server Reporting Services Training Courses
Nottingham Sql Server Reporting Services Training Courses
Rowley Sql Server Reporting Services Training Courses
Black Country Sql Server Reporting Services Training Courses
Stourbridge Sql Server Reporting Services Training Courses