To speak to a training advisor please call

training@coursemonster.com

All Courses / Microsoft Courses / Microsoft SQL Server 2008: Business Intelligence with SQL Server 2008 - (Microsoft, BI, SSRS, SSAS, SSIS, Data Warehouse, Mining)

Share: Follow us:

Bookmark with:

twiter

Print Page:

Microsoft SQL Server 2008: Business Intelligence with SQL Server 2008 - (Microsoft, BI, SSRS, SSAS, SSIS, Data Warehouse, Mining)

Online Training

Time stretched?

If you would prefer something more flexible, we can now offer Online Training related to this topic.

Click to see a list of courses »

Course Overview

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.

This course is the combination of our SQL Server 2008 Reporting Services (SSRS) and SQL Server 2008 Analysis Services (SSAS) training courses and has been written to cover all the main aspects of designing and building data warehouses and cubes using SQL Server 2008, Analysis Services and Integration Services, and how to make best use of the reporting functionality of Reporting Services.

For those Microsoft students looking to improve their skills with SQL Server, this Microsoft training course would be a good start.

Related Courses

Audience

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.

Skills Gained

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.

Prerequisites

Delegates should have some basic knowledge of SQL language queries.

Course Outline

Introduction to SQL Server 2008 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 deployment

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

Related Online Training

If you would prefer the flexibility of online training, use the link(s) below:

More Online Training>>

Top Selling Brands

How to make a booking for the SQL0220 course

Scheduled Dates

Request availability or enquire by clicking a date:

Sort by Location

London Region

London (Central)

£

1,995

London (Central)

£

1,995

Sort by Date

London Region

£

1,995

London Region

£

1,995

No Suitable Dates?

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

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

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