Cisco, Prince2, Microsoft, ITIL & ISEB IT Training Courses – CourseMonster
To speak to a training advisor please call
0800 40 848 40
training@coursemonster.co.uk
Browse Microsoft Training Courses

Designing a Reporting Solution Archicture using MS SQL Server 2005

Course Code: MS2797 (Also known as: M2797, MOC 2797)      Days: 2
Show all Microsoft Courses
Scheduled Dates
Locations filtered. Show all UK course locations.
Request availability or book by selecting a date:
Central London
City
London (WC1) 19/04/10 £ 595
London (W1) 20/05/10 £ 750
Prices exclude VAT.
Why do prices vary? Using CourseMonster, you search the schedules of over 100 training companies in one convenient location. Choose the city, date and price that best suits you.
No suitable dates?
I'd like a different date/location

Please click above and we will take care of the rest.

I’d like an onsite/bespoke course

Please click above and we will be happy to discuss the benefits of onsite and bespoke courses with you.

If suitable dates or locations are not available, click this link and we will arrange one for you

Course Overview

The purpose of this 2-day course is to teach Business Intelligence (BI) professionals working in enterprise environments to design a reporting solution architecture that supports their BI solution.

Students will go through the entire process from identifying report data to promoting the reporting solution to production. Students will scale a reporting solution. Students will also be taught best practices for collaborating with application developers to integrate applications and reporting services.

This course has been classified as IT Technical Training.

Audience

This course is intended for experienced BI professionals. The target students for this course already have an understanding of how to use the SQL Server 2005 tools to implement BI functionality, but need to develop their understanding of design principles and best practices when planning, implementing, and deploying a Reporting Services solution.

Skills Gained

  • Design a reporting solution.
  • Develop a reporting solution.
  • Collaborate with application developers to complete reporting and analytical interfaces.
  • Deploy and manage a Reporting Services solution.
  • Design security for a Reporting Services solution.
  • Optimise report rendering performance.

Prerequisites

  • Hands-on experience with database development tasks.
  • Experience of creating Transact-SQL queries and writing and optimising advanced queries (for example, queries that contain complex joins or subqueries).
  • Ability to create database objects such as tables, views, and indexes.
  • Foundational conceptual understanding of Business Intelligence presentation architecture. For example, data source management, the function of pivot tables versus grids versus charts, what drill down and linked reports are, and what schema abstraction (Report Builder) is.
  • Familiarity with SQL Server 2005 features, tools, and technologies. In particular, they must have used Report Designer, Report Manager, and Report Builder. Foundational understanding of Web-based architecture. For example, SSL, SOAP, and IIS-what they are and what their role is.
  • Understanding the difference between replication and ETL.

Course Outline

  • Module 1: Designing a Reporting Solution
  • Module 2: Developing a Reporting Solution
  • Module 3: Integrating Reporting Services with Applications
  • Module 4: Deploying and Managing a Reporting Solution
  • Module 5: Designing Security for a Reporting Solution
  • Module 6: Optimising Report Performance


How to make a booking for the MS2797 course
 

CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.