SQL Server 2005: Business Intelligence

Show more Microsoft Training Courses

About this class

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 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.

Who will the lesson benefit?

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.

What delegates will learn

• 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.

What prerequisites are required

Delegates should have some basic knowledge of SQL language queries.

Contents of this class

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 deployment

SQL Server 2005: Business Intelligence / SQL0080

(C) AquinasTraining.co.uk - Contact Us