Want to boost enrolments? Login and promote your courses
Searching for courses? Login or register
Courses    
  Most popular search | Share this page  
open My list: 0 courses
Homepage IT, Computing, Telecommunications Courses Database Administration Courses SQL Server Courses

SQL Server 2005 Reporting Services and Analysis Services Overview

in PTR Associates Ltd (England)

Classes Course

Price:

£375 + VAT

Duration:

1 Day

Start:

consult dates and times
See course programme

Request free information

Course objectives:

The objectives for this course are to provide an overview of the key features and architecture of both the SQL Server 2005 Reporting Service and Analysis Service. It would suit anyone wishing to get a fell for what these services can offer and how they might be deployed within a SQL Server 2005 application environment. No in depth rep...

More courses Subject area
Place
 

Request information

Contact directly and with no obligation with
PTR Associates Ltd
You must complete all fields on this form in order for us to send it to the course provider.
We have highlighted incomplete/ incorrect details in red.
* Compulsory fields
By clicking "Email request / Telephone" you registering and accepting the Terms of Use and privacy policy of Emagister.
I wish to receive the personalised newsletter (during a maximum period of 15 days)

Availability?
How do I enrol?
Where can I get more information?

The person in charge of this course will receive your information request instantly.

Response time:
:| :) ;)
Average Fast Very fast
 

Course details

Type Course Duration 1 Day
Method / place Contact course provider Classes
Course objectives The objectives for this course are to provide an overview of the key features and architecture of both the SQL Server 2005 Reporting Service and Analysis Service. It would suit anyone wishing to get a fell for what these services can offer and how they might be deployed within a SQL Server 2005 application environment. No in depth rep...
Price £375 + VAT
Get direct information on how to enrol, venues and availability...

SQL Server courses (from other course providers)

 
Microsoft SQL Server 2005 Solutions MCITP 70-441
We Teach You
Distance - £50 + VAT
 
Server+
focus4training
Multimedia - £298 + VAT
 
SQL for the web
ACS Distance Education
Distance - £280 + VAT
 
Database Administration
Futures Development Limited
Blended - Price: On request
 
Sql For The Windows Environment
Sales 101 Ltd
Online - £125 + VAT
Compare the selected courses

Course programme

SQL Server 2005 Reporting Services and Analysis Services Overview
Course objectives:
The objectives for this course are to provide an overview of the key features and architecture of both the SQL Server 2005 Reporting Service and Analysis Service.

It would suit anyone wishing to get a fell for what these services can offer and how they might be deployed within a SQL Server 2005 application environment.

No in depth report creation or cube creation will be covered, but enough to provide an understanding of the fundamental roles of these services and how they may work together with your SQL Server 2005 or non-SQL Server 2005 database sources.

Course content:
REPORTING SERVICES FEATURES OVERVIEW

