SQL SERVER REPORTING SERVICES TRAINING COURSES MOUNTAIN ASH
About Enable Technology Mountain Ash SQL Server Reporting Services Training Courses
Enable Technology offer short intensive skills based SQL Server Reporting Services training courses. We guarantee the training will be delivered by a Microsoft certified expert. Everyone attending a SQL Server Reporting Services course receives learning resources which also serves as a reference source after the course. Our policy is to provide open ended SQL Server Reporting Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Courses are instructor led and groups sizes small. During the Covid 19 crisis we can deliver this course online. Delegates participate in a virtual SQL Server Reporting Services class and can both talk to and share their screen with the tutor. The SQL Server Reporting Services syllabus can be modified to accommodate your specific training needs.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Carillion PLC, Dollond & Aitchison Limited, Wolverhampton City Council, Norwich Union PLC, Yell Group PLC, Halfords Group PLC, GKN PLC and Birmingham City University.
SQL Server 2008 Reporting Services SSRS
- 2 day course
- Location: Mountain Ash
- 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...
Learn how to calculate group totals and percentages
Find out how you can use conditional formatting to make your reports more dynamic
Learn how to create matrix reports
Investigate how to call a custom assembly from a report
Understand scope as it applies to aggregate functions
Investigate how Reporting Services secures access to reports and other Reporting Services resources
Dig into the use of unbound, multivalued, and cascading parameters
Learn how to create parameters in ad-hoc SQL
Ad-Hoc Reporting with Report Builder 2.0
Investigate Reporting Services charts
Gain a basic understanding of the components behind SQL Server Reporting Services
Learn how to format report items using the formatting toolbars, the Properties window, and the Textbox Properties dialog box
Investigate the scheduling of report snapshots
Managing Reporting Services
Explore the storing of credentials within a data source
Learn how to create custom functions using the Code window
Explore the maintenance of report history
Microsoft SQL Server Reporting Services SSRS 2016
- 3 day course
- Location: Mountain Ash
- 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 ... Secure access to reports by using authentication, permissions, and SSL encryption.
- See Training Course Details...
Reporting services components
Topics include Introduction to Reporting Services
Add a drillthrough to a custom URL
Preparing data for mobile reports
Report caching, snapshots, and comments
Use report services configuration manager to reconfigure SSRS servers.
Extend reporting services functionality with external assemblies.
Sorting and grouping
Databars, sparklines, indicators, gauges, and maps
Use databars, sparklines, and indicators in reports Summarising Report Data
Report parameters
Schedules
Reporting services tools Reporting Services Data Sources
Mobile report publisher
Configuring data access with report builder
Configuring data access with report designer
Work with expressions and embedded code.
Images and charts
Drillthrough in mobile reports
Creating a report with the report wizard
SQL Server Reporting Services SSRS 2012/2014
- 2 day course
- Location: Mountain Ash
- 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 ... Using Unbound Parameters Understanding Report And Data Set Parameters
- See Training Course Details...
Report Designer and Data Windows Configuring Report Projects
Expression Operators
Creating a Columnar Report
Formatting a Chart Visualising Performance with Data Bars, Sparklines and Indicators
Work with Multivalued Parameters Enhancing Reports with Data Visualisations
Page Headers and Footers Report Formatting Options
Create a Data Source Connection
Using Charts in a Report
Create a Shared Data Source and Two Data Sets
The Global Collections
Introducing SQL Server Data Tools
Indicators
Creating Report Parameters
Setting Report Project Properties
Cascading Parameters
Built-in Functions
Create a Parameterised Report
Overview
Writing and Using Report Expressions
Data Bars
Microsoft SQL Server 2016 Report Builder SSRS
- 2 day course
- Location: Mountain Ash
- 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 ... Exploring the Report Builder Interface
- See Training Course Details...
Utilizing Data Sources
Exploring Matrix
Mastering Data Region(s)
Using Tables
SQL Server 2016 Report Builder Graphics
Utilizing Charts
Understanding Variances Between SQL Versions
Examining Parameters
Working with Map Wizard
Exploring Gauges
Understanding Report Parts
Utilizing Dynamic Headers and Footers
SQL Server 2016 Report Builder Wizards
Utilizing Lists
Understanding HTML5 and Textboxes
Examining Security
Examining Maps
Utilizing Chart Wizard
Working with Expressions
SQL Server 2005 Reporting Services SSRS
- 2 day course
- Location: Mountain Ash
- 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 ... Database Components
- See Training Course Details...
Usability Features
Current Classroom Folder Structure
Model Designer Layout
Add Report Parameter to a Dataset
Visibility
Previewing a Report with Parameters
Report Borders Toolbar
General
Chart Types
Entities
Dynamic Parameter Values (From Query)
Reporting Services 2005 Toolbars
Attributes
Adding Groups and Users
Understanding Reporting Services 2005 Caching
Server Properties
Table Data Region Record Sorting
Visibility
Diagram Organizer Pane
Email us about this courses
Other Mountain Ash Enable Technology Training Courses
Crystal 2016 - Mountain Ash Crystal Reports Training Courses
Power BI - Mountain Ash Microsoft Power BI Training Courses
SSIS 2005 Mountain Ash Training Courses
Access 2016 Mountain Ash Training Courses
Microsoft Project Level 3 Mountain Ash Training Courses
Power Graphics Mountain Ash Training Courses
Mobile Mountain Ash Training Courses
PowerPoint Basic Mountain Ash Training Courses
SQL Mountain Ash Training Courses
Oracle SQL Mountain Ash Training Courses
VBA - Mountain Ash Excel Training Courses
Microsoft Project Level 2 Mountain Ash Training Courses
TSQL - Mountain Ash SQL Training Courses
Power Query Mountain Ash Training Courses
Data Warehouse - Mountain Ash SQL Training Courses
Wales - Possible Sql Server Reporting Services Training Course Locations
Bridgend, Cardiff, Cwmbran, Holyhead, Llantwit Major, Cil-y-coed, Penarth, Aberdare, Buckley, Clwyd, Rhyl, Newtown, Llantrisant, Newport, Bryn Pydew, Monmouth, Merthyr Tydfil, Carmarthen, Bedwas, Tredegar, Barry, Powys, Abergavenny, Splott, Colwyn Bay, Gwynedd, Wales, Swansea, Tonypandy, Rhosllanerchrugog, Mold, Dyfed, Abertillery, Prestatyn, Milford Haven, Pyle, Flint, Porthcawl, Maesteg, Gwent, Wrexham, Mountain Ash, Llandudno, Caerphilly, Treharris, Bargoed, Blackwood, South Glamorgan, Llanrumney, Mid Glamorgan, Risca, Pontypridd, Aberystwyth, Llanelli, West Glamorgan, Gorseinon, Haverfordwest, Neath, Ystrad Mynach, Ammanford, Bangor