SQL Server 2005 Reporting Services and Analysis Services Overview Course
Course Description
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 pre-requisites:
Topics covered on the 1 day SQL Server 2005 Reporting Services and Analysis Services Overview course
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
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
KEY PERFORMANCE INDICATORS (KPIS)
DATA MINING
SECURITY & ROLES
This is an instructor led training course taught in a classroom based environment.
Course Classification:
Technical Training Course
Course Fee = £335 (excl.VAT)
Scheduled course dates
| May 2008 |
June 2008 |
July 2008 |
August 2008 |
September 2008 |
| 30 | 27 | 25 | 29 | 26 |
|
|
If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite SQL Training and bespoke SQL courses
If you want to attend the course but can't make the dates published then click here for details of our one-to-one training packages.
The SQL Server 2005 Reporting Services and Analysis Services Overview course qualifies for the PTR SAVE IT Scheme, which offers discounts on bookings for multiple courses and/or multiple delegates.
View SAVE IT Scheme Details
PTR Associates Limited
21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United Kingdom
Tel: 0118 979 4000 Fax: 0118 979 4035
Email: training@ptr.co.uk
|
|
