Enable Technology

SQL SERVER REPORTING SERVICES MOUNTAIN ASH TRAINING COURSES 

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 
    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 

  • See Training Course Details...


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.
    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

  • See Training Course Details...


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
    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

  • See Training Course Details...


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
    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

  • See Training Course Details...


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
    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

  • See Training Course Details...



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