www.jbinternational.co.uk sales@jbinternational.co.uk Call Free 0800 028 6400

JB International 1345 High Road London, N20 9HR +44 (0) 20 8446 7555

 

Business Intelligence with SQL Server 2005 Training Course UK

Dates and full course list

This is a Featured Course

Business Intelligence with SQL Server 2005 Training Course Overview

Course Code:	SQL0080
Price:	£1995
Duration:	5 days
DATE:
Who should attend:	Anyone interested in getting raw data to the end user as information that has integrity, is retrieved quickly and requires little or no programming. Developers and analysts who need to design and build reports. Administrators who wish to deploy and manage reports.
Prerequisite Skills:	Delegates should have some basic knowledge of SQL language queries. Please see our associated course as a great way to get up to speed.Introduction to SQL primer training course

Business intelligence, also referred to as BI - is the collective term for technologies and software applications which are used to gather, provide access to, and analyse data and information about operations throughout the enterprise.

Business intelligence systems allow companies to understand factors affecting their business, such sales metrics, production, internal operations, which can help organisations make well-informed business decisions.

Course Content

This course is the combination of our SQL Server 2005 Analysis Services (SSAS) and SQL Server 2005 Reporting Services (SSRS) training courses.

This Business Intelligence training course has been written to cover all the main aspects of designing and building data warehouses and cubes using SQL Server 2005, Analysis Services and Integration Services, and how to make best use of the reporting functionality of Reporting Services.

Available as a public or closed course at our London training centre, delivered on-site as a bespoke, customised training course.

This course has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus. If you have a technical question, please email

Course Objectives

• A thorough understanding of the need for data warehouses and OLAP.
• A practical understanding of how to build star schemas and cubes in Analysis Services.
• Practical skills in the use of Integration Services to transform data into star schemas and cubes.
• Use Reporting Services to display cubes.
• Manually design reports in Reporting Services, and get the most out of the automated wizards.
• Report against both relational and OLAP databases.
• Deploy and administer reports
• Set up report subscriptions and control report security.

Business Intelligence with SQL Server 2005 Training Course Outline

Introduction - SSAS

Database Design

Review of third normal form and traditional OLTP databases
Introduction to designing OLAP star and snowflake schemas
Introduction to designing cubes

Analysis Services (using Business Intelligence Development Studio - BIDS)

Building fact tables
Building dimensions
Building cubes

Pivot Tables and Matrices

Browsing cubes in BIDS and Management Studio (SSMS)
Browsing cubes in Excel
Browsing cubes in Web Pages
Cubes in Reporting Services (SSRS)

Maintaining data warehouses

Backup and restoring star schemas
Backup and restoring of cubes
Cube security
Updating cubes

SQL Server Integration Services (SSIS)

Using SSIS Wizards
Using SSIS Designer
Using SSIS to normalise data
Using SSIS to denormalise data
Using SSIS to process cubes
Using SSIS as an ETL Tool
DataFlow tasks

Analysis Services programming

MDX queries and expressions
DMX data mining queries
ASSL and XMLA and AMO

Running and saving SSIS

Scheduling SSIS packages
Running from stored procedures
Saving to SQL Server
Saving to file

Advanced Analysis Services

Data mining
Deployment
Perspectives
Actions
Write-back

ProClarity Business Intelligence Tools

Using ProClarity Business Intelligence Tools with SQL Server 2005

Introduction to SQL Server 2005 Reporting Services

Architecture

Reporting Services
Report Server
Report Server databases
Report Designer
Report Manager
Report Models
Report Builder
Report Viewer

Designing a simple report

Report wizards
Report Designer
Basic formatting
Using templates
Previewing
Deploying

Working with data

SQL queries
Query Builder
MDX queries
DSV (data source views)
Grouping

Advanced reports

Formatting
Using expressions
Page breaks
Matrices
Headers
Graphics

Interactive reports

Parameters

Report Builder

Tables and matrices
Adding clickthrough
Sorting and filtering

Administration

Report Manager
Configuration Manager

Management areas

Managing Report Server
Managing security
Managing subscriptions
Managing access
Managing deploymen