Enable Technology

SQL SERVER REPORTING SERVICES NEWTOWN TRAINING COURSES 

SQL SERVER REPORTING SERVICES TRAINING COURSES NEWTOWN




About Enable Technology Newtown 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 training will be delivered by a Microsoft professional with development experience. We will issue each SQL Server Reporting Services training participant with learning resources which they can refer to post training. We also provide an ongoing support service to people attending our SQL Server Reporting Services courses. Delegates can contact the course tutor with specific SQL Server Reporting Services questions for as long as they need following the course.

We provide instructor led training coupled with hands on training. 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. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite SQL Server Reporting Services course to some extent is bespoke and tailored to your needs.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Norwich Union PLC, Wolverhampton City Council, Unipart Group, DHL Express, Birmingham Heartlands Hospital, Queen's Medical Centre Nottingham, Countrywide Homes Limited and Boots UK Limited.




SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Newtown
  • 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 ...
  • Data Set Parameters
    Indicators
    Designing the Page Layout
    Synchronized Data Alignment  Using the Tablix Report Type
    Report Project Types  Working with Report Server Projects
    Native Mode Architecture
    Sparkline
    Built-in Functions
    Installing SQL Server Data Tools
    The Tablix Component
    Creating a Custom Age Function
    Formatting a Chart  Visualising Performance with Data Bars, Sparklines and Indicators
    A Tour of the Report Builder Interface
    Create a Report with Interactive Sorting Dynamic Reports with Parameters
    Create Shared Data Sources and Data Sets
    User Collection
    Create a Map Report
    Creating a Shared Data Source and Data Sets
    Shared Dataset Design View  Creating Ad Hoc Reports with Report Builder
    Create a Drop-Down List Parameter
    Displaying the Parameter Value and Label for a Drop-Down List Parameter

  • See Training Course Details...


SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Newtown
  • 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 ...
  • Learn about report variables and when you might need to use them 
    Investigate how to manage Reporting Services projects using Report Manager 
    Explore creating groups 
    Learn how to create parameters in ad-hoc SQL 
    Investigate how Reporting Services secures access to reports and other Reporting Services resources 
    Discover how to improve parameter prompts using drop-down list parameters 
    Learn how to create custom functions using the Code window 
    Learn how to deploy Reporting Services projects and individual reports and data sources 
    Investigate the scheduling of report snapshots 
    Creating Matrix Reports and Charts
    Learn how to create data-driven report subscriptions 
    Explore the use of the Report Viewer controls to create Web pages and Windows Forms that render Reporting Services reports in place 
    Introducing SQL Server Reporting Services
    Dig into the use of unbound, multivalued, and cascading parameters 
    Understanding how Reporting Services parameters work with stored procedure parameters 
    Find out how to display parameter values in report headers 
    Explore the potential deployment and security issues that might arise when working with custom assemblies 
    Learn how to create a tabular report from scratch 
    Learn how to create matrix reports 
    Grouping and Sorting

  • See Training Course Details...


Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Newtown
  • 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 ...
  • Drillthrough in mobile reports
    Topics include Introduction to Reporting Services
    Databars, sparklines, indicators, gauges, and maps
    Reporting services components
    Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
    Report caching, snapshots, and comments
    Mobile report publisher
    Extend reporting services functionality with external assemblies.
    Configuring data access with report builder
    Drilldown and drill through Sharing Reporting Services Reports
    Overview of mobile reports
    Introduction to reporting services
    Report parameters
    Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
    Schedules
    Preparing data for mobile reports
    Data filters
    Publish a report to reporting services Working with Reporting Services Data
    Reporting services tools Reporting Services Data Sources
    Configuring data access with report designer
    Report sub-reports

  • See Training Course Details...


Microsoft SQL Server 2016 Report Builder SSRS

  • 2 day course
  • Location: Newtown
  • 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 Map Wizard
    Filtering, Grouping, and Sorting
    Exploring Matrix
    Mastering Data Region(s)
    SQL Server 2016 Report Builder Basic Reports
    Understanding Variances Between SQL Versions
    Understanding HTML5 and Textboxes
    Examining Management
    Planning Your Reports
    Understanding Visualizations
    Working with Datasets
    Utilizing Lists
    Examining Security
    Working with Expressions
    Utilizing Chart Wizard
    Exploring the Report Builder Interface
    Formatting Reports
    SQL Server 2016 Report Builder Wizards
    Exploring Gauges
    Introduction to SQL Server 2016 Report Builder
    Creating Subreports and Drillthrough Reports

  • See Training Course Details...


SQL Server 2005 Reporting Services SSRS

  • 2 day course
  • Location: Newtown
  • 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 Deployment Options
    Introduction to Reporting Services 2005
    Adding or Deleting
    Getting Started Pane
    General
    Visibility
    Deploying the Auditing and Management Reports
    Building a Table Report
    Server Management Reports
    Interactive Sort
    Setting the Reporting Services 2005 Report Properties
    Choose Table Style or Matrix Style Dialog
    Perspectives
    Reporting Services 2005 Menus
    Design the Query Dialog
    Reporting Services 2005 Windows
    Quick Formatting using Toolbar and Menu Options
    Reporting Services 2005 Query vs. Report Parameters
    Creating a Data Source and Dataset
    Usability Features

  • See Training Course Details...



Email us about this courses



Other Newtown Enable Technology Training Courses

VBA - Newtown Excel Training Courses
Crystal XI Newtown Training Courses
Access VBA - Newtown Access Training Courses
SSAS 2008 Newtown Training Courses
Crystal 2016 - Newtown Crystal Reports Training Courses
Power Graphics Newtown Training Courses
SSIS 2008 - Newtown SQL Server Integration Services Training Courses
Microsoft Project Level 2 Newtown Training Courses
DAX - Newtown Excel Training Courses
Microsoft Project Level 3 Newtown Training Courses
Oracle SQL - Newtown SQL Training Courses
SQL - Newtown SQL Training Courses
SSAS 2014 - Newtown SQL Server Analysis Services Training Courses
Excel Advanced - Newtown Excel Training Courses
Power BI - Newtown Microsoft Power BI Training Courses



Wales - Possible Sql Server Reporting Services Training Course Locations


Neath, Pyle, Llanelli, Caerphilly, Llandudno, Mid Glamorgan, Cil-y-coed, Newport, Abertillery, Gwynedd, Splott, Treharris, Wales, Holyhead, Cwmbran, Bangor, Barry, Llantwit Major, Aberdare, Tredegar, Blackwood, Powys, Clwyd, South Glamorgan, Aberystwyth, Ammanford, Merthyr Tydfil, Llanrumney, Haverfordwest, Newtown, Swansea, Wrexham, Tonypandy, Penarth, Buckley, Mold, Dyfed, Bedwas, Rhosllanerchrugog, Prestatyn, West Glamorgan, Milford Haven, Pontypridd, Bridgend, Mountain Ash, Ystrad Mynach, Monmouth, Porthcawl, Maesteg, Flint, Colwyn Bay, Cardiff, Gwent, Risca, Carmarthen, Llantrisant, Abergavenny, Bargoed, Gorseinon, Rhyl, Bryn Pydew