REPORTING SERVICES FEATURES
  • Report Creation
  • Tabular Reports
  • Matrix Reports
  • Charts & Graphs
  • Parameters & Groups
  • Aggregate Data, Totals & Sub-totals
  • Drill-down Reports
  • Ad-hoc Reports
  • Report Execution
  • Report Rendering
  • Report Delivery
  • Reporting Services API
  • URL Access
  • Web Services
  • XML
  • Reporting Services Extensions
    REPORTING SERVICES ARCHITECTURE
  • Tools & Utilities
  • Authoring
  • Management
  • Report Server
  • Report Manager
  • Report Processor
  • Scheduling & Delivery Processor
  • Server Extensions
  • Report Server Database
  • Data Sources
    INITIAL REPORTING SERVICES SETUP

    INSTALLING REPORTING SERVICES

    INSTALLING REPORTING SERVICES

    THE REPORTING SERVICES CONFIGURATION MANAGER
  • Virtual Directories
  • Report Server Database
  • Delivery Options
    REPORT MANAGER

    CREATING REPORTS

    CREATING REPORTS
  • Authoring Reports
  • Ad-Hoc Reports
    AUTHORING REPORTS
  • The Report Server Project Wizard
  • Managing Reports
    DISPLAYING REPORTS

    EXPORTING REPORTS
  • Report Designer
    CREATING AD-HOC REPORTS
  • Creating A Report Model
  • Creating A DSV
  • The Report Model Wizard
  • Updating The DSV and Report Model
  • Managing A Report Model
  • Publishing A Report Model
  • Creating Reports With Report Builder
    CREATING A REPORT SUBSCRIPTION

    ANALYSIS SERVICES FEATURES OVERVIEW

    ANALYSIS SERVICES FEATURES
  • Business Intelligence
  • Data Warehouse
  • OLAP Cube
  • Business Intelligence Design & Implementation
  • Needs Analysis Phase
  • Design Phase
  • Construction Phase
  • Implementation & Testing Phase
  • Maintenance Phase
    CREATING OLAP CUBES

    BIDS

    CREATING A CUBE
  • Creating A Cube Without a Data Source
  • Creating A Cube For An Existing Data Source
    DEPLOYING THE CUBE
  • Build The Project
  • Deploy The Project
  • Process The Cube
  • Aggregating Data
    QUERYING CUBES

    QUERYING CUBES

    VIEWING CUBE DATA WITH MANAGEMENT STUDIO

    SQL WITH MDX

    CREATING A REPORT BASED ON A CUBE

    MISCELLANEOUS ANALYSIS SERVICES FEATURES

    MISCELLANEOUS FEATURES
  • Cube Perspectives
    KEY PERFORMANCE INDICATORS (KPIS)

    DATA MINING

    SECURITY & ROLES
  • see the full course programme

    on request

    get more information on the programme directly from PTR Associates Ltd.

    Request information for free
    Get direct information on how to enrol, venues and availability...
     

    Ex-students

     
    Opinions
     
    Have you attended this course?

    Voice your opinion and help thousands of other users

    opinions

    from users who have attended
    this course.
    Get direct information on how to enrol, venues and availability...
     

    On PTR Associates Ltd

    Provider description
    PTR specialises in technical training, particularly in the areas of data communications & networking, internet/intranet, operating systems, programming languages and relational databases. Company specific courses are available for organisations that have several employees who all need training at the same time or who have a requirement for a tailored course. Closed courses typically provide cost benefits when there are at least four employees who need training simultaneously. Courses can be run at PTR's Training Centre or on-site if suitable facilities exist. Benefit from substantial discounts on technical training with our SAVE IT Scheme. If you, or your organisation has a training requirement of 10+ days then our Save IT Scheme may provide additional savings on your training.
    Advantages of studying with PTR Associates Ltd
    Vendor-independent & Generic Training - unbiased independent knowledge Small Class Sizes - increased interaction with lecturer Hands-on - increased learning efficiency Training Environment - modern, air-conditioned classrooms Course Notes - up-to-date, plain English, excellent reference material Training Experience - friendly, personal service
    Refreshments - morning and afternoon breaks with lunch arrangements second to none, at one of the many local restuarants ROI - our prices and quality mean an excellent Return on Investment   Lecturer Expertise - vendor certified with real-world product experience
    Course provider history
    PTR Associates Ltd was established in 1989.
    Specialises in
    Applications Programming Databases Operating Systems Data Communications and Networking Internet Scripting

    All courses

    by PTR Associates Ltd on emagister.

    See list of courses

    Get direct information on how to enrol, venues and availability...

    Training related to SQL Server

     
    International sites Spain  |  Italy  |  France  |  Mexico  |  Germany  |  UK  |  Japan  |  Argentina

    Words related to the courses viewed: sql sql server sql server 2005 database design

    emagister.com complies with the 15/1999 Organic Law dated 13th December (Spain), the Data Protection Law and holds the inscription code 2002010053 on the General Register of the Data Protection Agency. Copyright 1999/2000 - Grupo Intercom - All rights